MCP server
Google Sheets MCP server
Google's own Sheets MCP server lets AI read and update cell values and formulas, change spreadsheet structure and insert rows or columns.
- Official server
- Productivity
Why it matters
What it does and why it matters
Spreadsheets are where many businesses really run: price lists, trackers, budgets and reports. Google's own Sheets MCP server lets an assistant read values, read spreadsheet details, update values and formulas, change spreadsheet settings and insert rows or columns.
That supports questions such as "what are total sales by region in this sheet" and tasks such as "add this week's numbers to the tracker".
At review time, it is part of Google's Workspace developer preview program, which requires membership. It can overwrite values and formulas, so we work on copies or specific ranges while testing, and keep version history on so changes can be rolled back.
For sheets that feed reports or other systems, we protect key ranges and give the assistant a separate input tab to write to. That keeps formulas and totals safe while still letting the assistant do the typing.
Use cases
Best business use cases
Formulas
Restructure
Report prep
Tools
Available tools
Tool names as published by the maintainer at review time. Versions change, so check the repository for the current list.
Read and write: Read and write for spreadsheet values, formulas and structure.
-
get_valuesReads cell values and grid data.
-
get_spreadsheetGets sheet names and spreadsheet metadata.
-
update_valuesWrites cell values.
-
update_formulasSets or updates formulas.
-
update_spreadsheetRuns structural batch updates.
-
insert_dimensionInserts rows or columns.
Workflows
Example workflows
Weekly numbers update
-
1
Share this week's figures.
-
2
The assistant finds the tracker sheet.
-
3
It adds a row with the figures.
-
4
It checks totals update correctly.
-
5
It reports the change.
Fix a broken formula
-
1
Point to the cell with an error.
-
2
The assistant reads the formula and data.
-
3
It explains the problem.
-
4
It proposes a fix.
-
5
It updates the formula after approval.
Prompts
Example prompts
“What were total sales by region in the Q3 sheet?”
“Add this week's figures as a new row in the Sales Tracker.”
“Why does cell F12 show an error, and how do I fix it?”
Setup
Installation and configuration
Examples for Claude Desktop and Claude Code. Replace the placeholder values with your own keys, and store secrets outside version control.
Claude Code: terminal
claude mcp add --transport http --client-id YOUR_CLIENT_ID --client-secret --callback-port 8080 google-sheets https://sheetsmcp.googleapis.com/mcp/v1- Hosted server: https://sheetsmcp.googleapis.com/mcp/v1.
- Needs: OAuth 2.0 client ID and secret from your own Google Cloud project..
Security
Security considerations
-
Limit workspaces
Connect with an account that sees only the workspaces or projects a task needs.
-
Mark AI-created items
Use a label or naming rule so items created by the assistant are easy to spot and review.
-
Guard deletes
Keep version history on so overwritten values can be restored.
-
Untrusted text
Task descriptions and comments can contain misleading text. Treat them as data.
Related servers
Servers that pair well with it
Google Drive
Google's own Drive MCP server lets AI search, read and create files in Google Drive, with your Google Workspace sign-in.
Airtable
Airtable's official hosted MCP server lets AI list workspaces, create bases and read records, with wider read and write access to tables and automations.
BigQuery
Google's remote BigQuery MCP server lets AI list datasets and tables and run SQL, with a read-only query tool and IAM controls.
Keep exploring
Solutions and services that use it
Related services
View all related services- MCP integration Connect AI assistants to your CRM, files, databases and tools through Model Context Protocol servers, with safe permissions.
- AI workflows Step-by-step automations where AI handles the reading, sorting and drafting inside a process you control.
- Internal tools Custom software for your own team: trackers, approval flows and back-office systems that replace spreadsheets.
- Automation and Integrations CRM, payment and API integrations, MCP connections and workflows that stop people copying data by hand.
- Web applications Custom browser-based software for the work your team does every day, from booking tools to operations systems.
- Dashboards and reporting Dashboards that pull numbers from the systems you already use and show what matters without a spreadsheet.
Solutions
View all solutions- Automated reporting Reports that build themselves from your systems on schedule, with a plain-language summary of what changed.
- AI automation and integrations Connect the tools you already use so data moves once, correctly, and AI reads the parts that arrive as text or documents.
- Scheduling and drafting automation Turn one piece of content into posts for each channel, schedule them and track results, with approval before anything goes out.
- Forecasting dashboards Forecast demand from your sales history and seasonality, and flag items to reorder before they run out.
- Feedback analysis Read every review, survey and ticket, group them by theme and sentiment, and show what customers keep asking for.
- Payroll automation Turn pay rules, attendance and leave into tested software so the monthly run becomes a review and payslips go out in one batch.
Industries
View all industries- Construction and facilities Job tracking, maintenance requests, inspections, quotes and proof-of-work photos for builders and facility teams.
- Retail Stock forecasting, sales dashboards, feedback analysis and store tools for retailers with shops and online sales.
- Logistics and transportation Driver apps, order and shipment tracking, document processing and integrations for logistics and delivery companies.
- Manufacturing Quality inspection, production dashboards, quoting tools, knowledge assistants and legacy system modernization for manufacturers.
- Property management Tenant portals, maintenance tracking, owner statements and inbox automation for property managers.
- Finance and accounting Client portals, document collection, invoice and receipt processing, and reporting for accounting firms and finance teams.
Case studies
View all case studies- Facility management platform Every request, inspection and cost for every building now lives in one place, with a clear owner and status.
- Payroll system for an IT services company Payroll is calculated from recorded inputs, reviewed once and sent as payslips in a single batch, with every change logged.
Guides and articles
View all guides and articles- How to measure the ROI of AI automation Measure the return on AI automation with a baseline, the right metrics and honest accounting of costs.
- How to automate reporting with AI and MCP Build reports that assemble themselves from your systems through MCP, with a written summary people can trust.
- AI automation vs traditional automation How rule-based automation and AI automation differ, where each fits and how to combine them.
- How to connect AI to your database safely Let staff ask questions of your data in plain English without risking production systems or sensitive records.
- How to build an AI workflow with MCP servers Plan, connect and test an AI workflow that uses MCP servers, from a single task to a reliable process.
- No-code vs custom development Where no-code tools shine, where they hit limits, and when custom software pays off.
AI models
View all ai models- Claude Haiku 4.5 Anthropic's fastest and lowest-cost Claude model, with near-frontier intelligence for high-volume and real-time work.
- Gemini 3.5 Flash-Lite Google's lowest-cost current Gemini model for high-throughput work such as sub-agent tasks and document parsing.
- GPT-6 Luna OpenAI's most efficient model for focused, high-volume tasks, with vision, tool calling and structured outputs at the lowest price level in the family.
- GPT-4o mini A compact, low-cost older OpenAI model for focused tasks, with vision, tool calling and structured outputs and a 128K token window.
- DeepSeek V4.1 Flash DeepSeek's default, best-value model: open weights under MIT, image input, tool calling, JSON output, optional thinking and a 1 million token window.
Glossary terms
View all glossary terms- Structured output Structured output is when an AI model returns its answer in a fixed format, such as JSON matching a schema, so software can use it reliably.
- Workflow automation Workflow automation uses software to move work through a series of steps, such as routing, approvals and notifications, based on rules and events.
- Automation Automation is using software to perform a task or process with little or no human effort each time it runs.
- AI agent An AI agent is software that uses a language model to plan steps, call tools and act toward a goal, instead of only answering one question.
- API An API, or application programming interface, is a defined way for one piece of software to request data or actions from another.
- API integration An API integration connects two or more systems through their APIs so data and actions flow between them automatically.
FAQ
Questions people ask us
Have a question that is not here? Ask us directly.
Yes. Google hosts it, through its Workspace developer preview program at review time.
Yes. It can update values and formulas.
Use Google Sheets version history.