sheets_get_data_validation
Read data validation rules from a Google Sheet range, returning unique rules grouped by cell ranges. Identify checkboxes, dropdown lists, number constraints, and custom formula validations.
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/) |