sheets_format_cells
Format spreadsheet cells by setting colors, font styles, sizes, and number formats for a specified range in Google Sheets.
Instructions
Format cells — background/text color, bold, italic, font size, number format (e.g. '0.00%', 'yyyy-mm-dd').
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": {
"spreadsheet_id": "<spreadsheet_id>",
"sheet_id": "<sheet_id>",
"start_row": "<start_row>",
"end_row": "<end_row>",
"start_col": "<start_col>",
"end_col": "<end_col>"
},
"name": "sheets_format_cells"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| bold | No | ||
| italic | No | ||
| end_col | Yes | ||
| end_row | Yes | ||
| bg_color | No | ||
| sheet_id | Yes | ||
| font_size | No | ||
| start_col | Yes | ||
| start_row | Yes | ||
| text_color | No | ||
| number_format | No | ||
| spreadsheet_id | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |