sheets_update_sheet_properties

Modify sheet properties in Google Sheets, including title, grid dimensions, frozen rows/columns, and tab color, using spreadsheet and sheet IDs.

Instructions

Update properties of a sheet in a Google Sheets spreadsheet

Input Schema

Name	Required	Description
`gridProperties`	No	Grid properties to update
`sheetId`	Yes	The ID of the sheet to update (use sheets_get_metadata to find sheet IDs)
`spreadsheetId`	Yes	The ID of the spreadsheet (found in the URL after /d/)
`tabColor`	No	Tab color (RGB values from 0.0 to 1.0)
`title`	No	New title for the sheet

Input Schema (JSON Schema)

{
  "properties": {
    "gridProperties": {
      "description": "Grid properties to update",
      "properties": {
        "columnCount": {
          "description": "Number of columns",
          "type": "number"
        },
        "frozenColumnCount": {
          "description": "Number of frozen columns",
          "type": "number"
        },
        "frozenRowCount": {
          "description": "Number of frozen rows",
          "type": "number"
        },
        "rowCount": {
          "description": "Number of rows",
          "type": "number"
        }
      },
      "type": "object"
    },
    "sheetId": {
      "description": "The ID of the sheet to update (use sheets_get_metadata to find sheet IDs)",
      "type": "number"
    },
    "spreadsheetId": {
      "description": "The ID of the spreadsheet (found in the URL after /d/)",
      "type": "string"
    },
    "tabColor": {
      "description": "Tab color (RGB values from 0.0 to 1.0)",
      "properties": {
        "blue": {
          "description": "Blue component (0.0-1.0)",
          "type": "number"
        },
        "green": {
          "description": "Green component (0.0-1.0)",
          "type": "number"
        },
        "red": {
          "description": "Red component (0.0-1.0)",
          "type": "number"
        }
      },
      "type": "object"
    },
    "title": {
      "description": "New title for the sheet",
      "type": "string"
    }
  },
  "required": [
    "spreadsheetId",
    "sheetId"
  ],
  "type": "object"
}

mcp-gsheets

sheets_update_sheet_properties

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from mcp-gsheets

Related Tools

MCP directory API