Add Sheet

Description

This activity adds an empty sheet to the specified spreadsheet in the drive folder.

note

This activity works only inside Google Context activity.

Properties

Location

• Spreadsheet Path / Id - Specify the relative spreadsheet path or Id inside Google Drive.

Misc

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

Optional

• Sheet Name - Specify the name of the new Sheet. By default, it will be named 'Sheet<N>', where N is a number following the largest number used in the current sheet names.
• Index - Specify the zero-based sheet index, which describes where you want to add the Sheet. By default, it will insert at the end.
• 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 - Returns the metadata of the added Sheet of type SheetProperties.

Example

Download Example