MCP.so
登录

Mcp Google Sheets

@xing5

代码仓库

关于 Mcp Google Sheets

This MCP server integrates with your Google Drive and Google Sheets, to enable creating and modifying spreadsheets.

#google#mcp#spreadsheet#mcp-server

基本信息

分类

文件与存储

许可证

MIT

运行时

python

传输方式

stdio

发布者

xing5

配置

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

{
  "mcpServers": {
    "mcp-google-sheets": {
      "command": "uvx",
      "args": [
        "mcp-google-sheets@latest"
      ]
    }
  }
}

工具

未检测到工具

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

概览

What is mcp-google-sheets?

mcp-google-sheets is a Python-based MCP server that acts as a bridge between any MCP‑compatible client (like Claude Desktop) and the Google Sheets API. It enables AI‑driven automation and data manipulation on Google Spreadsheets through a defined set of tools.

How to use mcp-google-sheets?

Install uv, set the environment variables SERVICE_ACCOUNT_PATH and DRIVE_FOLDER_ID with your Google Cloud service‑account credentials, then run uvx mcp-google-sheets@latest. Configure your MCP client (e.g., Claude Desktop) to connect to the server, optionally using tool filtering with --include-tools or ENABLED_TOOLS to reduce context usage.

Key features of mcp-google-sheets

  • Seamless integration with Google Drive & Sheets APIs
  • 19 comprehensive tools (CRUD, listing, batching, sharing, formatting)
  • Flexible authentication: Service Accounts, OAuth 2.0, or credential injection
  • Zero‑install deployment via uvx
  • AI‑ready for natural‑language spreadsheet interaction
  • Tool filtering to reduce context window consumption

Use cases of mcp-google-sheets

  • Automate spreadsheet creation, reading, and updating from an AI assistant
  • Manage multiple spreadsheets and sheets (list, search, copy, rename)
  • Batch update cells across multiple ranges in a single API call
  • Share spreadsheets and control access programmatically
  • Retrieve cell formulas and grid data for advanced analysis

FAQ from mcp-google-sheets

What tools does mcp-google-sheets provide?

It provides 19 tools including get_sheet_data, update_cells, list_spreadsheets, list_sheets, create_spreadsheet, batch_update_cells, add_rows, share_spreadsheet, and more. See the full list in the README.

Do I need a Google Cloud Platform setup?

Yes. You must configure Google Cloud credentials (service account recommended) and enable the Google Sheets and Drive APIs before running the server.

How can I reduce the context usage of the server?

Use tool filtering via the --include-tools command‑line argument or the ENABLED_TOOLS environment variable to enable only the tools you need. By default, all 19 tools are exposed (~13K tokens).

How do I authenticate with Google Sheets?

Authentication is done through environment variables. The recommended method is to set SERVICE_ACCOUNT_PATH pointing to a service‑account key JSON file and DRIVE_FOLDER_ID. Alternative methods include OAuth 2.0 and inline credential configuration via CREDENTIALS_CONFIG.

Where does the data live?

Data stays in your Google Drive and Sheets. The server acts only as a bridge; it does not store any spreadsheet data itself. All operations are performed through the official Google Sheets API.

评论

文件与存储 分类下的更多 MCP 服务器

Filesystem MCP Server (@shtse8/filesystem-mcp)

shtse8

📁 Secure, efficient MCP filesystem server - token-saving batch operations with project root confinement

7

Rust MCP Filesystem

rust-mcp-stack

Blazing-fast, asynchronous MCP server for seamless filesystem operations.

163

Google Drive

modelcontextprotocol

Model Context Protocol Servers

88.1K

mcp-v8: V8 JavaScript MCP Server

r33drichards

MCP server that exposes a V8 JavaScript runtime as a tool for AI agents like Claude and Cursor. Supports persistent heap snapshots via S3 or local filesystem, and is ready for integration with modern AI development environments.

47

Sample S3 Model Context Protocol Server

aws-samples

78