// SCAN REPORT

Mcp Gsheets

40 tools. 25 can modify or destroy data without limits.

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

Last updated: 27 Jun 2026

25 can modify or destroy data

15 read-only

40 tools total

Community server · catalogue entry verified 27/06/2026

How to control Mcp Gsheets ↓

TOOL MAP

What Mcp Gsheets exposes to your agents

Read (15) Write / Execute (19) Destructive / Financial (6)

Running more than one server? Check your whole stack →

MOST DANGEROUS TOOLS

Critical Risk

The most dangerous Mcp Gsheets tools

Destructive · High sheets_batch_delete_sheets This tool permanently removes sheets from a spreadsheet, which cannot be undone programmatically. Destructive · High sheets_clear_values Clearing cell values in a spreadsheet destroys the data in those cells. Destructive · High sheets_delete_chart This tool performs an irreversible deletion operation. Destructive · High sheets_delete_columns Deleting columns from a spreadsheet permanently removes all data in those columns and cannot be undone by the tool itself.

25 of Mcp Gsheets's 40 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 Gsheets

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

Deny destructive operations

{
  "sheets_batch_delete_sheets": {
    "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

{
  "sheets_add_conditional_formatting": {
    "limits": [
      {
        "counter": "sheets_add_conditional_formatting_per_hour",
        "window": "hour",
        "max": 30,
        "scope": "grant"
      }
    ]
  }
}

Prevents bulk unintended modifications from agents caught in loops.

Cap read operations

{
  "sheets_batch_get_values": {
    "limits": [
      {
        "counter": "sheets_batch_get_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 Gsheets — 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 GSHEETS →

Instant setup, no code required.

FULL CATALOGUE

All 40 Mcp Gsheets tools

DESTRUCTIVE 6 tools

Destructive sheets_batch_delete_sheets Delete multiple sheets from a Google Sheets spreadsheet in a single operation Destructive sheets_clear_values Clear values in a specified range of a Google Sheets spreadsheet Destructive sheets_delete_chart Delete a chart from a Google Sheets spreadsheet Destructive sheets_delete_columns Delete one or more columns from a Google Sheet using a full-column A1 range Destructive sheets_delete_rows Delete one or more rows from a Google Sheet using a full-row A1 range Destructive sheets_delete_sheet Delete a sheet from a Google Sheets spreadsheet

WRITE 19 tools

Write sheets_add_conditional_formatting Add conditional formatting rules to a Google Sheet Write sheets_append_values Append values to the end of a table in a Google Sheets spreadsheet. Write sheets_batch_format_cells Format multiple cell ranges in a Google Sheet in a single operation Write sheets_batch_update_values Update values in multiple ranges of a Google Sheets spreadsheet Write sheets_copy_to Copy a sheet to another Google Sheets spreadsheet Write sheets_create_chart Create a chart in a Google Sheets spreadsheet. Sheet names with spaces should be quoted in ranges (e.g., Write sheets_create_spreadsheet Create a new Google Sheets spreadsheet Write sheets_duplicate_sheet Duplicate a sheet within a Google Sheets spreadsheet Write sheets_format_cells Format cells in a Google Sheet (colors, fonts, alignment, number formats) Write sheets_insert_date Insert properly formatted dates in Google Sheets with locale support and automatic detection Write sheets_insert_link Insert clickable links in Google Sheets cells with custom display text Write sheets_insert_rows Insert new rows at a specific position with optional data Write sheets_insert_sheet Add a new sheet to an existing Google Sheets spreadsheet Write sheets_merge_cells Merge cells in a Google Sheet Write sheets_unmerge_cells Unmerge cells in a Google Sheet Write sheets_update_borders Update borders of cells in a Google Sheet Write sheets_update_chart Update an existing chart in a Google Sheets spreadsheet Write sheets_update_sheet_properties Update properties of a sheet in a Google Sheets spreadsheet Write sheets_update_values Update values in a specified range of a Google Sheets spreadsheet.

READ 15 tools

Read sheets_batch_get_values Get values from multiple ranges in a Google Sheets spreadsheet Read sheets_check_access Check access permissions for a spreadsheet. Returns information about what operations are allowed. Read sheets_compare_ranges Compare cell formatting between two ranges of identical dimensions. Read sheets_get_basic_filter Read the Basic Filter (AutoFilter) configuration for a sheet, including the filtered range, Read sheets_get_border_map Returns a visual tabular map of borders for a range. Read sheets_get_conditional_formatting Read conditional formatting rules and banded ranges (alternating row/column colors) for a sheet. Read sheets_get_data_validation Read data validation rules (checkboxes, dropdown lists, custom formulas, etc.) from a sheet or range. Read sheets_get_formatting_compact Returns cell formatting for a range as compact A1Range→format pairs. Read sheets_get_full_sheet_snapshot One-shot tool: reads all structural and formatting metadata for a sheet in a single API call. Read sheets_get_merged_cells Get all merged cell ranges for a specific sheet. Returns each merge as A1 notation and GridRange coordinates. Read sheets_get_metadata Get metadata about a Google Sheets spreadsheet including sheet names, IDs, and properties Read sheets_get_sheet_dimensions Get column widths (pixelSize), row heights (pixelSize), hidden columns/rows, and frozen row/column counts for Read sheets_get_sheet_formatting Read cell formatting (background color, text color, font family, font size, bold, italic, Read sheets_get_sheet_structure Lightweight tool returning ONLY structural/dimensional metadata for a sheet — no per-cell data. Read sheets_get_values Get values from a specified range in a Google Sheets spreadsheet

EXPLORE

Related servers

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

FAQ

Questions about Mcp Gsheets

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

Yes. The Mcp Gsheets server exposes 6 destructive tools including sheets_batch_delete_sheets, sheets_clear_values, sheets_delete_chart. 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 Gsheets? +

The Mcp Gsheets server has 19 write tools including sheets_add_conditional_formatting, sheets_append_values, sheets_batch_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 Gsheets.

How many tools does the Mcp Gsheets MCP server expose? +

40 tools across 3 categories: Destructive, Read, Write. 15 are read-only. 25 can modify, create, or delete data.

How do I enforce a policy on Mcp Gsheets? +

Register the Mcp Gsheets 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 Gsheets tool call.

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

ENFORCE POLICY ON MCP GSHEETS →

Instant setup, no code required.

40 Mcp Gsheets tools catalogued and risk-classified — across an index of 43,000+ MCP servers.