add_sheet_data_validation
Apply data validation rules to Google Sheets cell ranges to restrict input using dropdown lists, number ranges, date constraints, or custom formulas.
Instructions
Add data validation rules to a cell range (dropdowns, number bounds, custom formulas).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| user_google_email | Yes | ||
| spreadsheet_id | Yes | ID of the spreadsheet. | |
| range_name | Yes | A1 range (e.g., "Sheet1!A1:A10" or "A1:A10"). | |
| validation_type | Yes | One of ONE_OF_LIST, NUMBER_BETWEEN, NUMBER_GREATER, NUMBER_LESS, NUMBER_EQ, TEXT_CONTAINS, TEXT_EQ, DATE_AFTER, DATE_BEFORE, DATE_ON_OR_AFTER, DATE_ON_OR_BEFORE, CUSTOM_FORMULA, BOOLEAN. | |
| values | No | List of allowed values (for ONE_OF_LIST) or bounds (for NUMBER_BETWEEN pass [min, max]). For single-value conditions, pass [value]. | |
| custom_formula | No | For CUSTOM_FORMULA type, the formula (e.g., "=A1>0"). | |
| strict | No | If True, rejects invalid input. If False, shows a warning. | |
| show_dropdown | No | For ONE_OF_LIST, whether to show the dropdown UI. | |
| input_message | No | Optional help text shown on hover. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |