mcp-gsheetsTools Reference
sheets_format_cells
Format cells with colors, fonts, and alignment
sheets_format_cells
Apply formatting to a range of cells including colors, fonts, alignment, and number formats.
Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
spreadsheetId | string | Yes | The spreadsheet ID |
range | string | Yes | A1 notation range |
format | object | Yes | Formatting options |
Format Options
backgroundColor- Background color (RGB object)foregroundColor- Text color (RGB object)bold- Bold textitalic- Italic textfontSize- Font sizefontFamily- Font familyhorizontalAlignment-LEFT,CENTER,RIGHTverticalAlignment-TOP,MIDDLE,BOTTOMnumberFormat- Number format pattern
Example
{
"tool": "sheets_format_cells",
"arguments": {
"spreadsheetId": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms",
"range": "Sheet1!A1:D1",
"format": {
"backgroundColor": { "red": 0.2, "green": 0.4, "blue": 0.8 },
"foregroundColor": { "red": 1, "green": 1, "blue": 1 },
"bold": true,
"fontSize": 12,
"horizontalAlignment": "CENTER"
}
}
}