Skip to main content

Create Spreadsheet

UiPath.GSuite.Activities.CreateSpreadsheetConnections

Description​

Creates a new spreadsheet.

Scopes​

This activity requires the following scopes:

Project compatibility​

Windows | Cross-platform

Configuration​

  • Google Sheets connection - The connection for the Google Workspace account to use in the activity.
  • Folder - The folder where to create the spreadsheet. If left empty, the spreadsheet is created in the root folder. This property supports String variables and string formatted values. Use the See more button menu to switch to Use variable or Url or ID input modes.
    • Select the Reload File Data option if you've modified your folders and need to retrieve the latest data.
  • Spreadsheet name - The name of the spreadsheet to be created. This property supports String variables and string formatted values. This property supports String variables and string formatted values.

Additional options​

Input

  • First sheet name - The name of the first sheet in the spreadsheet. Set to Sheet1 by default. This property supports String variables and string formatted values.
  • If the spreadsheet already exists - The expected behavior when a spreadsheet with the same name already exists in the destination folder. Choose one of the available options from the dropdown menu:
    • Add as separate file - Adds the file without renaming if even if an item with the same name exists.
    • Don't replace - Fails if an existing item is found. Default option.
    • Auto rename - Auto renames the new item by appending a number.
    • Replace - Replace the existing item. Fails if multiple items with the same name exist.

Output

  • Save spreadsheet for later - Saves the newly created spreadsheet. Automatically generated output variable. You can use it as it is or save it with a different name. You can use this in other activities, such as Add Sheet.

Example​

docs image

For more details, also check the following resources::