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

コメント

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

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.

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

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

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

Blender

ahujasid

Open-source MCP to use Blender with any LLM

23.6K
広告掲載