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

Get spreadsheet row

Get spreadsheet row

Gets the values of a specific row in a sheet of the spreadsheet.


Options​

Spreadsheet name​

Select the spreadsheet opened in the flow.

Row number​

Enter the number of the row whose values will be read.

Returns​

Javascript code​

js
actions["action-id"].values // values of each column of the given row (Any)
actions["action-id"].count  // number of values read (Number)

Field selection​

  • values — values of each column of the given row (Any)
  • count — number of values read (Number)

Rules and Conditions​

  • Every field is required.