mcp-gsheetsTools Reference
sheets_update_sheet_properties
Update sheet settings
sheets_update_sheet_properties
Update properties of a sheet such as title, grid size, or frozen rows/columns.
Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
spreadsheetId | string | Yes | The spreadsheet ID |
sheetId | number | Yes | The sheet ID to update |
title | string | No | New sheet title |
index | number | No | New position |
hidden | boolean | No | Hide or show the sheet |
frozenRowCount | number | No | Number of frozen rows |
frozenColumnCount | number | No | Number of frozen columns |
Example
{
"tool": "sheets_update_sheet_properties",
"arguments": {
"spreadsheetId": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms",
"sheetId": 0,
"title": "Q1 Report",
"frozenRowCount": 1
}
}