Google Sheets · Schema
BatchUpdateValuesResponse
The response when updating a range of values in a spreadsheet.
Google WorkspaceProductivitySpreadsheets
Properties
| Name | Type | Description |
|---|---|---|
| spreadsheetId | string | The spreadsheet the updates were applied to. |
| totalUpdatedRows | integer | The total number of rows where at least one cell in the row was updated. |
| totalUpdatedColumns | integer | The total number of columns where at least one cell in the column was updated. |
| totalUpdatedCells | integer | The total number of cells updated. |
| totalUpdatedSheets | integer | The total number of sheets where at least one cell in the sheet was updated. |
| responses | array | One UpdateValuesResponse per requested range, in the same order as the requests appeared. |
JSON Schema
{
"$schema": "https://json-schema.org/draft/2020-12/schema",
"title": "BatchUpdateValuesResponse",
"type": "object",
"description": "The response when updating a range of values in a spreadsheet.",
"properties": {
"spreadsheetId": {
"type": "string",
"description": "The spreadsheet the updates were applied to."
},
"totalUpdatedRows": {
"type": "integer",
"description": "The total number of rows where at least one cell in the row was updated."
},
"totalUpdatedColumns": {
"type": "integer",
"description": "The total number of columns where at least one cell in the column was updated."
},
"totalUpdatedCells": {
"type": "integer",
"description": "The total number of cells updated."
},
"totalUpdatedSheets": {
"type": "integer",
"description": "The total number of sheets where at least one cell in the sheet was updated."
},
"responses": {
"type": "array",
"description": "One UpdateValuesResponse per requested range, in the same order as the requests appeared."
}
}
}