Workflow blocks
Append Row to Google Sheet
Add new rows to the end of a sheet
google/sheets-append-row — Add new rows to the end of a sheet.
Where it appears
The Append Row to 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>. |
sheetName | text (supports references) | Yes | — | Name of the tab within the spreadsheet to append rows to (e.g. Sheet1). Use literal text or <StepName.field>. |
rowData | code | Yes | — | JSON array of rows with scalar placeholders in quoted cells, or a single upstream placeholder that resolves to rows. |
Inputs and outputs
Inputs are the configurable fields above. The block produces these outputs:
Outputs
Reference an output downstream with <Append Row To Google Sheet.field>.
| Name | Type | Description |
|---|---|---|
success | boolean | Whether write succeeded |
updatedRows | number | Number of rows appended |
error | string | Error message if failed |
Example
A minimal configuration for this block:
{
"type": "google/sheets-append-row",
"config": {
"spreadsheetId": "<PreviousStep.field>",
"sheetName": "<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,sheetName,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.