freezeRowsAndColumns | PolicyLayer

WHAT IT DOES

What freezeRowsAndColumns does on Google Docs, Drive & Sheets MCP Server

AI agents use freezeRowsAndColumns to create or update resources in Google Docs, Drive & Sheets MCP Server — usually the action step of a workflow, after the agent has gathered context. Every call changes real data in your Google Docs, Drive & Sheets MCP Server environment.

WHY IT NEEDS A POLICY

Why freezeRowsAndColumns needs a policy

This tool creates or modifies spreadsheet formatting settings (freeze panes) in a reversible manner. It does not retrieve data (Read), execute arbitrary code (Execute), irreversibly delete data (Destructive), or move money (Financial). The action is clearly reversible—frozen rows/columns can be unfrozen by setting values to 0.

From the tool's definition Tool description states 'Pins rows and/or columns' and 'Set a value to 0 to unfreeze', indicating modification of spreadsheet view settings.

Attacks that exploit this kind of access

Recommended rule Ready

Verdict

freezeRowsAndColumns Rate-limited

freezeRowsAndColumns 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": {
    "freezeRowsAndColumns": {
      "limits": [
        {
          "counter": "freezerowsandcolumns_rate",
          "window": "minute",
          "max": 30,
          "scope": "grant"
        }
      ]
    }
  }
}

LIMIT THIS TOOL →

Instant setup, no code required.

PolicyLayer is an MCP gateway: every tool call is checked against your rule before it reaches Google Docs, Drive & Sheets MCP Server, so you can run agents against it safely.

FAQ

Questions about freezeRowsAndColumns

What does the freezeRowsAndColumns tool do? +

Pins rows and/or columns so they stay visible when scrolling. Use frozenRows=1 to freeze a header row. Set a value to 0 to unfreeze. It is categorised as a Write tool in the Google Docs, Drive & Sheets MCP Server MCP Server, which means it can create or modify data. Consider rate limits to prevent runaway writes.

How do I enforce a policy on freezeRowsAndColumns? +

Register the Google Docs, Drive & Sheets MCP Server MCP server in PolicyLayer and add a rule for freezeRowsAndColumns: 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 Google Docs, Drive & Sheets MCP Server. Nothing to install.

What risk level is freezeRowsAndColumns? +

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

Can I rate-limit freezeRowsAndColumns? +

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

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

freezeRowsAndColumns is provided by the Google Docs, Drive & Sheets MCP Server MCP server (rulords/google-docs-mcp-personal). PolicyLayer sits as a proxy in front of this server to enforce policies before tool calls reach the server.