Set data validation
The Google Sheets Set Data Validation tool enables users to add customized data validation rules such as dropdown menus, checkboxes, and date or number constraints directly to specified cells within their spreadsheets. This enhances data accuracy and usability through easy configuration compliant with Google Sheets API requirements.
Features
- Supports multiple validation types including dropdown lists, number range constraints, text containment, date conditions, and custom formulas.
- Allows precise targeting of validation rules by specifying spreadsheet ID, worksheet ID, and cell range.
- Integration with Google Drive and Shared Drives for flexible data source selection.
- Clear JSON input format for validation values ensuring seamless API communication.
- Complies directly with official Google Sheets API standards for robust and dependable performance.
Benefits
- Improves data integrity by preventing invalid or inconsistent entries in your spreadsheets.
- Simplifies data entry process for users through dropdowns and checkboxes, reducing errors.
- Enhances workflow efficiency by automating validation without manual checks.
- Supports complex validation scenarios with extensive validation type options.
- Facilitates collaborative work by integrating with shared drives and allowing consistent data standards across teams.
Description
Add data validation rules to cells (dropdowns, checkboxes, date/number validation). See the documentation
IMPORTANT: The arguments have specific formats. Please follow the instructions below:
- validationValues: Return JSON in this format: string[]
Parameters
6 parameters
| Name | Type | Description |
|---|---|---|
| drive | string | Defaults to You can use the "retrieve_options" tool using these parameters to get the values. key: google_sheets-set-data-validation, propName: drive. |
| sheetIdrequired | string | Select a spreadsheet or provide a spreadsheet ID You can use the "retrieve_options" tool using these parameters to get the values. key: google_sheets-set-data-validation, propName: sheetId. |
| worksheetIdrequired | integer | Select a worksheet or provide a worksheet ID You can use the "retrieve_options" tool using these parameters to get the values. key: google_sheets-set-data-validation, propName: worksheetId. |
| rangerequired | string | The range of cells to apply validation (e.g., |
| validationTyperequired | enum | The type of data validation |
| validationValuesrequired | string[] | Values for validation (e.g., dropdown options) |