Learn RunMacro from basics to advanced.

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

Ctrl K

✔️ File

Mark the processed data row in RunMacro

What it does

The Data Source - Mark Row command updates the row just fetched (by Get Row) — usually writing a status column to done. It supports CSV, Excel, and Google Sheet, and can update extra columns.

When to use it

Mark a row processed so it is skipped next time.
Write a result/note back to the same row.
Chain after Get Row in a loop.

Configuration steps

Make sure Get Row ran before this.
Add a File › Data Source - Mark Row command.
Set the status column and value (e.g. done); optionally add extra column updates. Save.

Every option explained

Status column + value

The column and value to mark the row (default status = done).

Extra column updates

A list of extra column=value pairs to write to the row (variables supported).

Create column if missing

Auto-add a new column if the target column does not exist.

Real example

Example: write done after processing

After processing the fetched row.
Mark Row: column status = done.
Next run, Get Row skips this row.

Tips & common mistakes

For Excel, close the file in Excel before running to avoid write-lock errors.