mcp-gsheetsTools Reference
sheets_batch_format_cells
Format multiple cell ranges at once
sheets_batch_format_cells
Apply formatting to multiple cell ranges in a single operation.
Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
spreadsheetId | string | Yes | The spreadsheet ID |
requests | array | Yes | Array of formatting requests |
Example
{
"tool": "sheets_batch_format_cells",
"arguments": {
"spreadsheetId": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms",
"requests": [
{
"range": "Sheet1!A1:D1",
"format": {
"backgroundColor": { "red": 0.2, "green": 0.4, "blue": 0.8 },
"bold": true
}
},
{
"range": "Sheet1!A2:D100",
"format": {
"horizontalAlignment": "CENTER"
}
}
]
}
}