Create New Spreadsheet

UiPath.GSuite.Activities.CreateNewSpreadSheet

Description

Creates a new spreadsheet in Google Drive.

Scopes

This activity requires the following scopes:

• https://www.googleapis.com/auth/drive

OR

• https://www.googleapis.com/auth/spreadsheets

Project compatibility

Windows - Legacy | Windows

Configuration

In the Body of the Activity

• Spreadsheet name - The name of the new spreadsheet. This property supports String variables and string formatted values. The default value is TestSpreadsheet.
• Destination folder - Indicate the folder where to create the spreadsheet. This property supports String variables and string formatted values. When entering your value, use the exact Folder ID, or the output property variable from a previous Find Files And Folders or Create Folder activity. If not specified, the spreadsheet is created in the root folder.
• New Spreadsheet ID - The ID of the newly created spreadsheet.

Properties Panel

Common

• ContinueOnError - If set, the remaining activities are executed if the current activity fails. This field supports Boolean values.
• DisplayName - The display name of the activity. This property supports String variables and string formatted values.

Input

• See the options in the body of the activity.

Misc

• Private - If selected, the values of variables and arguments are no longer logged at Verbose level. This field supports Boolean values.

Options

• Columns - Specifies the number of columns you want to create in the initial sheet. This property supports Int32 variables and Int32 formatted values.
• Rows - Specifies the number of rows you want to create in the initial sheet. This property supports Int32 variables and Int32 formatted values.

Output

• FileURL - The URL of the new spreadsheet.
• SpreadsheetID - See New Spreadsheet ID in the body of the activity.