Skip to main content
Go to the Studio
Rows

Get row

Get row

Gets a row of the table by its number.


Options​

Google Sheets connection​

Select the Google Sheets 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.

Table name​

Enter the name of the table (named range), for example Clientes.

Row number​

Enter the number of the row to get, counting the table's header row as row 1 (e.g. the first data row is row 2).

Returns​

Javascript code​

js
actions["action-id"].rowNumber // number of the row read (Number)
actions["action-id"].row // the row read, as an object (Any)

Field selection​

  • rowNumber — Number of the row read.
  • row — The row read, as an object matching each column name to its value.

Rules and Conditions​

  • The Google Sheets connection, Spreadsheet ID, Table name and Row number fields are required.
  • The Row number must be a whole number greater than or equal to 1, counting the table's header row as 1.
  • The given table must exist in the spreadsheet; otherwise the robot stops with a table-not-found error.
  • If the given row number is outside the table's bounds (a row that does not exist), the robot stops with a row-not-found error.