Every time an API connection runs, it sends a fixed request — the same URL, the same headers, the same body. If a parameter changes (a date, a tenant ID, an API key stored in a cell), you have to open the connection and edit it manually.

With dynamic placeholders, you can reference a cell in your destination spreadsheet directly inside the request. Sheetgo reads the cell at run time and injects its current value before sending — no edits needed.

Step 1 — Create or open an API Source connection

In app.sheetgo.com, create a new connection or open an existing one. Under Select source, choose HTTP Request (JSON).

Step 2 — Add a placeholder to your request

In the URL, Headers, or Body field, type a placeholder using the syntax below. The value will be pulled from your destination spreadsheet at run time.

Step 3 — Save and run

Click Finish and Save. Every time the connection runs, Sheetgo resolves the placeholders and injects the current cell values before sending the request.

{{TabName!CellRef}}

If your tab name contains a space or special character, wrap it in single quotes:

When in doubt, always quote the tab name — it works for any name.

Placeholders work in three parts of the HTTP Request (JSON) source configuration:

URL

Headers

Body

You have a tab named Config in your destination spreadsheet:

Configure your request body as:

When the connection runs, Sheetgo sends:

Update B2 to 2026-12-31 in the spreadsheet — the next run picks it up automatically, with no changes to the connection.

If a placeholder references a tab or cell that does not exist, or the cell is empty, Sheetgo logs a clear error and does not send the request. This prevents broken or incomplete API calls from running silently.