GOOGLESUPER_BATCH_UPDATE_VALUES_BY_DATA_FILTER
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.
This record as markdown: /tools/googlesuper/googlesuper-batch-update-values-by-data-filter.md
What GOOGLESUPER_BATCH_UPDATE_VALUES_BY_DATA_FILTER does on Google Super
AI agents use GOOGLESUPER_BATCH_UPDATE_VALUES_BY_DATA_FILTER to create or update resources in Google Super, usually the action step of a workflow, after the agent has gathered context. Every call changes real data in your Google Super environment.
| Parameter | Type | Required | Description |
|---|---|---|---|
data | array | — | The new values to apply to the spreadsheet. If more than one range is matched by the specified DataFilter the specified values are applied to all of those range |
spreadsheetId | string | — | The ID of the spreadsheet to update. |
valueInputOption | string | — | How the input data should be interpreted. |
includeValuesInResponse | boolean | — | Determines if the update response should include the values of the cells that were updated. By default, responses do not include the updated values. |
responseValueRenderOption | string | — | Determines how values in the response should be rendered. The default render option is FORMATTED_VALUE. |
responseDateTimeRenderOption | string | — | Determines how dates, times, and durations in the response should be rendered. This is ignored if responseValueRenderOption is FORMATTED_VALUE. The default date |
Parameters from the server's own tool schema.
Why GOOGLESUPER_BATCH_UPDATE_VALUES_BY_DATA_FILTER is rated Medium
This tool creates or modifies data (spreadsheet values) in a reversible manner based on filter criteria. It does not delete or irreversibly remove data (Destructive), execute arbitrary code (Execute), nor move money (Financial).
From the tool's definition Tool description states 'update values in ranges matching data filters' and 'update specific data in a Google Sheet' — core write operation that modifies data reversibly within a structured spreadsheet.
Risk signalsHigh parameter count (28 properties)
Attacks that exploit this kind of access
The rule that runs GOOGLESUPER_BATCH_UPDATE_VALUES_BY_DATA_FILTER safely
PolicyLayer is an MCP gateway: it sits between your AI agents and Google Super, and checks every tool call against a rule you set before the call runs. Nothing changes on the server itself. For GOOGLESUPER_BATCH_UPDATE_VALUES_BY_DATA_FILTER, this is the rule to start with:
GOOGLESUPER_BATCH_UPDATE_VALUES_BY_DATA_FILTER 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.
The button opens the PolicyLayer dashboard: create your workspace, connect Google Super, apply this rule, and every GOOGLESUPER_BATCH_UPDATE_VALUES_BY_DATA_FILTER call is checked against it from then on.
Questions about GOOGLESUPER_BATCH_UPDATE_VALUES_BY_DATA_FILTER
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 Super MCP Server, which means it can create or modify data. Consider rate limits to prevent runaway writes.
GOOGLESUPER_BATCH_UPDATE_VALUES_BY_DATA_FILTER accepts 6 parameters: data, spreadsheetId, valueInputOption, includeValuesInResponse, responseValueRenderOption, responseDateTimeRenderOption. The full parameter table on this page comes from the server's own tool schema.
Register the Google Super MCP server in PolicyLayer and add a rule for GOOGLESUPER_BATCH_UPDATE_VALUES_BY_DATA_FILTER: 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 Google Super. Nothing to install.
GOOGLESUPER_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 GOOGLESUPER_BATCH_UPDATE_VALUES_BY_DATA_FILTER 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.
Set action: deny in the PolicyLayer policy for GOOGLESUPER_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.
GOOGLESUPER_BATCH_UPDATE_VALUES_BY_DATA_FILTER is provided by the Google Super MCP server (googlesuper). PolicyLayer sits as a proxy in front of this server to enforce policies before tool calls reach the server.
More on Google Super, and thousands of servers like it.
This server
Across the catalogue