# Add Delete Rows

> `UiPath.GSuite.Activities.AddDeleteRows`

`UiPath.GSuite.Activities.AddDeleteRows`

## Description

Adds empty rows or removes existing rows from a specified sheet.

### 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

#### 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

* **NumberOfItems** - The number of rows that you want to add or delete. This property supports `Int32` variables and `Int32` formatted values.
* **RowPosition** - The position where you want to add the column, or the position of the column that you want to delete. This property supports `Int32` variables and Int32 formatted values.

  + Specify the position by using the row number (e.g., 1, 10).
* **SheetName** - The name of the sheet that you want to add rows to or delete columns from. This property supports `String` variables and string formatted values. The default value is "New Sheet".
* **SpreadSheetID** - The ID of the spreadsheet that contains the sheet you want to add rows to or delete rows from. 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](https://docs.uipath.com/activities/other/latest/productivity/gsuite-find-files) or [Copy File](https://docs.uipath.com/activities/other/latest/productivity/gsuite-copy-drive-file) activity.

#### Options

* **ChangeMode** - Specifies whether you want to add or delete rows. Select from two options: **INSERT** or **DELETE**.

#### Misc

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