MCP Tool Reference Critical Risk

sheets_spreadsheets_values_batchClearByDataFilter

Permanently clear values from ranges by data filter. Cannot be undone

Part of the Google Workspace Sheets (gws CLI) MCP server. Enforce policies on this tool with Intercept, the open-source MCP proxy.

gws mcp -s sheets Destructive

WHEN AI AGENTS USE THIS TOOL

AI agents may call sheets_spreadsheets_values_batchClearByDataFilter to permanently remove or destroy resources in Google Workspace Sheets (gws CLI). Without a policy, an autonomous agent could delete critical data in a loop with no way to undo the damage. Intercept blocks destructive tools by default and requires explicit human approval before enabling them.

WHY ENFORCE A POLICY ON SHEETS_SPREADSHEETS_VALUES_BATCHCLEARBYDATAFILTER

Without a policy, an AI agent could call sheets_spreadsheets_values_batchClearByDataFilter in a loop, permanently destroying resources in Google Workspace Sheets (gws CLI). There is no undo for destructive operations. Intercept blocks this tool by default and only allows it when a human explicitly approves the action.

RECOMMENDED POLICY

Destructive tools permanently remove data. Block by default. Only enable with explicit approval workflows.

google-workspace-sheets.yaml 
tools:
  sheets_spreadsheets_values_batchClearByDataFilter:
    rules:
      - action: deny
        reason: "Blocked by default — enable with approval"

See the full Google Workspace Sheets (gws CLI) policy for all 17 tools.

DETAILS

Tool Name

sheets_spreadsheets_values_batchClearByDataFilter

Category

Destructive

MCP Server

Google Workspace Sheets (gws CLI)

Risk Level

Critical

MORE GOOGLE WORKSPACE SHEETS (GWS CLI) TOOLS

sheets_spreadsheets_values_batchClear Destructive
Permanently clear values from multiple ranges. Cannot be undone
sheets_spreadsheets_values_clear Destructive
Permanently clear values from a range. Cannot be undone
sheets_spreadsheets_developerMetadata_get Read
Get developer metadata by ID [read]
sheets_spreadsheets_developerMetadata_search Read
Search developer metadata [read]
sheets_spreadsheets_get Read
Get a spreadsheet's metadata and sheets [read]
sheets_spreadsheets_getByDataFilter Read
Get a spreadsheet filtered by data criteria [read]
sheets_spreadsheets_values_batchGet Read
Get values from multiple ranges [read]
sheets_spreadsheets_values_batchGetByDataFilter Read
Get values from ranges by data filter [read]

View all 17 tools →

SIMILAR DESTRUCTIVE TOOLS ON OTHER SERVERS

delete_record Airtable
Remove a record
delete_session Appium
Delete the current session and clean up
appium_uninstallApp Appium
Uninstall an app from the device
deleteCompassComponent Atlassian Rovo
Delete a Compass component
deleteConfluencePage Atlassian Rovo
Delete a Confluence page
delete_resource AWS
Delete AWS resources

RELATED READING

FREQUENTLY ASKED QUESTIONS

What does the sheets_spreadsheets_values_batchClearByDataFilter tool do?

Permanently clear values from ranges by data filter. Cannot be undone. It is categorised as a Destructive tool in the Google Workspace Sheets (gws CLI), which means it can permanently delete or destroy data. Block by default and require explicit approval.

How do I enforce a policy on sheets_spreadsheets_values_batchClearByDataFilter?

Add a rule in your Intercept YAML policy under the tools section for sheets_spreadsheets_values_batchClearByDataFilter. You can allow, deny, rate-limit, or validate arguments. Then run Intercept as a proxy in front of the Google Workspace Sheets (gws CLI) MCP server.

What risk level is sheets_spreadsheets_values_batchClearByDataFilter?

sheets_spreadsheets_values_batchClearByDataFilter 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 sheets_spreadsheets_values_batchClearByDataFilter?

Yes. Add a rate_limit block to the sheets_spreadsheets_values_batchClearByDataFilter 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.

How do I block sheets_spreadsheets_values_batchClearByDataFilter completely?

Set action: deny in the Intercept policy for sheets_spreadsheets_values_batchClearByDataFilter. 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 sheets_spreadsheets_values_batchClearByDataFilter?

sheets_spreadsheets_values_batchClearByDataFilter is provided by the Google Workspace Sheets (gws CLI) MCP server (gws mcp -s sheets). Intercept sits as a proxy in front of this server to enforce policies before tool calls reach the server.

ENFORCE POLICIES ON GOOGLE WORKSPACE SHEETS (GWS CLI)

Open source. One binary. Zero dependencies.

VIEW ON GITHUB Full Google Workspace Sheets (gws CLI) policy →