set_data_validation

SERVERMcp Google Sheets SOURCE@a1-x-tech/mcp-google-sheets

Medium RISK CLASS

Category Write

Parameters 72 required

Recommended Rate-limitedsee the rule below

Registry record Grade F, identity unverified Pull the record →

This record as markdown: /tools/a1-x-tech-mcp-google-sheets/set-data-validation.md

WHAT IT DOES

What set_data_validation does on Mcp Google Sheets

AI agents use set_data_validation to create or update resources in Mcp Google Sheets, usually the action step of a workflow, after the agent has gathered context. Every call changes real data in your Mcp Google Sheets environment.

Parameter	Type	Required	Description
`range`	object	Yes	Cell rectangle in grid coordinates: rows 1-10 × columns A-B = {start_row_index:0, end_row_index:10, start_column_index:0, end_column_index:2}.
`strict`	boolean	—	true rejects invalid input; false (default) shows a warning.
`input_message`	string	—	Help text shown when the cell is selected.
`condition_type`	string	—	Sheets API condition type, e.g. ONE_OF_LIST, ONE_OF_RANGE, NUMBER_GREATER, NUMBER_LESS, NUMBER_BETWEEN, NUMBER_EQ, TEXT_CONTAINS, TEXT_STARTS_WITH, TEXT_EQ, TEX
`show_custom_ui`	boolean	—	Show a dropdown UI for ONE_OF_LIST / ONE_OF_RANGE conditions.
`spreadsheet_id`	string	Yes	The spreadsheet id — the long id from the URL (docs.google.com/spreadsheets/d/<spreadsheetId>/edit) or from create_spreadsheet / search_spreadsheets output.
`condition_values`	array	—	Condition arguments: list items for ONE_OF_LIST (["Yes","No"]), one number for NUMBER_GREATER (["100"]), two for NUMBER_BETWEEN, "=A1>B1"-style formula for CUST

Parameters from the server's own tool schema.

RISK

Why set_data_validation is rated Medium

Modifies spreadsheet validation rules reversibly; affects data integrity but not destruction.

From the tool's definition Sets or clears data-validation rule on grid range; overwrites previous rule.

Risk signalsHigh parameter count (12 properties) · Bulk/mass operation — affects multiple targets

Attacks that exploit this kind of access

RECOMMENDED RULE

The rule that runs set_data_validation safely

PolicyLayer is an MCP gateway: it sits between your AI agents and Mcp Google Sheets, and checks every tool call against a rule you set before the call runs. Nothing changes on the server itself. For set_data_validation, this is the rule to start with:

set_data_validation Rate-limited

set_data_validation stays usable, but capped: an agent stuck in a loop can't make hundreds of changes a minute. Everything else on the server is denied unless you say otherwise.

View as policy code

policy.json

{
  "version": "1",
  "default": "deny",
  "tools": {
    "set_data_validation": {
      "limits": [
        {
          "counter": "set_data_validation_rate",
          "window": "minute",
          "max": 30,
          "scope": "grant"
        }
      ]
    }
  }
}

LIMIT THIS TOOL → Instant setup, no code required.

The button opens the PolicyLayer dashboard: create your workspace, connect Mcp Google Sheets, apply this rule, and every set_data_validation call is checked against it from then on.

FAQ

Questions about set_data_validation

What does the set_data_validation tool do? +

Sets — or clears — a data-validation rule on a grid range. With condition_type set, every cell in the range gets the rule: ONE_OF_LIST with condition_values plus show_custom_ui=true is the classic in-cell dropdown; ONE_OF_RANGE takes a "=Sheet1!A1:A10" formula; NUMBER_/TEXT_/DATE_ conditions restrict input; CUSTOM_FORMULA takes a formula evaluated per cell. strict=true rejects invalid input outright, strict=false only shows a warning; input_message is the help text shown on the cell. OMIT condition_type (and the other rule fields) to REMOVE validation from the range. Overwrites any previous rule on the range — one rule per cell. It is categorised as a Write tool in the Mcp Google Sheets MCP Server, which means it can create or modify data. Consider rate limits to prevent runaway writes.

What parameters does set_data_validation accept? +

set_data_validation accepts 7 parameters: range, strict, input_message, condition_type, show_custom_ui, spreadsheet_id, condition_values. Required: range, spreadsheet_id. The full parameter table on this page comes from the server's own tool schema.

How do I enforce a policy on set_data_validation? +

Register the Mcp Google Sheets MCP server in PolicyLayer and add a rule for set_data_validation: allow, deny, rate-limit, or require approval. Point your MCP client at the PolicyLayer proxy URL and the rule is enforced on every call, before it reaches Mcp Google Sheets. Nothing to install.

What risk level is set_data_validation? +

set_data_validation is a Write tool with medium risk. Write tools should be rate-limited to prevent accidental bulk modifications.

Can I rate-limit set_data_validation? +

Yes. Add a rate_limit block to the set_data_validation rule in your PolicyLayer policy. For example, setting max: 10 and window: 60 limits the tool to 10 calls per minute. Rate limits are tracked per agent session and reset automatically.

How do I block set_data_validation completely? +

Set action: deny in the PolicyLayer policy for set_data_validation. The AI agent will receive a policy violation error and cannot call the tool. You can also include a reason field to explain why the tool is blocked.

What MCP server provides set_data_validation? +

set_data_validation is provided by the Mcp Google Sheets MCP server (@a1-x-tech/mcp-google-sheets). PolicyLayer sits as a proxy in front of this server to enforce policies before tool calls reach the server.

KEEP EXPLORING

More on Mcp Google Sheets, and thousands of servers like it.

This server

All 20 Mcp Google Sheets tools →

Across the catalogue

emit_assumption_set on 0sec →set-prioity on Kanban MCP Server → The MCP Attack Database →

Guides

Govern customer-ops agents →Argument validation →Scoped token →