delete_table_rows

Deletes rows in a table matching criteria. match_conditions should be JSON object like {\"column_name\":\"value\"}.

Server Google Sheets MCP Server santiagopereda/mcp_googlesheets
Category Destructive
Risk class Critical
Parameters 00 required

What delete_table_rows does on Google Sheets MCP Server

AI agents call delete_table_rows to permanently remove resources in Google Sheets MCP Server — typically in cleanup and lifecycle workflows. It does its job in a single call, and there is no undo.

Why delete_table_rows needs a policy

This tool irreversibly removes data from a spreadsheet table based on match conditions. Deletion is a destructive, non-reversible operation that cannot be undone through normal API calls. While the blast radius is somewhat limited by requiring explicit match criteria (reducing risk vs. blanket deletion), the core capability is destructive data removal.

From the tool's definition Tool name explicitly states 'delete_table_rows'. Description confirms it 'Deletes rows' matching specified criteria, with no mention of undo, soft-delete, or recovery mechanism.

Questions about delete_table_rows

What does the delete_table_rows tool do? +

Deletes rows in a table matching criteria. match_conditions should be JSON object like {\"column_name\":\"value\"}. It is categorised as a Destructive tool in the Google Sheets MCP Server MCP Server, which means it can permanently delete or destroy data. Block by default and require explicit approval.

How do I enforce a policy on delete_table_rows? +

Register the Google Sheets MCP Server MCP server in PolicyLayer and add a rule for delete_table_rows: 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 Sheets MCP Server. Nothing to install.

What risk level is delete_table_rows? +

delete_table_rows is a Destructive tool with critical risk. Critical-risk tools should be blocked by default and only enabled with explicit human approval.

Can I rate-limit delete_table_rows? +

Yes. Add a rate_limit block to the delete_table_rows 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 delete_table_rows completely? +

Set action: deny in the PolicyLayer policy for delete_table_rows. 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 delete_table_rows? +

delete_table_rows is provided by the Google Sheets MCP Server MCP server (santiagopereda/mcp_googlesheets). PolicyLayer sits as a proxy in front of this server to enforce policies before tool calls reach the server.

// LOOK UP ANOTHER SERVER

Every MCP server has a record like this.

Type a name, get the same breakdown: verified identity, auth posture, risk grade, capabilities, recommended policy.

Teams ship this data inside their own products. See what a licence covers →

// GET IN TOUCH

Have a question or want to learn more? Send us a message.

Message sent.

We'll get back to you soon.