sheets_get_sheet_structure
Get sheet structural metadata including dimensions, frozen rows/cols, column widths, row heights, hidden columns/rows, and merge ranges. Faster alternative to full sheet snapshot, using a single API call.
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/) |