sheets_get_data_validation
Read data validation rules from a Google Sheet, returning checkboxes, dropdown lists, and custom formulas grouped by cell ranges.
Instructions
Read data validation rules (checkboxes, dropdown lists, custom formulas, etc.) from a sheet or range. Returns a compact list of unique validation rules grouped by their cell ranges (run-length encoded). Useful for discovering checkboxes (BOOLEAN), dropdown lists (ONE_OF_LIST / ONE_OF_RANGE), number constraints, and custom formula validations.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | No | Optional range WITHOUT sheet prefix, e.g. "A1:Z85". If omitted, the entire sheet is inspected. | |
| sheetName | Yes | Name of the sheet (tab) to inspect | |
| spreadsheetId | Yes | The ID of the spreadsheet (found in the URL after /d/) |