广告合作
MCP.so
登录

MCP Google Sheets Server

@shionhonda

代码仓库

基本信息

分类

其他

许可证

MIT license

传输方式

stdio

作者

shionhonda

关于 MCP Google Sheets Server

Model Context Protocol (MCP) server that allows interaction with Google Sheets

MCP Google Sheets Server 配置

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

{
  "mcpServers": {
    "mcp-gsheet": {
      "command": "uv",
      "args": [
        "venv"
      ]
    }
  }
}

MCP Google Sheets Server 工具

工具列表暂未提供

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

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

概览

What is MCP Google Sheets Server?

MCP Google Sheets Server is a Model Context Protocol (MCP) server that enables interaction with Google Sheets. It is intended for AI agents or tools that need to list sheets, read cell ranges, and write data to spreadsheets, but it does not manage Google Drive files.

How to use MCP Google Sheets Server?

Set the GOOGLE_APPLICATION_CREDENTIALS environment variable to the absolute path of your service account JSON key, clone the repository, create a Python 3.11+ virtual environment with uv, install dependencies, then run mcp dev server.py (development) or mcp run server.py (production). The server communicates over standard input/output (stdio).

Key features of MCP Google Sheets Server?

  • List all sheet names (tabs) in a spreadsheet.
  • Read data from a specific cell range.
  • Write a 2D list of values to a specific cell range.
  • No Google Drive file management capabilities.
  • Authenticates via service account key.
  • Runs over stdio – suitable for MCP clients like Claude Desktop.

Use cases of MCP Google Sheets Server?

  • Extract data from Google Sheets for analysis or reporting.
  • Auto-populate spreadsheet cells from AI agent responses.
  • List sheets/tabs to discover spreadsheet structure.
  • Update cell values based on user queries or external inputs.

常见问题

1

What tools does MCP Google Sheets Server provide?

It provides three tools: `list_sheets(spreadsheet_id)`, `read_cells(spreadsheet_id, range_name)`, and `write_cells(spreadsheet_id, range_name, values)`.

2

Can I manage Google Drive files (create/delete folders) with this server?

No. The server explicitly does **not** provide tools for managing Google Drive files. Access is restricted to spreadsheet content only.

3

What are the runtime requirements?

Python 3.11+, a Google Cloud Project with the Google Sheets API enabled, and a downloaded service account key file (JSON). Dependencies are managed via `uv`.

4

How do I authenticate?

Set the environment variable `GOOGLE_APPLICATION_CREDENTIALS` to the absolute path of your service account JSON key file. The service account must have the "Editor" role on the target Google Sheets.

5

How do I run the server?

Use `mcp dev server.py` for development with MCP Inspector, or `mcp run server.py` for production. For Claude Desktop, add a JSON configuration block pointing to `uv` and the server path.

评论

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

Hindsight

vectorize-io

Hindsight: Agent Memory That Learns

50.4K
P

PickFu MCP

PickFu MCP is a Model Context Protocol (MCP) server that connects AI assistants, developers, marketers, product managers, and AI agents to PickFu's consumer research platform. It enables users to create surveys, conduct

Sequential Thinking

modelcontextprotocol

Model Context Protocol Servers

88.2K

Maestro

mobile-dev-inc

Painless E2E Automation for Mobile and Web

14.8K

Glasswarp

Glasswarp

See and control a real Windows PC you own — from any MCP client, locally or remotely. Observe (UIA + screenshots), click/type/drag/scroll, launch apps, owner Live View. BYOH: your machine, your key.

广告合作