Get number of rows action

The Get number of rows action in the Google Sheets package enables you to get the number of rows that are not empty or contain data.

Settings

  • Enter the name of the session used to open the current spreadsheet with the Open spreadsheet action.
  • Select the Non-empty rows option to get the number of rows that are not empty or the Total rows with data option to get the number of rows that contain data.
  • Select the number variable from the Assign output to a variable field to store the output.