set_data_validation
Apply data validation rules to spreadsheet cells, such as dropdown lists, number ranges, and text constraints. Define criteria to restrict input and ensure data consistency.
Instructions
Set data validation rules for cells (e.g., dropdown lists, number ranges)
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| strict | No | Whether to reject invalid input | |
| values | No | List of valid values (for ONE_OF_LIST) | |
| end_row | Yes | Ending row index (exclusive) | |
| sheet_id | Yes | The ID of the sheet | |
| max_value | No | Maximum value (for NUMBER_LESS, NUMBER_BETWEEN, DATE_BETWEEN) | |
| min_value | No | Minimum value (for NUMBER_GREATER, NUMBER_BETWEEN, DATE_BETWEEN) | |
| start_row | Yes | Starting row index (0-based) | |
| end_column | Yes | Ending column index (exclusive) | |
| start_column | Yes | Starting column index (0-based) | |
| show_dropdown | No | Whether to show dropdown for list validation | |
| spreadsheet_id | Yes | The ID of the spreadsheet | |
| validation_type | Yes | Type of validation |