GOOGLESUPER_BATCH_UPDATE
Updates a specified range in a Google Sheet with given values, or appends them as new rows if first_cell_location is omitted. Auto-expands grid for large datasets, preventing range errors. Requirements: Target sheet must exist and spreadsheet must contain at least one worksheet.
This record as markdown: /tools/googlesuper/googlesuper-batch-update.md
What GOOGLESUPER_BATCH_UPDATE does on Google Super
AI agents use GOOGLESUPER_BATCH_UPDATE 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 |
|---|---|---|---|
values | array | — | A 2D array of cell values where each inner array represents a row. Values can be strings, numbers, booleans, or None/null for empty cells. Ensure columns are pr |
sheet_name | string | — | The name of the specific sheet (tab) within the spreadsheet to update. Case-sensitive. |
spreadsheet_id | string | — | The unique identifier of the Google Sheets spreadsheet to be updated. Can be found in the spreadsheet URL. |
valueInputOption | string | — | How input data should be interpreted. 'USER_ENTERED': Values are parsed as if typed by a user (e.g., strings may become numbers/dates, formulas are calculated). |
first_cell_location | string | — | The starting cell for the update range, specified in A1 notation (e.g., 'A1', 'B2'). The update will extend from this cell to the right and down, based on the p |
includeValuesInResponse | boolean | — | If set to True, the response will include the updated values from the spreadsheet after the update is applied. |
Parameters from the server's own tool schema.
Why GOOGLESUPER_BATCH_UPDATE is rated Medium
This tool creates or modifies data in Google Sheets, which is the core definition of Write category. It is reversible (updates and appends can be undone), not destructive, and does not execute arbitrary code or trigger financial transactions.
From the tool's definition The tool 'Updates a specified range in a Google Sheet with given values, or appends them as new rows' directly modifies data in a spreadsheet. The capability to update ranges and append new rows constitutes reversible data modification.
Attacks that exploit this kind of access
The rule that runs GOOGLESUPER_BATCH_UPDATE 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, this is the rule to start with:
GOOGLESUPER_BATCH_UPDATE 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 call is checked against it from then on.
Questions about GOOGLESUPER_BATCH_UPDATE
Updates a specified range in a Google Sheet with given values, or appends them as new rows if first_cell_location is omitted. Auto-expands grid for large datasets, preventing range errors. Requirements: Target sheet must exist and spreadsheet must contain at least one worksheet. 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 accepts 6 parameters: values, sheet_name, spreadsheet_id, valueInputOption, first_cell_location, includeValuesInResponse. 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: 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 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 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. 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 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