sheets_batch_update
Apply batch updates to Google Sheets for formatting, adding or deleting sheets, merging cells, inserting charts, and conditional formatting.
Instructions
Apply batch update requests to a Google Spreadsheet (formatting, add/delete sheets, merge cells, charts, conditional formatting, etc.)
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": {
"spreadsheetId": "<spreadsheetId>",
"requests": "<requests>"
},
"name": "sheets_batch_update"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| requests | Yes | JSON string of an array of Sheets API request objects (e.g. addSheet, mergeCells, updateBorders, addChart, etc.) | |
| spreadsheetId | Yes | The spreadsheet ID |