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 | Default |
---|---|---|---|
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"
}