Learn RunMacro from basics to advanced.

Everything you need to start and master RunMacro — from basic commands to advanced automation workflows.

Ctrl K

📥 File

Get a data row from CSV/Excel/Google Sheet in RunMacro

What it does

The Data Source - Get Row command reads a row from a data source (CSV, TXT, Excel, or Google Sheet via Apps Script) and assigns columns to variables. It can take the first, a random, or the next unprocessed row; and branch IF/ELSE on whether data exists.

When to use it

Process an account/data list row by row.
Take the next unprocessed row (by a status column) to run in order.
Load Google Sheet data into variables.

Configuration steps

Add a File › Data Source - Get Row command.
Choose the source (CSV/TXT/Excel/Google Sheet) and the file/URL.
Choose the mode: first / random / next unprocessed.
(Optional) set a variable prefix, status column, IF/ELSE labels. Save.

Every option explained

Source + File/URL + Sheet

The source type and data location; for Excel/Sheet you can specify the sheet name.

Mode (first/random/next unmarked)

How to pick a row. "Next unmarked" uses a status column and an unused value.

Has header row

Whether the first row is a header (used as variable names) or data.

Variable prefix + TXT variable

A prefix added to column-based variable names; for TXT, the variable holding the whole line.

Status column + mark processing

The status-tracking column; can auto-mark the fetched row as "processing".

IF/ELSE labels + no-data action

Data found jumps IF, none jumps ELSE; when no data, continue or stop.

Real example

Example: get the next unprocessed CSV row

Data Source Get Row, CSV source, Next-unmarked mode, status column status.
Columns are assigned to variables (e.g. {email}).
After processing, use "Mark Row" to write done.

Tips & common mistakes

The trio Get Row → process → Mark Row forms a clean list-processing loop.