Delete Sheet

UiPath.GSuite.Activities.DeleteSheetConnections

Description

Deletes the specified sheet from the specified spreadsheet.

Scopes

This activity requires the following scopes:

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

OR

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

Project compatibility

Windows | Cross-platform

Configuration

• Google Sheets connection - The connection for the Google Workspace account to use in the activity.

• Spreadsheet - The spreadsheet from which to delete a sheet. Select the Folder icon to browse Google Drive folders and select a spreadsheet. This option accepts input as IResource. Use the See more button menu to switch to Use variable or Url or ID input modes.

  • If you select Use variable, you can use the output variable from other activities, such as Create Spreadsheet.
  • Spreadsheet URL - The URL or ID of the spreadsheet of interest. This field is available when Url or ID is selected as the input mode. This property supports String variables and string formatted values. For details, see How to Retrieve Spreadsheet IDs.
  • Select the Reload File Data option if you've modified your folders and need to retrieve the latest data.

• Sheet name - The name of the sheet to be deleted. This field is prepopulated with information retrieved from the selected spreadsheet. This property supports String variables and string formatted values.

  • Select the Update Sheets option if you've modified your sheets and need to retrieve the latest data.

Example

For more details, also check the following resources::

• Sheets activities
• Create Spreadsheet
• Add Sheet
• Rename Sheet