Google Sheets
GOOGLESHEETS_FORMAT_CELL
Applies text and background cell formatting to a specified range in a Google Sheets worksheet.
Remote googlesheets
Other tools also called GOOGLESHEETS_FORMAT_CELL?
See providers with this name
Input Schema
{
"type": "object",
"properties": {
"red": {
"type": "number",
"default": 0.9,
"description": "Red component of the background color (0.0-1.0).\nExamples:\n \"0.0\"\n \"0.5\"\n \"1.0\""
},
"blue": {
"type": "number",
"default": 0.9,
"description": "Blue component of the background color (0.0-1.0).\nExamples:\n \"0.0\"\n \"0.5\"\n \"1.0\""
},
"bold": {
"type": "boolean",
"default": false,
"description": "Apply bold formatting.\nExamples:\n \"true\"\n \"false\""
},
"green": {
"type": "number",
"default": 0.9,
"description": "Green component of the background color (0.0-1.0).\nExamples:\n \"0.0\"\n \"0.5\"\n \"1.0\""
},
"range": {
"type": [
"string",
"null"
],
"default": null,
"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.\nExamples:\n \"A1\"\n \"F9\"\n \"B2:D4\"\n \"C1:C10\""
},
"italic": {
"type": "boolean",
"default": false,
"description": "Apply italic formatting.\nExamples:\n \"true\"\n \"false\""
},
"fontSize": {
"type": "integer",
"default": 10,
"description": "Font size in points.\nExamples:\n \"10\"\n \"12\"\n \"14\""
},
"underline": {
"type": "boolean",
"default": false,
"description": "Apply underline formatting.\nExamples:\n \"true\"\n \"false\""
},
"worksheet_id": {
"type": "integer",
"description": "ID (sheetId) of the worksheet. Use `GOOGLESHEETS_GET_SPREADSHEET_INFO` to find this ID.\nExample: \"123456789\""
},
"end_row_index": {
"anyOf": [
{
"type": "integer"
},
{
"type": "null"
}
],
"default": null,
"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.\nExamples:\n 1\n 9"
},
"strikethrough": {
"type": "boolean",
"default": false,
"description": "Apply strikethrough formatting.\nExamples:\n \"true\"\n \"false\""
},
"spreadsheet_id": {
"type": "string",
"description": "Identifier of the Google Sheets spreadsheet.\nExample: \"1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms\""
},
"start_row_index": {
"anyOf": [
{
"type": "integer"
},
{
"type": "null"
}
],
"default": null,
"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.\nExamples:\n 0\n 8"
},
"end_column_index": {
"anyOf": [
{
"type": "integer"
},
{
"type": "null"
}
],
"default": null,
"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.\nExamples:\n 1\n 2\n 6"
},
"start_column_index": {
"anyOf": [
{
"type": "integer"
},
{
"type": "null"
}
],
"default": null,
"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.\nExamples:\n 0\n 1\n 5"
}
}
}