Workflow blocks
Update Row in Google Sheet
Overwrite cells at a specific range (e.g. Sheet1!A2:E2)
google/sheets-update-row — Overwrite cells at a specific range (e.g. Sheet1!A2:E2).
Where it appears
The Update Row in Google Sheet block lives in the Integrations group of the Workflow Builder. Connect the Google integration before adding it.
Fields
| Field | Type | Required | Default | Description |
|---|---|---|---|---|
spreadsheetId | text (supports references) | Yes | — | The target Google Sheet, given as a spreadsheet ID or its full URL. Use literal text or <StepName.field>. |
range | text (supports references) | Yes | — | A1 notation pointing to the exact cells to overwrite. Required — without a row number this would overwrite row 1. |
rowData | code | Yes | — | JSON array of rows. The first row is written to the start of the range; additional rows continue downward. |
Inputs and outputs
Inputs are the configurable fields above. The block produces these outputs:
Outputs
Reference an output downstream with <Update Row In Google Sheet.field>.
| Name | Type | Description |
|---|---|---|
success | boolean | Whether write succeeded |
updatedRows | number | Number of rows updated |
error | string | Error message if failed |
Example
A minimal configuration for this block:
{
"type": "google/sheets-update-row",
"config": {
"spreadsheetId": "<PreviousStep.field>",
"range": "<PreviousStep.field>",
"rowData": "..."
}
}Limits and failure modes
- Requires a connected Google integration. Calls fail if that integration is disconnected or its authorization has expired.
- Required fields (
spreadsheetId,range,rowData) must be set, or the block fails validation before it runs. - On failure the
erroroutput is populated; downstream blocks that reference other outputs may not receive values.