广告合作
MCP.so
登录

Google Sheets MCP Server

@amaboh

代码仓库

基本信息

分类

其他

许可证

MIT license

传输方式

stdio

作者

amaboh

关于 Google Sheets MCP Server

A Model Context Protocol (MCP) server implementation for Google Sheets

Google Sheets MCP Server 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "google-sheets-mcp-server": {
      "command": "python",
      "args": [
        "-m",
        "venv",
        ".venv"
      ]
    }
  }
}

Google Sheets MCP Server 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is Google Sheets MCP Server?

A Model Context Protocol (MCP) server that enables Claude Desktop to interact with Google Sheets directly. It provides tools for creating, reading, writing, and managing Google Sheets through Claude Desktop.

How to use Google Sheets MCP Server?

Install Python 3.10+, set up a virtual environment, install dependencies with uv, and configure Google Cloud OAuth 2.0 credentials. Then add the server to Claude Desktop’s claude_desktop_config.json with the path to the Python interpreter and the credentials file. Run the server manually once to complete browser-based OAuth authentication; the token is saved automatically. After setup, use commands like create_sheet, format_range, or write_formula directly in Claude Desktop.

Key features of Google Sheets MCP Server

  • Create new Google Sheets
  • Read and write data to existing sheets
  • Format cells and ranges
  • Add and delete sheets
  • Write formulas
  • Search for sheets
  • List available sheets

Use cases of Google Sheets MCP Server

  • Automate spreadsheet creation and data entry via conversation
  • Format ranges and apply formulas without leaving Claude Desktop
  • Manage multiple sheets (add/delete) through natural language
  • Quickly look up or list existing Google Sheets

常见问题

1

What are the prerequisites?

Python 3.10 or higher, a Google Cloud Project with the Sheets API and Drive API enabled, OAuth 2.0 credentials, and the `uv` package manager. Claude Desktop is also required.

2

How do I set up OAuth authentication?

Download OAuth 2.0 credentials from the Google Cloud Console as a JSON file and save it to `~/.config/google_sheets_mcp/google-sheets-mcp.json`. The first server run will open a browser to authorize the application; the resulting token is saved automatically.

3

What tools/commands are available?

Tools include `create_sheet`, `format_range`, `write_formula`, `add_sheet`, `delete_sheet`, and `get_sheet_properties`.

4

How do I troubleshoot authentication issues?

Ensure the OAuth credentials file is valid, that your email is added as a test user in the Google Cloud project, and try deleting `token.json` and re‑authenticating.

5

What if the server won’t connect?

Check that the server is running, verify the credentials path in the Claude Desktop configuration, and review logs in Claude Desktop for error messages.

评论

其他 分类下的更多 MCP 服务器

MCP Toolbox for Databases

googleapis

MCP Toolbox for Databases is an open source MCP server for databases.

15.9K

Lemon.io

lemon-io

Request dedicated senior developers to work on your project, write job descriptions, and prep technical interviews — all without leaving your Claude chat. Just describe what you need, and Lemon.io MCP does the rest. 1–3

Handl

Handl speaks the Model Context Protocol. Your whole billing operation — projects, invoices, clients, reports, approvals — as tools any AI assistant can call, inside your autonomy rules.

N

Next Generation Movers: free moving quotes (remote MCP)

Next Generation Movers

Free moving quotes for AI agents from Next Generation Movers, a licensed interstate mover (USDOT 3764697). US long-distance nationwide and local DC/MD/VA. Indicative ballpark price and booking options; optional $0.01 x40

🚀 Model Context Protocol (MCP) Curriculum for Beginners

microsoft

This open-source curriculum introduces the fundamentals of Model Context Protocol (MCP) through real-world, cross-language examples in .NET, Java, TypeScript, JavaScript, Rust and Python. Designed for developers, it focuses on practical techniques for building modular, scalable,

16.7K
广告合作