Skip to main content
Go to the Studio
Spreadsheets

Count Spreadsheet Rows

Count Spreadsheet Rows

Counts and returns the number of filled rows in a sheet of the spreadsheet, and also tells the next row available for insertion.


Options​

Sheet name​

Enter the sheet whose rows will be counted.

Returns​

Javascript code​

js
actions["action-id"].count   // total number of rows with content (Number)
actions["action-id"].nextRow // number of the first empty row available (Number)

Field selection​

  • count — total number of rows with content (Number)
  • nextRow — number of the first empty row available for insertion (Number)

Rules and Conditions​

  • The fields are required.