// SCAN REPORT

Mcp Google Sheets

20 tools. 16 can modify or destroy data without limits.

3 destructive tools with no built-in limits. Policy required.

Last updated: 4 Oct 2026

16 can modify or destroy data

4 read-only

20 tools total

Community server · catalogue entry checked 01/09/2026 · full schemas captured for 20 of 20 tools

How to control Mcp Google Sheets ↓

TOOL MAP

What Mcp Google Sheets exposes to your agents

Read (4) Write / Execute (13) Destructive / Financial (3)

Running more than one server? Check your whole stack →

CONTEXT-WINDOW COST

What Mcp Google Sheets costs in tokens

10,940 tokens of tool definitions, loaded on every request

5.5% of a 200k context window

1,145 heaviest tool: set_borders

Full per-tool breakdown → Model it in the token calculator →

MOST DANGEROUS TOOLS

Critical Risk

The most dangerous Mcp Google Sheets tools

Destructive · High manage_sheets delete action permanently removes sheets and all contained data without recovery option. Destructive · High clear_values Irreversibly deletes cell content and formulas with no API-level undo capability. Destructive · High manage_dimensions Delete action irreversibly removes rows/columns and their data, shifting references permanently. Execute · Critical raw_request Arbitrary API access enables read, write, destructive, or bulk operations with no restrictions.

16 of Mcp Google Sheets's 20 tools can modify, destroy, or commit something on every call — and an agent calls them with no built-in limits.

POLICY

How to control Mcp Google Sheets

PolicyLayer is an MCP gateway — it sits between your AI agents and Mcp Google Sheets, and nothing reaches the server without passing your rules. These are the rules we recommend:

Deny destructive operations

{
  "clear_values": {
    "deny_if": [
      {
        "conditions": [],
        "on_deny": "Blocked by default. Requires approval."
      }
    ]
  }
}

Destructive tools should never be available to autonomous agents without human approval.

Rate limit write operations

{
  "batch_write_values": {
    "limits": [
      {
        "counter": "batch_write_values_per_hour",
        "window": "hour",
        "max": 30,
        "scope": "grant"
      }
    ]
  }
}

Prevents bulk unintended modifications from agents caught in loops.

Cap read operations

{
  "append_values": {
    "limits": [
      {
        "counter": "append_values_per_minute",
        "window": "minute",
        "max": 60,
        "scope": "grant"
      }
    ]
  }
}

Controls API costs and prevents retry loops from exhausting upstream rate limits.

Create a free account and register Mcp Google Sheets — nothing to install.
Add these rules — paste them, or build them visually. Tune the limits to your setup.
Point your MCP client (Claude, Cursor, anything) at your gateway URL.

ENFORCE POLICY ON MCP GOOGLE SHEETS →

Instant setup, no code required.

FULL CATALOGUE

All 20 Mcp Google Sheets tools

DESTRUCTIVE 3 tools

Destructive clear_values Empties the VALUES of one or more A1 ranges in a single call — cell contents and formulas are gone (no undo th Destructive manage_dimensions Row/column operations on a run of rows (dimension=ROWS) or columns (dimension=COLUMNS), addressed by sheet_id Destructive manage_sheets Manages the sheets (tabs) of a spreadsheet. action=add creates a tab (title required; optional index position

EXECUTE 1 tools

Execute raw_request Escape hatch to call any Google Sheets API v4 path directly, for requests the typed tools don't cover — e.g. a

WRITE 12 tools

Write batch_write_values Overwrites several A1 ranges in ONE call — one write against the per-minute quota instead of one per range, so Write create_spreadsheet Creates a new Google Sheets spreadsheet and returns it: spreadsheetId, spreadsheetUrl, properties (title, loca Write format_cells Applies cell formatting to a range: background_color, text color/bold/italic/strikethrough/underline/font_size Write manage_charts Manages embedded charts. action=add builds a chart from chart_type (COLUMN/BAR/LINE/AREA/STEPPED_AREA/SCATTER/ Write manage_conditional_formats Manages conditional-format rules that style cells when a condition holds (boolean rules; gradient color scales Write manage_permissions Shares the spreadsheet (Drive permissions on the file — the OAuth token needs a Drive scope; the spreadsheets Write manage_protected_ranges Manages protections that stop other editors from changing cells. action=add protects a grid range (or a named Write manage_tables Manages structured tables (the "Convert to table" feature: named ranges with per-column types, filters and for Write set_borders Draws borders around and/or inside a grid range. top/bottom/left/right are the range's outer edges; inner_hori Write set_data_validation Sets — or clears — a data-validation rule on a grid range. With condition_type set, every cell in the range ge Write set_frozen Freezes the first N rows and/or columns of a sheet so they stay visible while scrolling (typical: frozen_rows= Write write_values Overwrites one A1 range with a 2-D values matrix (rows first) and returns updatedRange/updatedRows/updatedColu

READ 4 tools

Read append_values Appends rows after the last row of the data table that contains the given range — pass the table's region (e.g Read get_spreadsheet Returns the spreadsheet's structure: properties (title, locale, timeZone), sheets[] with properties (sheetId, Read read_values Reads one or more A1 ranges in a single call (one request against the quota, however many ranges) and returns Read search_spreadsheets Finds Google Sheets spreadsheets the authorized user can open (own files and shared drives; trashed files are

EXPLORE

Related servers

Other MCP servers with similar tools — same risk classification, starter policies for each.

FAQ

Questions about Mcp Google Sheets

Can an AI agent delete data through the Mcp Google Sheets MCP server? +

Yes. The Mcp Google Sheets server exposes 3 destructive tools including clear_values, manage_dimensions, manage_sheets. These permanently remove resources with no undo. PolicyLayer blocks destructive tools by default so they never reach the upstream server.

How do I prevent bulk modifications through Mcp Google Sheets? +

The Mcp Google Sheets server has 12 write tools including batch_write_values, create_spreadsheet, format_cells. Set a rate limit in your policy -- for example, 10 calls per hour prevents an agent from making more than 10 modifications per hour. PolicyLayer enforces this at the gateway, before calls reach Mcp Google Sheets.

How many tools does the Mcp Google Sheets MCP server expose? +

20 tools across 3 categories: Destructive, Read, Write. 4 are read-only. 16 can modify, create, or delete data.

How do I enforce a policy on Mcp Google Sheets? +

Register the Mcp Google Sheets MCP server in PolicyLayer, apply the suggested rules above (adjust the limits to your use case), and point your AI client at the PolicyLayer proxy URL instead of the server directly. Your agents keep the same tools; PolicyLayer evaluates every call against policy before it executes. Nothing to install, live in minutes.

Enforce policy on every Mcp Google Sheets tool call.

Deterministic rules across all 20 Mcp Google Sheets tools. Per-identity grants. Full audit log. Live in minutes. Nothing to install.

ENFORCE POLICY ON MCP GOOGLE SHEETS →

Instant setup, no code required.

20 Mcp Google Sheets tools catalogued and risk-classified — across an index of 46,500+ MCP servers.

// WHERE THIS COMES FROM

These policies come from Mcp Google Sheets's registry record.

The record behind this page: verified identity, auth posture, risk grade, every tool classified, recommended policy — re-checked continuously.

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