sheets_add_validation
Add data validation rules to Google Sheets cells to restrict input to dropdown lists, checkboxes, numbers, or dates, ensuring data consistency and accuracy.
Instructions
Add data validation. validation_type: DROPDOWN, CHECKBOX, NUMBER, DATE. For DROPDOWN, pass values as list of options.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| spreadsheet | Yes | ||
| sheet_name | Yes | ||
| range_a1 | Yes | ||
| validation_type | Yes | ||
| values | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |