広告掲載
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.

コメント

「その他」の他のコンテンツ

Sequential Thinking

modelcontextprotocol

Model Context Protocol Servers

88.2K
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

Klarix Intelligence Engine

Klarix

B2B competitive intelligence, live sales battlecards, 5-axis ICP prospect fit scoring, and tech stack teardowns over MCP and REST with cited public-web evidence.

Soar Flight Booking MCP

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

広告掲載