Google Sheets
An MCP server that enables AI agents to read, create, and modify Google Spreadsheets through actions like editing cells and managing sheets. It features a specialized handoff protocol to synchronize tasks and state between different LLMs using a shar
What is Google Sheets?
Google Sheets is a Model Context Protocol (MCP) server that allows AI assistants like Claude, Cursor, and VS Code to mcp server that enables ai agents to read, create, and modify google spreadsheets through actions like editing cells and managing sheets. it features a specialized handoff protocol to synchronize task...
An MCP server that enables AI agents to read, create, and modify Google Spreadsheets through actions like editing cells and managing sheets. It features a specialized handoff protocol to synchronize tasks and state between different LLMs using a shar
This server falls under the Cloud Services category on MCPgee, the world's largest MCP server directory with 33,000+ servers.
Features
- An MCP server that enables AI agents to read, create, and mo
Use Cases
Maintainer
Works with
Installation
Manual Installation
npx google-sheets-mcpConfiguration
Configuration Details
claude_desktop_config.json
Performance
Response Metrics
Resource Usage
How to Set Up and Use Google Sheets
Google Sheets MCP is a Node.js MCP server that gives AI agents full read and write access to Google Spreadsheets, exposing 15 operations for creating, reading, and modifying spreadsheets, sheets, rows, columns, and individual cells. It also features a specialized handoff protocol for synchronizing task state between different AI sessions using a shared spreadsheet as persistent memory. Teams use it to let Claude build, populate, and update spreadsheets entirely through conversation — automating data entry, reporting pipelines, and multi-agent coordination tasks.
Prerequisites
- Node.js 18+ and npm installed
- A Google Cloud project with the Google Sheets API enabled
- OAuth 2.0 client credentials (Desktop app type) downloaded as gcp-oauth.keys.json
- An MCP-compatible client such as Claude Desktop or Claude Code
Clone the repository and install dependencies
Clone the google-sheets-mcp repository and install Node.js packages.
git clone https://github.com/mkummer225/google-sheets-mcp.git
cd google-sheets-mcp
npm installCreate Google Cloud OAuth credentials
In Google Cloud Console: enable the Google Sheets API, create an OAuth consent screen, then generate an OAuth client ID of type 'Desktop application'. Download the JSON credentials file.
Place credentials file
Copy the downloaded OAuth credentials JSON file into the dist folder as gcp-oauth.keys.json.
cp ~/Downloads/client_secret_*.json ./dist/gcp-oauth.keys.jsonBuild the project
Compile the TypeScript source to the dist directory.
npm run buildAdd the server to your MCP client configuration
Edit your Claude Desktop config to register the server, pointing args to the compiled index.js file.
{
"mcpServers": {
"google-sheets-mcp": {
"command": "node",
"args": ["/path/to/google-sheets-mcp/dist/index.js"]
}
}
}Authenticate on first use
When you first invoke a Google Sheets tool in Claude, the server will prompt you to authenticate via your browser. Complete the OAuth flow and credentials will be stored for future sessions. You can also trigger it manually with the refresh_auth tool.
Google Sheets Examples
Client configuration
Claude Desktop configuration for the Google Sheets MCP server.
{
"mcpServers": {
"google-sheets-mcp": {
"command": "node",
"args": ["/path/to/google-sheets-mcp/dist/index.js"]
}
}
}Prompts to try
Natural language prompts covering the 15 tools this server exposes.
- "Create a new Google Spreadsheet called 'Q4 Sales Report' and add a sheet named 'Summary'"
- "Read all data from sheet 'Sheet1' in spreadsheet ID 1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgVE2upms"
- "Insert a new row in 'Inventory' sheet with values: Product=Widget, Qty=150, Price=9.99"
- "Edit cell B3 in 'Budget' sheet to the value 45000"
- "List all sheets in my spreadsheet"
- "Read column A headings from the 'Customers' sheet"Troubleshooting Google Sheets
gcp-oauth.keys.json not found error on startup
Ensure you placed the OAuth credentials JSON file at dist/gcp-oauth.keys.json (not in the project root). The file must be named exactly gcp-oauth.keys.json. Re-run 'npm run build' after placing the file.
OAuth authorization fails or redirect URI mismatch
In Google Cloud Console, go to your OAuth client and add 'http://localhost:3000/oauth2callback' as an authorized redirect URI. Ensure no other process is using port 3000 when the authentication flow starts.
Permission denied when reading or writing a spreadsheet
The authenticated Google account must have at least Viewer (for reads) or Editor (for writes) access to the spreadsheet. Share the spreadsheet with your Google account, or ensure you authenticated with the correct account.
Frequently Asked Questions about Google Sheets
What is Google Sheets?
Google Sheets is a Model Context Protocol (MCP) server that mcp server that enables ai agents to read, create, and modify google spreadsheets through actions like editing cells and managing sheets. it features a specialized handoff protocol to synchronize tasks and state between different llms using a shar It connects AI assistants to external tools and data sources through a standardized interface.
How do I install Google Sheets?
Follow the installation instructions on the Google Sheets GitHub repository. Clone the repo, install dependencies, and add the server config to your AI client.
Which AI clients work with Google Sheets?
Google Sheets works with all major MCP-compatible AI clients including Claude Desktop, Claude Code, Cursor, VS Code (GitHub Copilot), Windsurf, and Cline.
Is Google Sheets free to use?
Yes, Google Sheets is open source and available under the MIT License license. You can use it freely in both personal and commercial projects.
Google Sheets Alternatives — Similar Cloud Services Servers
Looking for alternatives to Google Sheets? Here are other popular cloud services servers you can use with Claude, Cursor, and VS Code.
Open WebUI
★ 138.2kUser-friendly AI Interface (Supports Ollama, OpenAI API, ...)
Anything LLM
★ 60.4kThe all-in-one AI productivity accelerator. On device and privacy first with no annoying setup or configuration.
LocalAI
★ 46.4kLocalAI is the open-source AI engine. Run any model - LLMs, vision, voice, image, video - on any hardware. No GPU required.
Nacos
★ 33.0kan easy-to-use dynamic service discovery, configuration and service management platform for building AI cloud native applications.
Xiaozhi ESP32
★ 26.7k本项目为xiaozhi-esp32提供后端服务，帮助您快速搭建ESP32设备控制服务器。Backend service for xiaozhi-esp32, helps you quickly build an ESP32 device control server.
Gateway
★ 11.8kA blazing fast AI Gateway with integrated guardrails. Route to 1,600+ LLMs, 50+ AI Guardrails with 1 fast & friendly API.
Browse More Cloud Services MCP Servers
Explore all cloud services servers available in the MCPgee directory. Each server includes setup guides for Claude, Cursor, and VS Code.
Set Up Google Sheets in Your Editor
Choose your AI client for step-by-step setup instructions.
Quick Config Preview
Add this to your claude_desktop_config.json or .cursor/mcp.json
Ready to use Google Sheets?
Browse our complete directory of 33,000+ MCP servers, read setup guides for your editor, and start building with the Model Context Protocol.