Format several ranges
format_rangesApply different formatting to several ranges in one call: headers, numbers, borders, and more for a whole tab. Ranges can overlap; later entries override earlier ones.
Instructions
Apply different formatting to several ranges in one call (same options as format_range, one entry per range): headers, input cells, number formats, borders and so on for a whole tab at once. Ranges may repeat; later entries win where they overlap.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| items | Yes | One entry per range, each with the formatting to apply there | |
| 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. | |
| spreadsheet | Yes | Google Sheets link or spreadsheet ID. The name of a spreadsheet used with Sheets MCP before also works |