Retrieve sheets count action

The Retrieve sheets count action of the Google Sheets package enables you to get the number of sheets available in the current workbook and store it in a number variable

Settings

  • Enter the session name or select an existing variable used in the Session name field.
  • Select the Exclude Hidden Worksheets option to exclude the hidden worksheet or not and assign the count to a variable.
  • From the Assign the output to a variable listdrop-down, specify the variable to which you want to assign the output.