Skip to main content
Go to the Studio
Values

Get values

Get values

Gets the values of a cell range.


Options​

Google Sheets connection​

Select the Connection action set up in the flow.

Spreadsheet ID​

Enter the ID of the spreadsheet. The ID can be found in the spreadsheet URL: docs.google.com/spreadsheets/d/{spreadsheetId}/edit.

Range​

A1 notation of the range to read, e.g. Página1!A1:D10 (to get every value, enter just the tab name).

Returns​

Javascript code​

js
actions["action-id"].range // A1 notation of the range that was read (Text)
actions["action-id"].values // values of the cell range, as a list of rows (Array)

Field selection​

  • range — A1 notation of the range that was read (Text)
  • values — values of the cell range, as a list of rows (Array)

Rules and Conditions​

  • The Google Sheets connection, Spreadsheet ID and Range fields are required.
  • The range must be in A1 notation (e.g. Página1!A1:D10). To get every value of a tab, enter just the tab name (e.g. Página1).
  • If the given range does not exist in the spreadsheet (e.g. a missing tab), the robot stops with an error.
  • If the range exists but has no value filled in, the values field returns an empty list.