Format Sheet Range
format_sheet_rangeApply formatting to a Google Sheets range: colors, number formats, text wrapping, alignment, and font styling. Use hex codes for colors (e.g., #FFEECC) and specify format types like DATE or CURRENCY.
Instructions
Applies formatting to a range: colors, number formats, text wrapping, alignment, and text styling.
Colors accept hex strings (#RRGGBB). Number formats follow Sheets types (e.g., NUMBER, CURRENCY, DATE, PERCENT). If no sheet name is provided, the first sheet is used.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| user_google_email | Yes | The user's Google email address. Required. | |
| spreadsheet_id | Yes | The ID of the spreadsheet. Required. | |
| range_name | Yes | A1-style range (optionally with sheet name). Required. | |
| background_color | No | Hex background color (e.g., "#FFEECC"). | |
| text_color | No | Hex text color (e.g., "#000000"). | |
| number_format_type | No | Sheets number format type (e.g., "DATE"). | |
| number_format_pattern | No | Custom pattern for the number format. | |
| wrap_strategy | No | Text wrap strategy - WRAP (wrap text within cell), CLIP (clip text at cell boundary), or OVERFLOW_CELL (allow text to overflow into adjacent empty cells). | |
| horizontal_alignment | No | Horizontal text alignment - LEFT, CENTER, or RIGHT. | |
| vertical_alignment | No | Vertical text alignment - TOP, MIDDLE, or BOTTOM. | |
| bold | No | Whether to apply bold formatting. | |
| italic | No | Whether to apply italic formatting. | |
| font_size | No | Font size in points. |
Output Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |