Google Super

GOOGLESUPER_FORMAT_CELL

Applies text and background cell formatting to a specified range in a Google Sheets worksheet.

Remote googlesuper

Other tools also called GOOGLESUPER_FORMAT_CELL? See providers with this name

Input Schema


            {
  "type": "object",
  "properties": {
    "red": {
      "type": "number",
      "title": "Red",
      "default": 0.9,
      "examples": [
        "0.0",
        "0.5",
        "1.0"
      ],
      "description": "Red component of the background color (0.0-1.0)."
    },
    "blue": {
      "type": "number",
      "title": "Blue",
      "default": 0.9,
      "examples": [
        "0.0",
        "0.5",
        "1.0"
      ],
      "description": "Blue component of the background color (0.0-1.0)."
    },
    "bold": {
      "type": "boolean",
      "title": "Bold",
      "default": false,
      "examples": [
        "true",
        "false"
      ],
      "description": "Apply bold formatting."
    },
    "green": {
      "type": "number",
      "title": "Green",
      "default": 0.9,
      "examples": [
        "0.0",
        "0.5",
        "1.0"
      ],
      "description": "Green component of the background color (0.0-1.0)."
    },
    "range": {
      "type": "string",
      "title": "Range",
      "default": null,
      "examples": [
        "A1",
        "F9",
        "B2:D4",
        "C1:C10"
      ],
      "nullable": true,
      "description": "OPTION 1: Cell range in A1 notation (RECOMMENDED). Examples: 'A1' (single cell), 'F9' (cell F9), 'A1:B5' (range). Provide EITHER this field OR all four index fields below, not both."
    },
    "italic": {
      "type": "boolean",
      "title": "Italic",
      "default": false,
      "examples": [
        "true",
        "false"
      ],
      "description": "Apply italic formatting."
    },
    "fontSize": {
      "type": "integer",
      "title": "Font Size",
      "default": 10,
      "examples": [
        "10",
        "12",
        "14"
      ],
      "description": "Font size in points."
    },
    "underline": {
      "type": "boolean",
      "title": "Underline",
      "default": false,
      "examples": [
        "true",
        "false"
      ],
      "description": "Apply underline formatting."
    },
    "worksheet_id": {
      "type": "integer",
      "title": "Worksheet Id",
      "examples": [
        "123456789"
      ],
      "description": "ID (sheetId) of the worksheet. Use `GOOGLESHEETS_GET_SPREADSHEET_INFO` to find this ID."
    },
    "end_row_index": {
      "type": "integer",
      "title": "End Row Index",
      "default": null,
      "examples": [
        1,
        9
      ],
      "nullable": true,
      "description": "OPTION 2: 0-based index of the row AFTER the last row (exclusive). Required if 'range' is not provided. Must provide ALL four index fields together."
    },
    "strikethrough": {
      "type": "boolean",
      "title": "Strikethrough",
      "default": false,
      "examples": [
        "true",
        "false"
      ],
      "description": "Apply strikethrough formatting."
    },
    "spreadsheet_id": {
      "type": "string",
      "title": "Spreadsheet Id",
      "examples": [
        "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms"
      ],
      "description": "Identifier of the Google Sheets spreadsheet."
    },
    "start_row_index": {
      "type": "integer",
      "title": "Start Row Index",
      "default": null,
      "examples": [
        0,
        8
      ],
      "nullable": true,
      "description": "OPTION 2: 0-based row index (row 1 = index 0, row 9 = index 8). Required if 'range' is not provided. Must provide ALL four index fields together."
    },
    "end_column_index": {
      "type": "integer",
      "title": "End Column Index",
      "default": null,
      "examples": [
        1,
        2,
        6
      ],
      "nullable": true,
      "description": "OPTION 2: 0-based index of the column AFTER the last column (exclusive). Required if 'range' is not provided. Must provide ALL four index fields together."
    },
    "start_column_index": {
      "type": "integer",
      "title": "Start Column Index",
      "default": null,
      "examples": [
        0,
        1,
        5
      ],
      "nullable": true,
      "description": "OPTION 2: 0-based column index (A = 0, B = 1, F = 5). Required if 'range' is not provided. Must provide ALL four index fields together."
    }
  }
}