Skip to main content

Sheet Exists

Description​

This activity checks whether a sheet with the given name exists inside the spreadsheet.

note

This activity works only inside Google Context activity.

Properties​

Location​

  • Spreadsheet Path / Id - Specify the relative spreadsheet path or Id inside Google Drive.
  • Sheet Name - Specify the name of the sheet which you want to check whether it exists or not.

Misc​

  • DisplayName – Add a display name to your activity.
  • Private – Logs the variable and argument values at the Verbose level when unchecked.

Optional​

  • Continue On Error – Specifies if the automation should continue even when the Activity throws an error. This field only supports Boolean values (True, False). The default value is False.
note

Catches no error if this Activity is present inside the Try-Catch block and the value of this property is True.

Output​

  • Sheet Exists - Returns the boolean(true or false) value indicating whether the sheet exists or not.

Example​

Download Example

Sheet Exists