Spreadsheets Batch Update
spreadsheets_batch_updateBatch update a Google Sheet to add native charts and set cell number formats. Execute multiple changes in one API request.
Instructions
Apply a batch of update requests to a Google Sheet (spreadsheets.batchUpdate).
Used by the QBR skill to create native charts (addChart) and set cell number
formats (repeatCell). Build the requests array with
scripts/google_native/sheets_charts.build_batch_requests().
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"user_google_email": "<user_google_email>",
"spreadsheetId": "<spreadsheetId>",
"requests": "<requests>"
},
"name": "spreadsheets_batch_update"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| requests | Yes | The batchUpdate `requests` array (list of request dicts). | |
| spreadsheetId | Yes | Target spreadsheet id. | |
| user_google_email | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||