get_spreadsheet_metadata_tool

THE RISK

Low Risk

Why get_spreadsheet_metadata_tool needs a policy

This tool retrieves metadata (sheet names and properties) from a spreadsheet without creating, modifying, deleting, or executing any operations. It is a read-only query that has no side effects and minimal blast radius if misused by an AI agent.

From the tool's definition Tool description states it 'Get metadata about a spreadsheet including all sheet names and properties' — a retrieval operation with no modification or execution capability.

Documented attack patterns abuse exactly the kind of access get_spreadsheet_metadata_tool gives an agent:

POLICY

How to control get_spreadsheet_metadata_tool

PolicyLayer is an MCP gateway — it sits between your AI agents and Apps Script MCP, and nothing reaches the server without passing your rules. This is the rule we recommend for get_spreadsheet_metadata_tool:

policy.json

{
  "version": "1",
  "default": "deny",
  "tools": {
    "get_spreadsheet_metadata_tool": {}
  }
}

get_spreadsheet_metadata_tool is read-only, so it stays allowed — but everything else on the server is denied unless you say otherwise.

Create a free account and register Apps Script MCP — nothing to install.
Add this policy — paste it, or build it visually.
Point your MCP client (Claude, Cursor, anything) at your gateway URL.

CAP THIS TOOL →

Free to start. No card required.

EXPLORE

Related tools and policies

More Apps Script MCP tools

Destructive delete_deployment_tool Delete a deployment. Destructive delete_drive_file_tool Permanently delete a file from Google Drive. Destructive delete_event_tool Delete a calendar event. Destructive delete_script_project_tool Delete an Apps Script project. Destructive delete_task_tool Delete a task from Google Tasks. Destructive remove_drive_permission_tool Remove a permission from a file or folder. Destructive trash_drive_file_tool Move a file to trash in Google Drive (recoverable). Execute run_script_function_tool run_script_function_tool

All 60 Apps Script MCP tools →

Read tools on other servers

M-Team MCP Server get_torrent_detail YouTube MCP Server search_channel Android Forensics ADB MCP Server parse_browser_history 0xarchive web3_challenge

Go deeper

The MCP Attack Database → Documented attack patterns against MCP deployments — and the policies that stop them.
Data exfiltration → How read access becomes an exfiltration channel when chained with untrusted content.
MCP token cost → What connecting this server costs in context-window tokens on every request.
Rate Limiting MCP Tool Calls: A Practical Guide →
MCP Security: Why Prompt Guardrails Aren't Enough →

FAQ

Questions about get_spreadsheet_metadata_tool

What does the get_spreadsheet_metadata_tool tool do? +

Get metadata about a spreadsheet including all sheet names and properties. It is categorised as a Read tool in the Apps Script MCP MCP Server, which means it retrieves data without modifying state.

How do I enforce a policy on get_spreadsheet_metadata_tool? +

Register the Apps Script MCP server in PolicyLayer and add a rule for get_spreadsheet_metadata_tool: 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 Apps Script MCP. Nothing to install.

What risk level is get_spreadsheet_metadata_tool? +

get_spreadsheet_metadata_tool is a Read tool with low risk. Read-only tools are generally safe to allow by default.

Can I rate-limit get_spreadsheet_metadata_tool? +

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

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

get_spreadsheet_metadata_tool is provided by the Apps Script MCP server (sam-ent/google-automation-mcp). PolicyLayer sits as a proxy in front of this server to enforce policies before tool calls reach the server.

Enforce policy on every Apps Script MCP tool call.

Start from Apps Script MCP, add the rest of your stack, and see everything your agents can call. Then put policy on all of it.

CHECK YOUR STACK →