Skip to main content
Docs
Go to the Studio
Roberty Studio
RPARows

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, for example Clientes.

Row number in the sheet​

Enter the row's number in the sheet, the same one shown on the side of Google Sheets (not its position inside the table). The header row is not a data row: in a table whose header is on row 1, the first data row is 2; with the header on row 5, it is 6.

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 is the sheet's and must be a data row of the table: the header row, or a row above it, stops the run with an error.
  • 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.