Read Google Sheet Block
Read Google Sheet reads rows from a spreadsheet and stores them as objects or raw rows depending on header settings.
At a glance
What it does
Read Google Sheet turns spreadsheet rows into Flow data.
When headers are enabled, rows become objects keyed by header names. Without headers, rows are returned as raw arrays.
Use it when
- Read URLs or search terms from a shared sheet.
- Feed a Loop with rows maintained by a team.
- Use selected Google Sheet columns in browser actions.
Do not use it when
- The data is in a local file; use Read Spreadsheet.
- No Google connection is configured.
- The sheet contains very large data that should be filtered before use.
Settings
Read Google Sheet needs a connection, spreadsheet ID, optional sheet name, header behavior, column selection, and output variable.
Google connection
Required: Yes- Variables
- No
- Description
- Connection used to access Google Sheets.
Spreadsheet ID
Required: Yes- Variables
- Yes
- Description
- Google spreadsheet to read.
Sheet name
Required: No- Variables
- Yes
- Description
- Sheet tab to read. Empty reads the first sheet.
Include headers
Required: No- Variables
- No
- Description
- Uses the first row as object keys.
Output variable
Required: Yes- Variables
- Variable name
- Description
- Stores the read rows.
Outputs
Read Google Sheet writes rows to the output variable.
{{outputVariableName}}array<object> | array<array>Rows from the spreadsheet.
Example Flow
Use Read Google Sheet before Loop when sheet rows should drive browser actions.
- Read rows from Google Sheets.
- Loop over the rows.
- Use row values in later Blocks.
Errors and fixes
Start with symptoms visible in the editor or Inspector, then check the earliest Block that produced the wrong page state, variable, or output.
Rows are arrays instead of objects.
- Check
- Check Include headers.
- Fix
- Enable headers when the first row contains field names.
The wrong tab is read.
- Check
- Check Sheet name.
- Fix
- Enter the exact tab name or leave it empty to read the first sheet.
Local and cloud runs
Both runtimes read from the configured Google connection. Empty sheet name reads the first sheet.