Dropdowns and validation
set_data_validationAdd or clear Google Sheets data validation for a range: dropdowns, checkboxes, number limits, or custom formulas to control cell input.
Instructions
Add data validation to a range: dropdown list, dropdown from a range, checkbox, number range, custom formula - or clear it.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| max | No | ||
| min | No | ||
| type | Yes | ||
| range | Yes | A1 range, e.g. "Sheet1!A1:D20", "'My Tab'!B:B", or a tab name | |
| strict | No | Reject invalid input (vs. show a warning) | |
| account | No | Google account to use: an email or unique part of one (e.g. "acme.com"). Default: the account that can open the spreadsheet, else the default account. | |
| options | No | dropdown: list items; dropdown_from_range: ["=Lists!A2:A20"]; custom_formula: ["=ISNUMBER(A2)"] | |
| spreadsheet | Yes | Google Sheets link or spreadsheet ID. The name of a spreadsheet used with Sheets MCP before also works |