Unified Sheet Range Formatter
format_sheet_rangeIdempotent
Apply cell formatting, borders, conditional rules, merge, column width/row height, and freezing to a Google Sheets range in one request.
Instructions
Apply comprehensive formatting to a range in Google Sheets with multiple formatting options in a single request - unified formatting tool that replaces format_sheet_cells, update_sheet_borders, add_conditional_formatting, and merge_cells
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| bold | No | ||
| italic | No | ||
| sheet_id | Yes | The sheet ID | |
| font_size | No | ||
| row_height | No | Height in pixels for rows in range | |
| text_color | No | ||
| top_border | No | ||
| cell_format | No | Dictionary with cell formatting options like: { "bold": True, "italic": False, "fontSize": 12, "textColor": {"red": 0.0, "green": 0.0, "blue": 0.0}, "backgroundColor": {"red": 1.0, "green": 1.0, "blue": 1.0}, "horizontalAlignment": "CENTER", "verticalAlignment": "MIDDLE", "numberFormat": {"type": "CURRENCY", "pattern": "$#,##0.00"}, "wrapStrategy": "WRAP" } | |
| freeze_rows | No | Number of rows to freeze from top | |
| left_border | No | ||
| border_color | No | ||
| border_style | No | Style of borders ("SOLID", "DASHED", "DOTTED", etc.) | |
| column_width | No | Width in pixels for columns in range | |
| right_border | No | ||
| apply_borders | No | Whether to apply borders | |
| bottom_border | No | ||
| range_end_col | Yes | Ending column index (exclusive) | |
| range_end_row | Yes | Ending row index (exclusive) | |
| text_rotation | No | ||
| wrap_strategy | No | ||
| condition_type | No | ||
| freeze_columns | No | Number of columns to freeze from left | |
| spreadsheet_id | Yes | The ID of the spreadsheet | |
| condition_value | No | ||
| range_start_col | Yes | Starting column index (0-based) | |
| range_start_row | Yes | Starting row index (0-based) | |
| background_color | No | ||
| border_positions | No | Which borders to apply | |
| conditional_rules | No | List of conditional formatting rules | |
| user_google_email | No | The user's Google email address for Sheets access. If None, uses the current authenticated user from FastMCP context (auto-injected by middleware). | |
| merge_cells_option | No | Merge type if merging cells | |
| number_format_type | No | ||
| vertical_alignment | No | ||
| horizontal_alignment | No | ||
| condition_format_bold | No | ||
| inner_vertical_border | No | ||
| number_format_pattern | No | ||
| condition_format_italic | No | ||
| inner_horizontal_border | No | ||
| condition_format_text_color | No | ||
| condition_format_background_color | No |
Output Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| error | No | Error message if operation failed | |
| range | Yes | Cell range that was formatted | |
| message | Yes | Success or error message | |
| sheetId | Yes | Sheet ID where formatting was applied | |
| success | Yes | Whether the formatting succeeded | |
| spreadsheetId | Yes | Unique identifier for the spreadsheet | |
| requestsApplied | Yes | Number of formatting requests successfully applied | |
| formattingDetails | Yes | Details of all formatting applied |