Skip to main content

Batch Spreadsheet Updates

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 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 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 or 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.