Activities
latest
false
Productivity Activities
Last updated Jul 9, 2024

Add New Sheet

UiPath.GSuite.Activities.AddNewSheet

Description

Creates a new sheet inside a specified Google spreadsheet. This activity must be added inside a Use Google Spreadsheet activity.

Project compatibility

Windows - Legacy | Windows

Configuration

In the Body of the Activity
  • Spreadsheet - A reference to a Google Spreadsheet where the new sheet is to be created. Typically obtained via the Use Google Spreadsheet activity. This property supports IGoogleSheetTarget variables.
  • Sheet name - The name for the new sheet. This property supports String variables and string formatted values. The default value is "New Sheet".
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

  • Spreadsheet - See Spreadsheet in the body of the activity.
  • SheetName - See Sheet name in the body of the activity.
  • SpreadsheetID - The ID of the spreadsheet where you want to add the new sheet. This property supports String variables and string formatted values. When entering your value, use the exact ID, or the output property variable from a previous Find Files And Folders or Copy File 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.
  • PositionIndex - Specifies the new sheet location in the spreadsheet. By default (if the property is empty), a new sheet is added to the end of the spreadsheet and the first sheet is added at index 0. 
  • Rows - Specifies the number of rows you want to create in the initial sheet. This property supports Int32 variables and Int32 formatted values.
  • Description
  • Project compatibility
  • Configuration

Was this page helpful?

Get The Help You Need
Learning RPA - Automation Courses
UiPath Community Forum
Uipath Logo White
Trust and Security
© 2005-2024 UiPath. All rights reserved.