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."
}
}
}
Work with this as data
Every JSON Schema here is available over the APIs.io API and to AI agents over MCP.
MCP server
One button, every client — Claude, Cursor, VS Code and the rest.
https://apis.io/mcp
Tools for schemas
4 MCP tools reach this
find_json_schemasBrowse and filter every JSON Schema in the catalog.apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.resolveTurn a domain, URL or GitHub org into the provider it belongs to.find_cohortsEvery scored population of providers in the catalog.
Call it yourself
curl for this page
This JSON Schema
curl "https://apis.io/api/v1/json-schemas/google-sheets-batch-update-values-response"
All schemas
curl "https://apis.io/api/v1/json-schemas?limit=25"
Discovery needs no key. Ratings and market analysis are Pro.
Get an API key
Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.
A second provider on the same verified email joins the account you already have.