# Write Range

> `UiPath.GSuite.Activities.WriteRange`

`UiPath.GSuite.Activities.WriteRange`

## Description

Writes the content from a DataTable to a specified Google spreadsheet.

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

#### In the body of the activity

* **Spreadsheet** - The ID of the SpreadSheet that includes the sheet and cells you want to write in. This property supports `String` variables and string formatted values. When entering your value, use the exact File 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 [Create New Spreadsheet](https://docs.uipath.com/activities/other/latest/productivity/gsuite-create-new-spreadsheet) activity.
* **Sheet** - The name of the sheet where you want to write the DataTable content. This property supports `String` variables and string formatted values. The default value is "Sheet1".
* **Starting cell** - The address of the first cell that you want to start writing in. This property supports `String` variables and string formatted values. The default value is "A1". All cells that contain content in the row specified are written.
* **Data table** - The DataTable that you want to write into the SpreadSheet. This property supports `DataTable` variables and DataTable formatted values.
* **Write headers** - If selected, the header row in the data table is written in the spreadsheet. If not selected, the header row is ignored when the data table is written. This option is selected by default.

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

* **DataTable** - See **Data table** in the body of the activity.
* **Spreadsheet** - See **Spreadsheet** in the body of the activity.
* **SheetName** - See **Sheet** in the body of the activity.
* **SpreadsheetID** - The ID of the spreadsheet file to use. This property supports `String` variables and string formatted values.
* **StartingCell** - See **Starting cell** in the body of the activity.

**Misc**

* **IsInsideBatchUpdateScope** - If selected, indicates the activity is added inside a [Batch Spreadsheet Updates](https://docs.uipath.com/activities/other/latest/productivity/gsuite-batch-update-values-scope) activity. This field supports Boolean values.
* **Private** - If selected, the values of variables and arguments are no longer logged at Verbose level. This field supports Boolean values.

**Options**

* **IncludeHeaders** - See **Write headers** in the body of the activity.

**Output**

* **UpdatedRange** - Saves the modified range from the sheet for use in other Google Sheets activities.