# Batch Spreadsheet Updates

> `UiPath.GSuite.Activities.BatchUpdateValues`

`UiPath.GSuite.Activities.BatchUpdateValues`

:::note
In **UiPath.GSuite.Activities** releases prior to 1.11.0, this activity was named **Batch Update Values Scope**.
:::

## Description

Sends a single batch update that includes the values from each of the Google Sheet activities you add inside this activity. You can use the **Batch Spreadsheet Updates** activity when you want to make multiple changes to a single spreadsheet.

Because the batch update is a single call to the docs server, the execution of the included activities is faster than running the same activities individually. For more information, see [batchUpdate](https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/batchUpdate) in the Google Sheets API documentation.

## Project compatibility

Windows - Legacy | Windows

## Configuration

#### In the body of the activity

* **Spreadsheet ID** - The ID of the spreadsheet to batch update. This property supports `String` variables and string formatted values.
* Add multiple **Write Range** or **Write Cell** activities inside **Batch Spreadsheet Updates**.

#### 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** - A reference to a Google Spreadsheet in which the batched updates will take place. Typically obtained via the [Use Google Spreadsheet](https://docs.uipath.com/activities/other/latest/productivity/google-sheets-application-scope) activity. This property supports `IGoogleSheetTarget` variables.
* **SpreadsheetID** - The ID of the spreadsheet that you want to make changes to. 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.

**Misc**

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

**Output**

* **Result** - The result of the batch update operation.