Skip to main content
Go to the Studio
Spreadsheets

List spreadsheet sheets

List spreadsheet sheets

Returns a list with the names of every sheet in a spreadsheet opened in the flow.


Options​

Spreadsheet​

Select the spreadsheet opened in the flow.

Returns​

Javascript code​

js
actions["action-id"].sheets // list with the names of every sheet (List)
actions["action-id"].count  // total number of sheets (Number)

Field selection​

  • sheets — list with the names of every sheet (List)
  • count — total number of sheets (Number)

Rules and Conditions​

  • The Spreadsheet field is required.