v1

latestOpenAPI 3.0.12026-07-1711094.7 KB

Batch updates values in multiple ranges of a Google Sheet.

This function allows for updating values in multiple specified ranges of a Google Sheet with provided data in a single batch request. It takes the sheet ID, an array of update inputs, and an optional value input option. The function returns a promise that resolves to an array of API responses, each containing information about an update operation in the batch.

post/batchUpdateValues

Request body

Response

Successful response

spreadsheetIdstring

The ID of the spreadsheet that was updated.

updatedRangestring

The range (in A1 notation) that was updated.

updatedRowsinteger

The number of rows that were updated.

updatedColumnsinteger

The number of columns that were updated.

updatedCellsinteger

The number of cells that were updated.