Everything Your AI Can Do the Second You Connect SheetsGate

Connect SheetsGate to Claude, Cursor, or n8n and your AI immediately gets a catalog of 20+ spreadsheet tools — not "AI can help with spreadsheets" in the abstract, but named, specific abilities it can invoke the moment you ask. This is the tour of what's in the box, with the prompts that trigger each capability.

(Tool availability varies by plan — the free tier covers the core read/write loop; higher tiers unlock the power tools. Full matrix on the pricing page.)

The core loop: read, write, append, create

The four tools you'll use every day:

• Read any range — "What's in Sheet1 A1 to D50?" Live data, structured, straight from the sheet as it is right now.
• Write and update cells — "Change the status in row 12 to 'Shipped'."
• Append rows — "Add these leads to the bottom of the CRM sheet." Appends physically can't overwrite existing data, which makes this the workhorse for capture workflows.
• Create spreadsheets — "Make a new sheet for the offsite budget with headers for item, owner, and cost." Files your AI creates through SheetsGate are automatically accessible to it — no extra setup.

Discovery: your AI finds the right file itself

No more hunting for spreadsheet IDs in URLs:

• Search Drive — "Find the spreadsheet with the 2026 vendor contracts." Searches the files you've granted, by name.
• Get metadata — "What tabs does the budget sheet have, and how big are they?" Tab names, dimensions, and titles — so the AI understands a file's structure before touching data.
• Find values — "Which cells mention Acme Corp?" Returns the matching cell locations.
• Read several ranges at once — the AI can pull multiple ranges in a single request when a question spans tabs.

Power tools: the stuff that used to be your job

This is where it stops being a data pipe and starts being an assistant:

• Formulas — "Add a column that flags any expense 20% over its category average — as a live formula." The AI writes the =IF(...) so the sheet keeps computing after the conversation ends. It can also extract existing formulas to explain or debug a sheet someone else built.
• Charts — "Chart weekly signups as a line graph." Real charts, created in the sheet.
• Formatting — "Bold the header row and put a border under it." Colors, bold/italic, borders — single ranges or many ranges in one batched call.
• Conditional formatting — "Turn a cell red when the deadline has passed." Rules by cell value that keep working forever.
• Data validation — "Make the status column a dropdown: Todo, Doing, Done." Dropdowns, checkboxes, numeric and date rules.
• Find & replace — "We renamed the product — replace 'SheetPilot' with 'SheetsGate' everywhere in this sheet."
• Structure operations — add tabs, duplicate tabs across spreadsheets, rename, insert rows, sort by any column, freeze headers, delete rows or whole tabs.
• Batch updates — multiple changes executed atomically, so a complex edit either fully lands or doesn't happen.

One prompt that shows the compounding effect: "Set up my expenses sheet: freeze the header, make the category column a dropdown, highlight anything over $500, and add a totals row with formulas." That's five tools, one sentence.

The platform around the tools

Any MCP server can expose tools. These are the SheetsGate features that make the connection something you can run your actual work on:

Workspaces — set your rules once

Standing instructions plus pinned files, applied to every session automatically. Write "Amounts are USD. Fiscal year starts April. Column A is IDs — never modify it." once in your dashboard, pin your key files, and every AI session connected to that workspace starts with that context. Update it once; every tool you've connected inherits the change. No more re-explaining your conventions in every new chat.

Per-token permissions — different tools, different trust

Each connection gets its own token (paid plans include several), and token permissions can make a token read-only, restrict it to specific tools, or restrict it to specific files — the AI is even told the file names it's allowed to work with, so it doesn't grope around with opaque IDs. Column protections mark ranges the AI must never modify, enforced server-side. Your n8n automation sees one sheet; your personal Claude sees your planning docs; neither can reach the other's. Revoke any token in one click without touching the rest.

Confirmation before destruction

Destructive tools — deleting rows, deleting a sheet tab — ask for your explicit confirmation first in AI clients that support MCP's confirmation flow. "Delete the March tab" becomes a dialog you approve, not a silent action.

A usage log you can actually read

Every call, per token: which tool, when, how fast, success or failure — live in your dashboard. When you wonder "what has the AI been doing in my sheets?", the answer is a page, not a shrug. There's even a server_info tool the AI itself can call to check its plan, remaining usage, and available tools mid-conversation.

Security as the default

Google's drive.file scope (only files you explicitly grant — never your whole Drive), AES-256-GCM encryption for your Google tokens at rest, bcrypt-hashed access tokens, and rate limiting per token. Not settings you enable — just how it works.

Frequently asked questions

Which tools do I get on the free tier?

The core loop — reading, writing, appending, sheet metadata, and Drive search — which is enough to run real report-and-capture workflows and decide if it earns an upgrade. Power tools (formulas, charts, formatting, and friends) come with paid tiers; the current matrix is on the pricing page.

Do these tools work the same in Claude, Cursor, and n8n?

Yes — the tool catalog lives on the server, so every MCP client gets the same abilities from the same endpoint URL. Set up once, use everywhere.

Can the AI use several tools in one request?

Yes, and that's where it shines: "set up this sheet properly" routinely chains reads, writes, formatting, validation, and freezing in one conversational turn.

What can't it do?

It can only operate on spreadsheets you've granted, only through the tools listed, within your token's restrictions and its plan's monthly call allowance. There is deliberately no "escape hatch" beyond the catalog — that boundary is the security model.

---

Fastest way to get it: connect free, then run the 60-second Claude walkthrough. If you're deciding whether to trust AI with real data first, read how the safety system works.