Learn RunMacro from basics to advanced.

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

Ctrl K

🌐 Random

Get random/sequential data from a Google Sheet or URL in RunMacro

What it does

The Random Online Text command downloads data from a URL (Google Sheet, CSV, pastebin...) and takes a row your way: random, sequential, or search by value. It can split columns into variables and branch IF/ELSE.

When to use it

Use an account/data list on Google Sheets for automation.
Take rows sequentially across runs.
Find a row by a value (e.g. by email) then split columns into variables.

Configuration steps

Add a Random › Random Online Text command.
Paste the URL (Google Sheet auto-converts to CSV) and a sheet name if needed.
Choose a mode: Random / Sequential / Search by value (with a search column).
(Optional) enter a variable list to split columns; set IF/ELSE labels. Save.

Every option explained

URL + Sheet name

The data source. For Google Sheets, RunMacro builds the CSV export link; the sheet name selects the tab.

Mode: Random / Sequential / Search

Take a random row, take rows in order, or find a row matching a value.

Search value + column

In Search mode: the value to match and the column to check (1-based; 0 = any column).

Assign variables

A comma list of variable names to split the row columns into.

Cache seconds + IF/ELSE labels

Cache time to avoid refetching; IF label on success, ELSE on error/not found.

Real example

Example: take accounts sequentially from a Sheet

Paste the Google Sheet URL with email, password columns.
Choose Sequential mode, assign variables email,password.
Use {email}, {password} to fill the login form.

Tips & common mistakes

Set the Google Sheet to "anyone with the link can view" so RunMacro can fetch the CSV.

Sequential mode remembers the row position per session; it loops back when the list ends.