MCP Libraries
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

ParameterTypeRequiredDescription
spreadsheetIdstringYesThe spreadsheet ID
requestsarrayYesArray 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"
        }
      }
    ]
  }
}

On this page