Learn RunMacro from basics to advanced.

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

Ctrl K

📊 Network

Automate Google Sheets via API in RunMacro

What it does

The Google Sheets Action command posts to an Apps Script Web App to delete a row, update a cell, or append a row on Google Sheets. The returned result drives IF/ELSE branching.

When to use it

Mark/delete a used account on the Sheet.
Update status after processing a row.
Write results (new accounts) to the Sheet.

Configuration steps

Create an Apps Script Web App for the Sheet and get its URL.
Add a Network › Google Sheets Action command, paste the Web App URL.
Choose the action: Delete / Update / Append; set the search value, columns, and new value.
Set IF/ELSE labels. Save.

Every option explained

Web App URL

The deployed Apps Script Web App URL for the Sheet.

Action (Delete / Update / Append)

The operation to perform on the sheet.

Sheet name + Search value + Search column

Identify the tab and the row to act on (search by value in the given column).

New value + Update column

For Update/Append: the new content and target column.

Auto append on delete + IF/ELSE labels

Deleting can auto-append a replacement row; IF on success, ELSE on failure.

Real example

Example: delete a used account from the Sheet

Google Sheets Action, action Delete, search {email} in Column 1.
IF label = deleted to continue.
ELSE = error on failure.

Tips & common mistakes

You must create an Apps Script Web App that handles the actions (delete/update/append) and returns JSON with status: success.

Combine with Random Online Text (reading the Sheet) to build a fetch → process → update account flow.