Workflow blocks
Read from Google Sheet
Read rows from a Google Sheet range
google/sheets-read-rows — Read rows from a Google Sheet range.
Where it appears
The Read from 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) | No | — | Optional name of the tab within the spreadsheet to target. Use literal text or <StepName.field>. |
range | text (supports references) | No | — | Optional A1-notation range to read (e.g. A1:D10). Leave empty to read all rows in the sheet. Accepts literal text or <StepName.field>. |
Inputs and outputs
Inputs are the configurable fields above. The block produces these outputs:
Outputs
Reference an output downstream with <Read From Google Sheet.field>.
| Name | Type | Description |
|---|---|---|
success | boolean | Whether read succeeded |
rows | array | Array of row arrays |
error | string | Error message if failed |
Example
A minimal configuration for this block:
{
"type": "google/sheets-read-rows",
"config": {
"spreadsheetId": "<PreviousStep.field>"
}
}Limits and failure modes
- Requires a connected Google integration. Calls fail if that integration is disconnected or its authorization has expired.
- Required field (
spreadsheetId) 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.