Read Range

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

Google Sheets: Read Range (Sheet1!A2:D)
  → Repeat over Rows
  → Process each row's cells

Update Table Row(s)Update selected columns in one or more numbered Google Sheets rows.

Overview

Fundamentals

Web, Files & Data

AI

Scraping & Rendering

Google Workspace

Email, CRM & Scheduling

Databases & Tables

Microsoft

Inputs

Outputs

Example

​Inputs

​Outputs

​Example

Inputs

Outputs

Example