Your AI can finally
manage your spreadsheets.
Hosted MCP for Google Sheets. Connect any AI client in 60 seconds — no code, no server, no card required.
Example · token URL config (or use OAuth sign-in)
{
"mcpServers": {
"sheetsgate": {
"url": "https://mcp.sheetsgate.com/mcp/YOUR_TOKEN",
"transport": "streamable-http"
}
}
}Set up in 3 minutes. Use it forever.
No server to deploy. No code to write. Just connect and ask.
Connect Google & pick your files
Authorize Google for Sheets, then choose exactly which spreadsheets your AI can access. Only the files you pick are ever reachable — nothing else in your Drive is touched.
Zero broad Drive access — you stay in control
Sign in with OAuth
Enter mcp.sheetsgate.com/mcp as the MCP server URL in your client and complete sign-in in the browser — recommended for Claude.ai, ChatGPT, and any remote MCP host.
Or use a token URL
Create a private MCP token in the dashboard and paste the URL into clients like Cursor or n8n that accept a custom URL path. Tokens are revocable and (on Pro+) scopeable to specific files and tools.
What is MCP, and why does it matter for Sheets?
Model Context Protocol (MCP) is an open standard that lets AI assistants call external tools over HTTP. When your AI client supports MCP, it can invoke SheetsGate's tools — sheets_read, sheets_write, and the rest — in response to your natural-language requests, with your Google credentials relayed securely server-side.
SheetsGate isthe MCP server. You don't write or host it — you connect Google once and paste one MCP URL into each assistant that should reach your spreadsheets.
Everything you need. Nothing you don't.
Per-token control PRO
Lock any token to specific files and tools. Read-only mode, file allowlists, optional per-column MCP rules, tool restrictions — enforced server-side.
27 built-in tools
Read, write, append, search Drive, create sheets, freeze rows, apply formatting, run batch updates — all from a single conversation.
Start free. Pay only when AI earns it.
No credit card to start. Upgrade when call volume and features match how your team ships.
Pro
Save 17% with annual billing
- 13 tools
- 5 tokens
- 4,000 calls/mo
- Token permissions & file restrictions
Team
Save 17% with annual billing
- All tools
- 20 tokens
- 10,000 calls/mo
- Token permissions & file restrictions
Enterprise
Custom
Unlimited scale. Custom SLA.
- All tools
- Unlimited tokens
- Unlimited calls/mo
- Token permissions & file restrictions
FREE is for exploring. BASIC is for light automation. PRO is for daily use. TEAM is for when your whole operation runs through Sheets. Enterprise is for regulated teams and org-wide rollouts.
Common use cases
Concrete patterns AI assistants handle well with hosted MCP — each block mentions the tools typically involved.
Automate CRM data entry
Ask your assistant to read lead rows with sheets_read, normalize fields, then commit updates through sheets_write or sheets_append without CSV exports.
Report generation
Combine ranges from multiple tabs via sheets_get_multiple, summarize in chat, and write executive summaries back using sheets_write.
Budget tracking
Append expenses with sheets_append, read running totals through sheets_read, and highlight anomalies using sheets_conditional_format.
Lead management
Discover the right workbook with drive_list, inspect metadata via drive_get_file, then insert qualified leads using sheets_append.
Team task tracking
Agents can sort backlog boards (sheets_sort), update status columns (sheets_write), and freeze headers (sheets_freeze) so everyone sees the same structure during standups.
Questions people actually ask
What is SheetsGate?
SheetsGate is a hosted Model Context Protocol (MCP) server for Google Sheets. You connect Google once, pick the exact spreadsheets your AI can use, then add a private MCP URL (or sign in via OAuth) to your AI client. Assistants can then read and update those spreadsheets on demand — without running any infrastructure.
What is MCP for Google Sheets?
Model Context Protocol (MCP) is an open standard that lets AI apps call external tools over HTTP. MCP for Google Sheets means those tools operate on live spreadsheets — reads, writes, and Drive access scoped to the specific files you authorize — through a hosted bridge like SheetsGate instead of ad-hoc scraping or brittle macros.
What can my AI actually do with SheetsGate?
It can read ranges, write and append rows, search Drive, fetch metadata, apply formatting, validate data, freeze panes, sort, delete rows or tabs, add formulas, and more — driven by tool calls your assistant chooses when you ask in natural language.
How does SheetsGate compare to Zapier?
Zapier excels at scheduled, deterministic workflows across hundreds of apps. SheetsGate is built for conversational automation: your AI issues MCP tool calls as the conversation evolves. Use Zapier when you need reliable multi-app pipes on a timer; use SheetsGate when the next action depends on reasoning or messy user requests.
Can ChatGPT access Google Sheets with SheetsGate?
Yes, when ChatGPT (or another client) is configured with an MCP endpoint that points at SheetsGate and you authenticate appropriately. Your AI then invokes the same Sheets and Drive tools as other MCP clients — scoped to only the spreadsheets you've authorized, under the Google account you linked.
Is SheetsGate free?
SheetsGate offers a free tier so you can connect and try MCP calls within published limits. Paid tiers add higher monthly quotas, more tokens, and advanced controls such as file-scoped tokens. See /pricing for live numbers.
What spreadsheet operations can an AI run?
Through MCP tools, an assistant can read and write cell values, append rows, clear ranges, fetch sheet metadata, list Drive files, create spreadsheets, apply conditional formatting, validate inputs, freeze rows or columns, sort data, delete rows or tabs, batch updates, and insert formulas — limited only by your plan tool list and any per-token restrictions you configure.
Does SheetsGate work with Cursor?
Yes. Cursor supports HTTP MCP servers: paste your dashboard token URL into the MCP configuration and the editor can call SheetsGate tools directly from the agent.
Does SheetsGate work with Perplexity or other AI tools?
Any product that can speak MCP over Streamable HTTP (or allows custom MCP connectors) can integrate. Compatibility improves as vendors ship MCP — check your client’s docs for “MCP” or “remote tools”.
What data does SheetsGate store?
SheetsGate stores encrypted OAuth tokens, billing metadata, MCP token hashes, usage telemetry, and dashboard settings — not a replica of your workbook contents. Spreadsheet data stays in Google and flows through Google APIs only when a tool executes.
Do I need to know how to code?
No. You authorize Google, copy an MCP URL into your AI app (or finish OAuth if prompted), and start asking questions. There is no workflow DSL or deployment step.
Which AI tools work with SheetsGate?
Any MCP-capable HTTP client works: Cursor, Windsurf, Zed, Claude Desktop-style configs, n8n, LangChain, and others. Hosted assistants vary — use OAuth-friendly flows when they cannot store a raw MCP URL.
Is my spreadsheet data safe?
Traffic is TLS-encrypted end to end. Access is scoped to only the specific spreadsheets you granted through the file picker — nothing else in your Drive is reachable. You can revoke Google access or individual MCP tokens anytime from the dashboard. We never store or publish your spreadsheet data.