广告合作
MCP.so
登录

MCP Google Sheets Server

@freema

代码仓库

基本信息

分类

其他

许可证

MIT license

传输方式

stdio

作者

freema

关于 MCP Google Sheets Server

MCP server for Google Sheets - Read, write and manipulate spreadsheets through Claude Desktop

#nodejs#automation#typescript#mcp#google-sheets-api

MCP Google Sheets Server 配置

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

{
  "mcpServers": {
    "mcp-gsheets": {
      "command": "node",
      "args": [
        "/absolute/path/to/mcp-gsheets/dist/index.js"
      ],
      "env": {
        "GOOGLE_PROJECT_ID": "",
        "GOOGLE_APPLICATION_CREDENTIALS": ""
      }
    }
  }
}

MCP Google Sheets Server 工具

工具列表暂未提供

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

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

概览

What is MCP Google Sheets Server?

MCP Google Sheets Server is a Model Context Protocol (MCP) server that integrates the Google Sheets API directly into MCP clients such as Claude Desktop. It enables reading, writing, and managing Google Sheets documents programmatically. Designed for developers and users who need to control spreadsheets via natural language or automation in an MCP environment.

How to use MCP Google Sheets Server?

Requires Node.js 18+, a Google Cloud project with the Sheets API enabled, and a service account JSON key. Install via git clone, then run npm install and npm run build. Use the interactive setup script (npm run setup) or manually configure your MCP client (e.g., Claude Desktop) by adding the server configuration with absolute paths to the built script and environment variables for GOOGLE_PROJECT_ID and GOOGLE_APPLICATION_CREDENTIALS. After configuration, restart your MCP client.

Key features of MCP Google Sheets Server

  • Read cell values, ranges, and metadata from spreadsheets
  • Write, update, append, and clear cell data
  • Add, delete, duplicate, and copy sheets
  • Format cells with colors, fonts, alignment, and borders
  • Merge and unmerge cells; add conditional formatting rules

Use cases of MCP Google Sheets Server

  • Automatically populate a spreadsheet from chat prompts
  • Read and summarize spreadsheet data in natural language
  • Manage sheet structure (add/delete sheets) from an MCP client
  • Apply consistent formatting across multiple ranges
  • Check permissions before performing operations

常见问题

1

What are the prerequisites?

Node.js v18 or higher, a Google Cloud project with the Sheets API enabled, and a service account JSON key file.

2

How do I authenticate with Google Sheets?

Create a service account in Google Cloud Console, download its JSON key, and share your spreadsheet with the service account email (Editor permissions). Set the `GOOGLE_APPLICATION_CREDENTIALS` environment variable to the absolute path of that key.

3

How do I find a spreadsheet ID?

The spreadsheet ID is the long string in the sheet’s URL: `https://docs.google.com/spreadsheets/d/[SPREADSHEET_ID]/edit`.

4

What tools does MCP Google Sheets Server provide?

It offers tools for reading data (`sheets_get_values`, `sheets_batch_get_values`, `sheets_get_metadata`, `sheets_check_access`), writing data (`sheets_update_values`, `sheets_batch_update_values`, `sheets_append_values`, `sheets_clear_values`), sheet management (`sheets_insert_sheet`, `sheets_delete_sheet`, `sheets_duplicate_sheet`, `sheets_copy_to`, `sheets_update_sheet_properties`), and cell formatting (`sheets_format_cells`, `sheets_update_borders`, `sheets_merge_cells`, `sheets_unmerge_cells`, `sheets_add_conditional_formatting`).

5

How can I debug connection issues?

Ensure you are using the built version (`dist/index.js`), that the Node.js path in your MCP client config is correct, and check the client logs. You can also run `npm run inspector` to debug the MCP server.

评论

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

DeepMark

DeepMark helps teachers deliver rapid, consistent marking with meaningful feedback for every student — in a fraction of the time. What once took a week, now takes one free period.

YOUB

Connect your AI assistant to your own YOUB endurance training account. Read recorded activities with full analysis, planned sessions, race goals, wellness (HRV, sleep, resting HR) and your athletic profile. Create or mov

Volley.sh

Volley

A good sequence diagram can solve almost any communication problem in engineering. Volley lets your agent write them as plain text, with the real request and response payloads on every arrow. It checks its own syntax wi

The Living Bread

The Living Bread

A free remote MCP server for The Living Bread. Bible passages read word for word from a stored public domain text with an evidence label, keyword search and cross references, real churches, gatherings and prayer groups w

Senso MCP for Joomla

sensomedia

Senso MCP turns a Joomla 5 or 6 site into a remote MCP server. It runs inside Joomla itself (no extra server, no Node.js bridge) and is secured with OAuth 2.1 and Joomla's own ACL. The free pack lets an AI assistant crea

广告合作