Freeze rows and columns
set_frozenFreeze the first rows or columns of a Google Sheet so headers stay visible while scrolling. Specify counts, use 0 to unfreeze, and keep at least one row or column unfrozen.
Instructions
Freezes the first N rows and/or columns of a sheet so they stay visible while scrolling (typical: frozen_rows=1 pins the header). 0 unfreezes. At least one of frozen_rows / frozen_columns is required; the other stays as it is. You cannot freeze all rows or all columns of a sheet — at least one unfrozen row/column must remain.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"spreadsheet_id": "<spreadsheet_id>",
"sheet_id": "<sheet_id>"
},
"name": "set_frozen"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sheet_id | Yes | The numeric sheetId (NOT the title) from get_spreadsheet sheets[].properties.sheetId; the first sheet of a new spreadsheet is 0. | |
| frozen_rows | No | How many top rows to freeze (0 = unfreeze). | |
| frozen_columns | No | How many left columns to freeze (0 = unfreeze). | |
| spreadsheet_id | Yes | The spreadsheet id — the long id from the URL (docs.google.com/spreadsheets/d/<spreadsheetId>/edit) or from create_spreadsheet / search_spreadsheets output. |