add_data_validation
Apply data validation rules to cell ranges for input restrictions and data quality control, supporting types like lists, numbers, dates, and custom formulas.
Instructions
Add data validation rules to a cell range for input restrictions and data quality control
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | Yes | Range to apply validation (e.g., "A1:A10", "B2:D5") | |
| strict | No | If true, reject invalid input. If false, show warning only | |
| values | No | Values for validation (list items, numbers, dates, formula) | |
| sheet_name | Yes | Name of the sheet | |
| error_message | No | Optional custom error message for invalid input | |
| input_message | No | Optional help text shown when cell is selected | |
| spreadsheet_id | Yes | Google Spreadsheet ID | |
| validation_type | Yes | Type of validation rule |