You can reference a cell from your destination Google Sheet anywhere in an API Source request. When the connection runs, the placeholder is replaced with that cell's live value before the request is sent — no need to edit the connection each time the value changes.
Requirement: The connection's destination must be a Google Sheets file. Other destinations (Excel, BigQuery, CSV, etc.) ignore the syntax — placeholders are sent as literal text to your API.
For the full syntax including filters, date formatting, and A:last, see A1 Notation — Advanced Guide.
The syntax
{{TabName!CellRef}}
Two opening braces
{{and two closing braces}}.TabName — the worksheet (tab) name in your destination spreadsheet.
! — separator.
CellRef — a single cell, like
A1,B4,AB42.
Placeholder | What it returns |
| Cell A1 of Sheet1 |
| Cell B4 of Config |
| Cell C12 of Settings |
Tab names with spaces
If your tab name has a space or any special character, wrap it in single quotes:
Tab name | Placeholder |
Settings |
|
My Settings |
|
2026 Plan |
|
When in doubt, always quote the tab name — quoted names always work.
Where you can use it
Placeholders work in three places of your HTTP Request (JSON) source configuration:
URL
https://api.example.com/products/{{Config!A1}}
https://api.example.com/search?country={{Config!B1}}
Headers
Authorization: Bearer {{Config!A1}}
X-Tenant-Id: {{Config!B1}}
Body
{
"year": "{{Config!B4}}",
"country": "{{Config!C4}}"
}
A complete example
You have a tab named Config in your destination Google Sheet:
Cell | Value |
B4 | 2026 |
C4 | BR |
Configure your API request body as:
{
"filters": {
"year": "{{Config!B4}}",
"country": "{{Config!C4}}"
}
}
When the connection runs, Sheetgo sends to your API:
{
"filters": {
"year": "2026",
"country": "BR"
}
}
Change B4 to 2027 in the spreadsheet and run again — the request updates automatically without editing the connection.
Summary
Want to… | Use |
Pull a value from a specific cell |
|
Reference a tab with spaces |
|
Use the value in URL / header / body | All three are supported |
Things to remember:
Always use double braces:
{{...}}. Single braces{...}are not recognized.The connection's destination must be Google Sheets.
If you mistype a tab or cell name, the placeholder is sent as literal text to your API — double-check spelling.
Need filters, date formatting, A:last, or error-handling details? See the Advanced Guide.