sheets_set_data_validation
Apply data validation rules like dropdowns, number ranges, or custom formulas to Google Sheets cells, restricting input to valid values and preventing entry errors.
Instructions
Sets data validation rules on a range of cells
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | Yes | The A1 notation range to validate | |
| strict | No | Whether to reject invalid input (true) or show a warning (false) | |
| values | No | Validation values (dropdown options, number bounds, formula, etc.) | |
| spreadsheet_id | Yes | The ID of the spreadsheet | |
| validation_type | Yes | The type of validation to apply |