manage_tables

SERVERMcp Google Sheets SOURCE@a1-x-tech/mcp-google-sheets

Medium RISK CLASS

Category Write

Parameters 62 required

Recommended Rate-limitedsee the rule below

Registry record Grade F, identity unverified Pull the record →

This record as markdown: /tools/a1-x-tech-mcp-google-sheets/manage-tables.md

WHAT IT DOES

What manage_tables does on Mcp Google Sheets

AI agents use manage_tables to create or update resources in Mcp Google Sheets, usually the action step of a workflow, after the agent has gathered context. Every call changes real data in your Mcp Google Sheets environment.

Parameter	Type	Required	Description
`name`	string	—	add (required) / update: the table's unique name.
`range`	object	—	add (required) / update: the table's cells incl. the header row.
`action`	string	Yes	What to do with the tables.
`table_id`	string	—	update/delete: the tableId from get_spreadsheet or the add reply.
`spreadsheet_id`	string	Yes	The spreadsheet id — the long id from the URL (docs.google.com/spreadsheets/d/<spreadsheetId>/edit) or from create_spreadsheet / search_spreadsheets output.
`column_properties`	array	—	add: raw TableColumnProperties list, e.g. [{"columnIndex":0,"columnName":"Task","columnType":"TEXT"}].

Parameters from the server's own tool schema.

RISK

Why manage_tables is rated Medium

Creates structured data artifacts and modifies spreadsheet organization reversibly via table management operations.

From the tool's definition Creates tables, adds column types, filters, formatting, dataValidationRule

Risk signalsHigh parameter count (11 properties)

Attacks that exploit this kind of access

RECOMMENDED RULE

The rule that runs manage_tables safely

PolicyLayer is an MCP gateway: it sits between your AI agents and Mcp Google Sheets, and checks every tool call against a rule you set before the call runs. Nothing changes on the server itself. For manage_tables, this is the rule to start with:

manage_tables Rate-limited

manage_tables 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.

View as policy code

policy.json

{
  "version": "1",
  "default": "deny",
  "tools": {
    "manage_tables": {
      "limits": [
        {
          "counter": "manage_tables_rate",
          "window": "minute",
          "max": 30,
          "scope": "grant"
        }
      ]
    }
  }
}

LIMIT THIS TOOL → Instant setup, no code required.

The button opens the PolicyLayer dashboard: create your workspace, connect Mcp Google Sheets, apply this rule, and every manage_tables call is checked against it from then on.

FAQ

Questions about manage_tables

What does the manage_tables tool do? +

Manages structured tables (the "Convert to table" feature: named ranges with per-column types, filters and formatting). action=add creates a table over a grid range whose FIRST ROW becomes the header: name (must be unique in the spreadsheet) + range required; column_properties optionally types the columns — a list of raw TableColumnProperties objects, e.g. [{"columnIndex":0,"columnName":"Task","columnType":"TEXT"},{"columnIndex":1,"columnName":"Done","columnType":"BOOLEAN"}] (columnType TEXT/PERCENT/DROPDOWN/DOUBLE/CURRENCY/DATE/TIME/DATE_TIME/BOOLEAN; DROPDOWN adds dataValidationRule). The reply carries the new table with its tableId. action=update renames and/or re-ranges an existing table (table_id + name and/or range; expanding the range grows the table). action=delete removes the TABLE DEFINITION only — the cell data stays; clear the cells separately if needed. Find tableIds via get_spreadsheet (sheets[].tables). It is categorised as a Write tool in the Mcp Google Sheets MCP Server, which means it can create or modify data. Consider rate limits to prevent runaway writes.

What parameters does manage_tables accept? +

manage_tables accepts 6 parameters: name, range, action, table_id, spreadsheet_id, column_properties. Required: action, spreadsheet_id. The full parameter table on this page comes from the server's own tool schema.

How do I enforce a policy on manage_tables? +

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

What risk level is manage_tables? +

manage_tables is a Write tool with medium risk. Write tools should be rate-limited to prevent accidental bulk modifications.

Can I rate-limit manage_tables? +

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

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

manage_tables is provided by the Mcp Google Sheets MCP server (@a1-x-tech/mcp-google-sheets). PolicyLayer sits as a proxy in front of this server to enforce policies before tool calls reach the server.

KEEP EXPLORING

More on Mcp Google Sheets, and thousands of servers like it.

This server

All 20 Mcp Google Sheets tools →

Across the catalogue

The MCP Attack Database →

Guides

Govern customer-ops agents →Argument validation →Scoped token →