Get Values

Reads cell values from a Google Sheets A1 range.

Type

google.sheets.get_values

Block Tool Sheets

Foldergoogle/sheets

Channels

Any

Pipe

Value

Scope

Any

ServiceRequired

Google

CapabilityRequired

Google Sheets

Listed only when a matching connected service is enabled.

Get Values Reads cell values from a Google Sheets A1 range.

Configure

Setting	Description
Spreadsheet ID	Spreadsheet id
Range	A1 notation, e.g. `Sheet1!A1:C10`. You can insert variables, e.g. `{{ tab }}!A:Z`
Value render	Formatted, unformatted, or formula

Pipe schema

| Key | Type | Description | | --- | --- | | spreadsheetId | text | Spreadsheet id | | range | text | Returned range | | values | list | 2D array of cells |