Get Sheet Schema
get_sheet_schemaReturns the structural schema of a sheet tab to reveal column names, data types, dropdown options, checkboxes, and formula-protected fields. Use before write operations to understand column constraints.
Instructions
Returns the structural schema of a sheet tab: column names, dropdown options, checkboxes, data types (date/number/currency), formula-protected fields, and instructional notes. Use this before write operations to understand column constraints.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| data_row | No | 1-based row index containing sample data or validation rules (default: header_row + 1) | |
| header_row | No | 1-based row index where headers are located (default: 1) | |
| sheet_name | Yes | Exact name of the sheet tab to analyze | |
| spreadsheet | Yes | Target spreadsheet: a full Google Sheets URL (https://docs.google.com/spreadsheets/d/<ID>/edit...) or a bare spreadsheet ID |