Tool to update values in ranges matching data filters. Use when you need to update specific data in a Google Sheet based on criteria rather than fixed cell ranges.
High parameter count (12 properties)
Part of the Google Sheets MCP server. Enforce policies on this tool with Intercept, the open-source MCP proxy.
AI agents use GOOGLESHEETS_BATCH_UPDATE_VALUES_BY_DATA_FILTER to create or modify resources in Google Sheets. Write operations carry medium risk because an autonomous agent could trigger bulk unintended modifications. Rate limits prevent a single agent session from making hundreds of changes in rapid succession. Argument validation ensures the agent passes expected values.
Without a policy, an AI agent could call GOOGLESHEETS_BATCH_UPDATE_VALUES_BY_DATA_FILTER repeatedly, creating or modifying resources faster than any human could review. Intercept's rate limiting ensures write operations happen at a controlled pace, and argument validation catches malformed or unexpected inputs before they reach Google Sheets.
Write tools can modify data. A rate limit prevents runaway bulk operations from AI agents.
tools:
GOOGLESHEETS_BATCH_UPDATE_VALUES_BY_DATA_FILTER:
rules:
- action: allow
rate_limit:
max: 30
window: 60See the full Google Sheets policy for all 38 tools.
Agents calling write-class tools like GOOGLESHEETS_BATCH_UPDATE_VALUES_BY_DATA_FILTER have been implicated in these attack patterns. Read the full case and prevention policy for each:
Other tools in the Write risk category across the catalogue. The same policy patterns (rate-limit, validate) apply to each.
Tool to update values in ranges matching data filters. Use when you need to update specific data in a Google Sheet based on criteria rather than fixed cell ranges.. It is categorised as a Write tool in the Google Sheets MCP Server, which means it can create or modify data. Consider rate limits to prevent runaway writes.
Add a rule in your Intercept YAML policy under the tools section for GOOGLESHEETS_BATCH_UPDATE_VALUES_BY_DATA_FILTER. You can allow, deny, rate-limit, or validate arguments. Then run Intercept as a proxy in front of the Google Sheets MCP server.
GOOGLESHEETS_BATCH_UPDATE_VALUES_BY_DATA_FILTER is a Write tool with medium risk. Write tools should be rate-limited to prevent accidental bulk modifications.
Yes. Add a rate_limit block to the GOOGLESHEETS_BATCH_UPDATE_VALUES_BY_DATA_FILTER rule in your Intercept 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.
Set action: deny in the Intercept policy for GOOGLESHEETS_BATCH_UPDATE_VALUES_BY_DATA_FILTER. 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.
GOOGLESHEETS_BATCH_UPDATE_VALUES_BY_DATA_FILTER is provided by the Google Sheets MCP server (google-sheets-mcp). Intercept sits as a proxy in front of this server to enforce policies before tool calls reach the server.
Open source. One binary. Zero dependencies.
npx -y @policylayer/intercept