Reads
Answer straight away. Nothing changes.
- Typed bounded ranges and sheet metadata
Workspace · MCP server
Google Sheets MCP server
Turn report data into reviewed sheet edits.
MegaMCP is a hosted Google Sheets MCP server that lets Claude, ChatGPT and Cursor read ranges, tabs and cell formatting and propose cell and formatting changes and new spreadsheets that you approve.
Rolling outBuilt, and switching on as approvals land.What this meansRolling out means the code is built and the platform is still approving MegaMCP's app: Google, Meta, Microsoft and the one-click ad-platform sign-ins switch on as each approval lands.
- Tools
- 3 reads, 3 writes
- Works with
- Claude, ChatGPT, Cursor, Claude Code and VS Code
- Price
- Free to read, changes from $19/mo
Google Sheets3 reads · 3 changesMegaMCPApproval gate
- Claude
- ChatGPT
- Cursor
Live demo
Watch it work on Google Sheets
Ask in plain English. Your AI reads Google Sheets with real MegaMCP tools, then hands you a plan. Nothing moves until a person clicks Approve, and supported changes can be undone.
Tools in this example
google_sheets_read_rangeReads live datagoogle_sheets_update_rangeProposes a change plan
- You
Update the Report tab with last week's numbers.
- Claude
google_sheets_read_rangeDone'Report'!A1:D12google_sheets_update_rangeWaiting for approvalplan readyRow 4 still has the week before. Here's the update; formulas elsewhere stay as they are.
Update a rangeGoogle Sheets · Acme weekly report2 changes- Change: B4 · Spend
$4,120$4,385 - Change: C4 · Conversions
96104 - Check passed: Stops if the range changed since this plan
- Change: B4 · Spend
- Claude
Updated. Undo restores the previous values and formulas.
What your AI can do
Google Sheets MCP tools
Read bounded ranges and tab metadata, propose rectangular cell updates, and create a spreadsheet from explicit supplied data. This list comes straight from the running product: 3 read tools and 3 write tools.
3 tools
Changes you approve
Each one returns a plan with a diff. Nothing moves until a person approves.
- Reviewed rectangular updates preserving formulas for undo
- Review formatting for at most 100 existing, unmerged cells
- Create spreadsheets with explicit data
Google Sheets guardrail
Updates stop on observed range drift. Formatting preserves values but has no atomic row/column race guarantee. Creations are non-reversible; they never grant automatic account access.
Plus complete diff previews, human approvals and the flight recorder on every connection. Live changes require a paid plan.
All 6 Google Sheets tools3 reads, 3 changes · straight from the running product
| What it does | Tool id | Type |
|---|---|---|
| Read range | google_sheets_read_range | Read |
| List tabs | google_sheets_get_spreadsheet | Read |
| Propose range update | google_sheets_update_range | Change |
| Propose report spreadsheet | google_sheets_create_spreadsheet | Change |
| Inspect exact bounded range formatting | google_sheets_inspect_range_format | Read |
| Review bounded range formatting | google_sheets_format_range | Change |
Example prompts
Google Sheets MCP prompts
Paste any of these into Claude, ChatGPT or Cursor once Google Sheets is connected.
“Read 'Report'!A1:D12.”
“Propose updating this report range with these values.”
“Create a spreadsheet draft from this supplied table.”
“List the tabs in this spreadsheet.”
“Write last week's Google Ads totals into rows 2 to 8 of the Report tab.”
“Bold the header row and format column D as currency.”
“Inspect the formatting on A1:F1.”
“Create a spreadsheet with this month's campaign table.”
Setup
Google Sheets MCP setup in 3 steps
About two minutes for Claude, ChatGPT or Cursor. Nothing to install.
Connect Google Sheets
Start a free workspace and open Connections. Connect optional Google Workspace, authorize a file or use a creation account, assign a client and explicitly enable it.
Add MegaMCP to your AI app
Every app uses the same server URL.
MCP server URLhttps://megamcp.com/api/mcpAsk in plain English
Try “Read 'Report'!A1:D12.” Reports answer straight away. Anything that changes Google Sheets comes back as a plan for you to approve.
Safety
Hand AI the keys. Keep the brakes.
The same loop guards every MegaMCP connection: ask, see the diff, approve, undo.
Approval before every change
Google Sheets write tools never touch Google Sheets directly. They return a plan, and a person approves it in the dashboard, or in chat if an admin allows it.
Approval requestedGoogle Sheets · 1 plan waitingDashboard · just now
A diff first
Every plan lists each change with its before and after values, so you see exactly what will move before it does.
Plan previewGoogle Sheets1 change
- Change: Value
BeforeAfter - Check passed: Checked again right before it applies
Undo for supported changes
Supported changes reverse through a separately reviewed undo plan. Anything that can't be undone is marked before you approve it.
Undo plan readyRestores the previous valuesReviewed like any other change
Receipts for everything
Platform checks stop stale edits, and the flight recorder logs every tool call, plan and approval, with who did it and from which AI app.
| Time | Event |
|---|---|
| 09:14 | google_sheets_read_range |
| 09:15 | Plan created by Claude |
| 09:16 | Approved by Ana |
Workflows
Scheduled workflows that use Google Sheets
Ready-made jobs that run on a schedule and send you what they found. Anything they want to change waits for approval.
LaunchComing soon
Meta Ads Bulk Uploader
Fill a sheet with headlines, copy and creative links. MegaMCP builds every ad, names it properly, and uploads it paused.
On demand
You getPaused ads in Meta, plus a sheet column with each new ad ID.
- Google Sheets
Google Drive
Meta Ads
LaunchComing soon
TikTok Ads Bulk Uploader
The same sheet-to-ads magic for TikTok. Dozens of variations, zero copy-paste.
On demand
You getPaused TikTok ads with IDs written back to the sheet.
- Google Sheets
- Google Drive
TikTok Ads
FAQ
Google Sheets MCP server questions
Is there an official Google Sheets MCP server?
Yes. As of October 2026, Google offers remote MCP servers for Workspace apps, including Sheets, as a Developer Preview. MegaMCP takes a narrower route built for client work: tools only see the Sheets files you explicitly enable for a client, and every change is a plan a person approves.
What is a Google Sheets MCP server?
An MCP (Model Context Protocol) server lets AI assistants such as Claude, ChatGPT and Cursor use Google Sheets through tools. MegaMCP's hosted Google Sheets MCP server gives your assistant 3 read tools and 3 write tools for ranges, tabs and cell formatting, and every change waits for a human approval.
Does the Google Sheets MCP server work with ChatGPT?
Yes. MegaMCP is a remote MCP server with OAuth sign-in, so one URL works in ChatGPT (as an app, with developer mode on), Claude (as a custom connector), Cursor, Claude Code and VS Code. Your AI app's own plan decides whether it can add custom MCP servers.
Can it make changes to my Google Sheets account?
Yes, with your approval. It can propose cell and formatting changes and new spreadsheets changes. Each one comes back as a plan with a line-by-line diff and waits for a human before anything moves. Updates stop on observed range drift. Formatting preserves values but has no atomic row/column race guarantee. Creations are non-reversible; they never grant automatic account access.
How do I connect Google Sheets to Claude or ChatGPT?
Connect optional Google Workspace, authorize a file or use a creation account, assign a client and explicitly enable it.
What does the Google Sheets MCP server cost?
Reading Google Sheets is free on MegaMCP's Free plan (100 reads a day, no card). Approved changes are included in every paid plan, from $19/month after a 5-day free trial, with unlimited runs and no credits. MegaMCP adds no markup: any subscription or API usage with the vendor stays between you and them.
Is my Google Sheets data safe?
Your Google Sheets credentials are encrypted at rest (AES-256-GCM) and bound to their connection, and MegaMCP never trains AI models on your data. Your AI only sees the accounts you switch on, members limited to certain clients only see those clients, and every tool call lands in the flight recorder.
Keep exploring
More MCP servers
More files, docs and messaging
Google Drive MCPRolling outAuthorize the files your team needs.
Google Docs MCPRolling outDraft reports with a traceable source.
Google Slides MCPRolling outBuild a deck from supplied evidence.OneDrive MCPRolling outRead the client folder you choose.SharePoint MCPRolling outKeep client document libraries in scope.
Dropbox MCPRolling outRead the Dropbox folder your client approves.SMTP Email MCPLiveReview every email before it leaves.Slack MCPLiveReview the report before it reaches the channel.Popular integrations
Google Ads MCPRolling outRun Google Ads from one sentence.Meta Ads MCPRolling outMeta Ads, minus the Ads Manager maze.
Google Analytics MCPRolling outAsk GA4 questions in plain English.
HubSpot MCPLiveClose the loop between ads and pipeline.
Shopify MCPLiveAsk your store how it's doing.
WordPress MCPLiveFix your WordPress site by asking.Learn more
5 days. On the house.
Put Mega to work. Your ad budget stays yours.
No credit card to start. Every workspace comes with a sandbox ad account, so you can watch the whole ask, diff, approve, undo loop before you connect anything real.