Google Sheets

gs_format_cells

Apply formatting to cells in a range — bold, italic, font size, colors, alignment, number format, and more. Uses 0-based row/column indices.

Remote node2flow/google-sheets

Other tools also called gs_format_cells? See providers with this name

Input Schema


            {
  "type": "object",
  "properties": {
    "bold": {
      "type": "boolean",
      "description": "Set bold text"
    },
    "italic": {
      "type": "boolean",
      "description": "Set italic text"
    },
    "sheet_id": {
      "type": "number",
      "description": "The numeric sheet ID"
    },
    "font_size": {
      "type": "number",
      "description": "Font size in points (e.g. 10, 12, 14)"
    },
    "underline": {
      "type": "boolean",
      "description": "Set underline text"
    },
    "font_family": {
      "type": "string",
      "description": "Font family (e.g. \"Arial\", \"Roboto\", \"Courier New\")"
    },
    "end_row_index": {
      "type": "number",
      "description": "End row (0-based exclusive, e.g. 5 = up to row 5)"
    },
    "strikethrough": {
      "type": "boolean",
      "description": "Set strikethrough text"
    },
    "wrap_strategy": {
      "type": "string",
      "description": "Text wrapping: \"OVERFLOW_CELL\", \"CLIP\", \"WRAP\""
    },
    "spreadsheet_id": {
      "type": "string",
      "description": "The spreadsheet ID"
    },
    "start_row_index": {
      "type": "number",
      "description": "Start row (0-based inclusive, e.g. 0 = row 1)"
    },
    "end_column_index": {
      "type": "number",
      "description": "End column (0-based exclusive, e.g. 3 = up to column C)"
    },
    "number_format_type": {
      "type": "string",
      "description": "Number format type: \"TEXT\", \"NUMBER\", \"PERCENT\", \"CURRENCY\", \"DATE\", \"TIME\", \"DATE_TIME\", \"SCIENTIFIC\""
    },
    "start_column_index": {
      "type": "number",
      "description": "Start column (0-based inclusive, e.g. 0 = column A)"
    },
    "vertical_alignment": {
      "type": "string",
      "description": "Vertical alignment: \"TOP\", \"MIDDLE\", \"BOTTOM\""
    },
    "background_color_red": {
      "type": "number",
      "description": "Background color red component (0-1)"
    },
    "foreground_color_red": {
      "type": "number",
      "description": "Text color red component (0-1)"
    },
    "horizontal_alignment": {
      "type": "string",
      "description": "Horizontal alignment: \"LEFT\", \"CENTER\", \"RIGHT\""
    },
    "background_color_blue": {
      "type": "number",
      "description": "Background color blue component (0-1)"
    },
    "foreground_color_blue": {
      "type": "number",
      "description": "Text color blue component (0-1)"
    },
    "number_format_pattern": {
      "type": "string",
      "description": "Number format pattern (e.g. \"#,##0.00\", \"yyyy-mm-dd\", \"$#,##0\")"
    },
    "background_color_green": {
      "type": "number",
      "description": "Background color green component (0-1)"
    },
    "foreground_color_green": {
      "type": "number",
      "description": "Text color green component (0-1)"
    }
  }
}