StyloDocs
Workflow blocks

Read from Google Sheet

Read rows from a Google Sheet range

View as Markdown

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

FieldTypeRequiredDefaultDescription
spreadsheetIdtext (supports references)YesThe target Google Sheet, given as a spreadsheet ID or its full URL. Use literal text or <StepName.field>.
sheetNametext (supports references)NoOptional name of the tab within the spreadsheet to target. Use literal text or <StepName.field>.
rangetext (supports references)NoOptional 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>.

NameTypeDescription
successbooleanWhether read succeeded
rowsarrayArray of row arrays
errorstringError 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 error output is populated; downstream blocks that reference other outputs may not receive values.

On this page