set_data_validation
Apply or remove data validation on a Google Sheets range. Configure list, number, checkbox, or custom formula rules with strict mode and dropdown support.
Instructions
Set (or clear) data validation on a range.
Args: spreadsheet_id_or_url: Full Sheets URL or bare spreadsheet ID. sheet: Sheet name OR gid string. range: Bare A1 range without sheet prefix. rule_type: e.g. ONE_OF_LIST, NUMBER_BETWEEN, CHECKBOX, CUSTOM_FORMULA. Pass null/None to CLEAR validation from the range. values: Rule values (e.g. ['A','B','C'] for ONE_OF_LIST). strict: Reject invalid input (false = warning only). show_dropdown: Show dropdown for list rules. dry_run: If true, return the execution plan without changing anything.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | Yes | ||
| sheet | Yes | ||
| strict | No | ||
| values | No | ||
| dry_run | No | ||
| rule_type | No | ||
| show_dropdown | No | ||
| spreadsheet_id_or_url | Yes |