sheets_get_sheet_structure
Retrieve sheet structural metadata such as dimensions, frozen rows/columns, tab color, column widths, row heights, hidden rows/columns, and merge ranges without per-cell data. Faster and cheaper than full sheet snapshots.
Instructions
Lightweight tool returning ONLY structural/dimensional metadata for a sheet — no per-cell data. Returns: sheet dimensions, frozen rows/cols, tab color, sheet index, column widths array, row heights array, hidden columns/rows, and all merge ranges in A1 notation. Use this instead of sheets_get_full_sheet_snapshot when per-cell formatting is not needed. Much faster and cheaper — single API call with minimal field mask.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sheetName | Yes | Name of the sheet (tab) to inspect | |
| spreadsheetId | Yes | The ID of the spreadsheet (found in the URL after /d/) |