update_data_validation
Update data validation rules for a specified cell range, including validation type, values, error messages, and input help text in Google Sheets.
Instructions
Update existing data validation rules in a cell range
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | Yes | Range to update validation (e.g., "A1:A10") | |
| strict | No | Update strict mode setting | |
| values | No | New values for validation | |
| sheet_name | Yes | Name of the sheet | |
| error_message | No | Updated custom error message for invalid input | |
| input_message | No | Updated help text shown when cell is selected | |
| spreadsheet_id | Yes | Google Spreadsheet ID | |
| validation_type | Yes | Type of validation rule |