sheets_format
Apply formatting to a Google Sheets range: set bold, italic, text and background colors, number formats, alignment, borders, wrapping, and font size for a selected tab and cell range.
Instructions
Format a range on one tab: bold, colors, number format (e.g. '$#,##0.00', '0.0%', 'yyyy-mm-dd'), alignment, borders.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"spreadsheetId": "<spreadsheetId>",
"tab": "<tab>",
"startRow": "<startRow>",
"endRow": "<endRow>",
"startCol": "<startCol>",
"endCol": "<endCol>"
},
"name": "sheets_format"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| tab | Yes | ||
| bold | No | ||
| wrap | No | ||
| endCol | Yes | ||
| endRow | Yes | exclusive | |
| italic | No | ||
| borders | No | ||
| fontSize | No | ||
| startCol | Yes | ||
| startRow | Yes | 0-based | |
| textColor | No | #RRGGBB | |
| numberFormat | No | ||
| spreadsheetId | Yes | ||
| backgroundColor | No | #RRGGBB | |
| horizontalAlignment | No |