Skip to main content
Spreadsheets

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.