Advanced batch update
batch_updateSend raw Google Sheets API batchUpdate requests for advanced edits other tools don't cover, including named ranges, protected ranges, pivot tables, row heights, hidden rows, and charts.
Instructions
Send raw Google Sheets API batchUpdate requests for anything the other tools don't cover (e.g. named ranges, protected ranges, pivot tables, row heights, hiding rows, updating charts). Requests use sheetId numbers from get_spreadsheet_info.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| account | No | Google account to use: an email or unique part of one (e.g. "acme.com"). Default: the account that can open the spreadsheet, else the default account. | |
| requests | Yes | Array of Request objects, see developers.google.com/sheets/api/reference/rest/v4/spreadsheets/request | |
| spreadsheet | Yes | Google Sheets link or spreadsheet ID. The name of a spreadsheet used with Sheets MCP before also works |