Files and outputNeeds verification

Read Spreadsheet Block

Read Spreadsheet loads selected spreadsheet data and writes rows into an output variable.

At a glance

Best for

Spreadsheet input data

Output

Rows array

Cloud support

CSV/text and JSON arrays

Error handle

What it does

Read Spreadsheet turns spreadsheet-like input into variables that later Blocks can loop over or use in fields.

Cloud support is narrower than local UI expectations: XLS and XLSX are not currently supported by the cloud worker.

Use it when

Load a CSV list of URLs for a Flow.
Read rows that should drive a Loop.
Use selected spreadsheet columns as input values.

Do not use it when

The source is a Google Sheet connection; use Read Google Sheet.
Cloud Run needs XLS or XLSX support today.
The file should be created from variables; use Create Spreadsheet.

Settings

Read Spreadsheet needs a selected spreadsheet, row/column selection, header behavior, and output variable.

Spreadsheet

Required: Yes

Variables: No
Description: Selected spreadsheet input from the app.

Selection

Required: No

Variables: No
Description: Rows, columns, or ranges to read.

Include headers

Required: No

Variables: No
Description: Turns rows into objects keyed by header names.

Output variable

Required: Yes

Variables: Variable name
Description: Variable that receives the rows.

Setting	Required	Variables	Description
Spreadsheet	Yes	No	Selected spreadsheet input from the app.
Selection	No	No	Rows, columns, or ranges to read.
Include headers	No	No	Turns rows into objects keyed by header names.
Output variable	Yes	Variable name	Variable that receives the rows.

Outputs

Read Spreadsheet writes row data to the output variable.

{{outputVariableName}}array<object> | array<array>

Rows from the spreadsheet selection.

Example Flow

Read Spreadsheet usually feeds Loop, Go To URL, or Template Blocks.

Read rows from a spreadsheet.
Loop over the rows.
Use row fields in browser action 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.

Cloud Run cannot read the file.

Check: Check the file format.
Fix: Use CSV/text or JSON-array input for Cloud Run until XLS/XLSX support is added.

Rows have the wrong keys.

Check: Check Include headers and selected header row.
Fix: Enable headers only when the first selected row contains field names.

Symptom	Check	Fix
Cloud Run cannot read the file.	Check the file format.	Use CSV/text or JSON-array input for Cloud Run until XLS/XLSX support is added.
Rows have the wrong keys.	Check Include headers and selected header row.	Enable headers only when the first selected row contains field names.

Local and cloud runs

Local app reading can use app-provided spreadsheet data. Cloud currently supports CSV/text and JSON arrays, but not XLS/XLSX.

Blocks

Understand how Blocks connect and pass state through a Flow.

Runs and outputs

Inspect Block output, errors, and variables after a run.