广告合作
MCP.so
登录

Google Sheets MCP Server

@mkummer225

代码仓库

基本信息

分类

其他

许可证

MIT

传输方式

stdio

作者

mkummer225

提交者

Matt Kummer

关于 Google Sheets MCP Server

Google Sheets MCP Server 📊🤖

Google Sheets MCP Server 配置

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

{
  "mcpServers": {
    "google-sheets-mcp": {
      "command": "node",
      "args": [
        "/{path_to_dir}/google-sheets-mcp/dist/index.js"
      ]
    }
  }
}

Google Sheets MCP Server 工具

工具列表暂未提供

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

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

概览

What is Google Sheets Mcp?

Google Sheets Mcp is a Model Context Protocol (MCP) connector that enables AI agents to read, write, and manage Google Sheets spreadsheets directly through natural language or tool calls.

How to use Google Sheets Mcp?

Clone the repository, run npm install and npm run build, then place your Google OAuth credentials file (gcp-oauth.keys.json) in the dist directory. Start the server with npm run start and configure your MCP client with the sample JSON config pointing to the built index.js file. Specify a spreadsheetId or ask your agent to create a new spreadsheet.

Key features of Google Sheets Mcp

  • Authenticate using Google OAuth 2.0 with desktop credentials
  • List, create, and rename sheets and spreadsheets
  • Read all data, specific rows, or columns from a sheet
  • Edit individual cells, entire rows, or entire columns
  • Insert new rows or columns at specified positions
  • Refresh authentication when credentials expire

Use cases of Google Sheets Mcp

  • An AI assistant automatically populates a weekly report spreadsheet
  • A chatbot reads and updates a shared budget tracker
  • A productivity agent creates new project sheets and manages task lists
  • An automation pipeline inserts data rows into a live spreadsheet

常见问题

1

What does Google Sheets Mcp do?

It acts as a bridge between AI agents and Google Sheets, allowing agents to perform spreadsheet operations via the Model Context Protocol.

2

How do I authenticate with Google Sheets?

You must create OAuth 2.0 credentials in Google Cloud Platform, enable the Sheets API, and save the downloaded `gcp-oauth.keys.json` file in the `dist` directory. The server will prompt you to authenticate on first run.

3

What operations are available?

It supports reading/writing cells, rows, and columns; creating and renaming sheets and spreadsheets; inserting rows/columns; and listing sheet names. A full table of 14 actions is provided in the README.

4

What runtime dependencies does it require?

Node.js and npm are needed to install dependencies and build the project. The server runs locally and communicates over stdio via the MCP protocol.

评论

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

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.

EverArt

modelcontextprotocol

Model Context Protocol Servers

88.1K

Soar Flight Booking MCP

Soar Flight Booking MCP is a remote MCP server available at https://mcp.soar.flights.

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

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

广告合作