🔗 Official Repository
github.com/xing5/mcp-google-sheetsAlways check the official repository for the latest setup instructions and license.
What is it?
A Model Context Protocol server for interacting with Google Sheets. This server provides tools to create, read, update, and manage spreadsheets through the Go — is a Model Context Protocol (MCP) server enabling AI applications like Claude and Cursor to securely access databases capabilities through the open protocol.
Why xing5/mcp-google-sheets?
mcp-google-sheets is a Python-based Model Context Protocol (MCP) server that connects AI clients like Claude Desktop to the Google Sheets API. It enables AI assistants to directly manipulate data and automate workflows inside Google Spreadsheets using defined toolsets. The server can be easily launched via uvx and authenticated using Google Cloud credentials.
Common Use Cases
- Connecting Claude Desktop and other MCP clients directly to Google Spreadsheets
- Automating data manipulation and updates within Google Sheets using AI workflows
- Managing Google Drive folder integration for spreadsheet file creation and organization
Quick Install (Claude Desktop)
{
"mcpServers": {
"mcp-google-sheets": {
"command": "npx",
"args": ["-y", "xing5/mcp-google-sheets"]
}
}
}Add to your Claude Desktop config file after installing requirements per the repo instructions.
Frequently Asked Questions
How do I run the mcp-google-sheets server?
Install uv, set your environment variables, and execute `uvx mcp-google-sheets@latest` in your terminal.
What authentication method is recommended?
Using a Google Cloud Service Account and setting the `SERVICE_ACCOUNT_PATH` environment variable is strongly recommended.
Which environment variables are required to get started?
You need to define `SERVICE_ACCOUNT_PATH` for authentication and `DRIVE_FOLDER_ID` for specifying the Google Drive folder.