# Delete Range

> `UiPath.Gsuite.Activities.DeleteRangeConnections`

`UiPath.Gsuite.Activities.DeleteRangeConnections`

## Description

Deletes a specified range.

### 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 Google spreadsheet to use. Select the **Folder**![docs image](https://dev-assets.cms.uipath.com/assets/images/activities/activities-docs-image-300958-818994f9.webp) 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 (`String`) modes.
  + If you select **Use variable**, you can use the output variable from other activities, such as [Create Spreadsheet](https://docs.uipath.com/activities/other/latest/productivity/google-workspace-sheets-create-spreadsheet-connections).
  + **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](https://docs.uipath.com/activities/other/latest/productivity/google-workspace-retrieve-spreadsheet-ids).
  + Select the **Reload File Data** option if you've modified your folders and need to retrieve the latest data.
* **Range** - Select a range or enter a custom one (a full custom range can be used, i.e., `Sheet1!A1:C10`). This field is prepopulated with information retrieved from the selected spreadsheet. This property supports `String` variables and string formatted values.
  + Select the **Update Ranges** option if you've modified your sheets and need to retrieve the latest data.
* **Delete behavior** - Indicates the delete mode. The available options are:
  + **Clear** - Clear the selected range. Default option.
  + **Rows** - Delete entire sheet rows of the selected range.
  + **Columns** - Delete entire sheet columns of the selected range.

## Example

![docs image](https://dev-assets.cms.uipath.com/assets/images/activities/activities-docs-image-293965-e3f33cea.webp)

For more details, also check the following resources::

* [Sheets activities](https://docs.uipath.com/activities/other/latest/productivity/sheets-activities)
* [Add Sheet](https://docs.uipath.com/activities/other/latest/productivity/google-workspace-sheets-add-sheet-connections)
* [Write Range](https://docs.uipath.com/activities/other/latest/productivity/google-workspace-sheets-write-range-connections)
* [For Each Row in Spreadsheet](https://docs.uipath.com/activities/other/latest/productivity/google-workspace-sheets-for-each-row-connections)