sheets_set_data_validation
Set data validation rules on Google Sheets cell ranges, including dropdowns, checkboxes, and numeric/text/date constraints.
Instructions
Add data validation (dropdown, checkbox, number/text/date constraint) to a cell range. rule_type: ONE_OF_LIST, CHECKBOX, NUMBER_BETWEEN, NUMBER_GREATER, TEXT_CONTAINS, DATE_IS_VALID.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| strict | No | ||
| values | No | ||
| end_col | Yes | ||
| end_row | Yes | ||
| sheet_id | Yes | ||
| rule_type | Yes | ||
| start_col | Yes | ||
| start_row | Yes | ||
| spreadsheet_id | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |