Docs
RunMacro Documentation
Create your first robot, then go further as needed.
Clear step-by-step guides to create, run, and improve robots for repetitive computer work.
Get random/sequential data from a Google Sheet or URL in RunMacro
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.
Prerequisites#
- Add Random Online Text to the macro.
- Prepare the data or target that Random Online Text will use.
Supported modes#
- RunMacro Runner
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.
Screenshots & video#
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.
When not to use it#
- Do not use it for secrets, unauthorized endpoints, or queues requiring atomic consumption.
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#
Expected result#
After execution, Random Online Text completes the described action and makes its result available to the next step.
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.
Limitations and failure cases#
- It depends on network, sharing, source format, and cache; multiple runners can reuse a row.
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.
Verification details#
commands/random_cmd.py
