Read Range - Learn WorkflowDog

The Read Range action reads cell values from an A1 range. Choose whether the outer output list represents rows or columns and whether values use their display formatting.

Inputs

Input	Type	Required	Description
Third-party account	Google account	Yes	Account with read access.
Spreadsheet ID or URL	String	Yes	Spreadsheet to read.
Range	String	Yes	A1 range, such as `Sheet1!A1:B20`.
Major Dimension	`Rows` or `Columns`	No	Structure of the outer list. Defaults to Rows.
Return Formatted Values	Boolean	No	Return display strings instead of raw values. Default `false`.

Outputs

Output	Type	Description
Rows or Columns	List of lists	Cell values grouped by the selected major dimension.

Formatted values preserve display text such as $1,234.00 or a rendered date. Raw values are better for numeric comparisons and calculations.

Sheets can omit trailing empty cells and rows from returned arrays. Do not assume every inner list has the full requested width.

Example

Set Range to Sheet1!A2:D and keep Major Dimension set to Rows. Repeat over the returned Rows to process each row’s cells individually.