広告掲載
MCP.so
ログイン

Google Sheets MCP Server

@amaboh

リポジトリ

基本情報

カテゴリ

その他

ライセンス

MIT license

トランスポート

stdio

作者

amaboh

Google Sheets MCP Server について

A Model Context Protocol (MCP) server implementation for Google Sheets

Google Sheets MCP Server の設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

{
  "mcpServers": {
    "google-sheets-mcp-server": {
      "command": "python",
      "args": [
        "-m",
        "venv",
        ".venv"
      ]
    }
  }
}

Google Sheets MCP Server のツール

ツール一覧はまだありません

この掲載には表示できるツール一覧がまだありません。サーバーにツールがないという意味ではありません。対応機能はプロジェクトのドキュメントをご確認ください。

ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。

概要

What is Google Sheets MCP Server?

A Model Context Protocol (MCP) server that enables Claude Desktop to interact with Google Sheets directly. It provides tools for creating, reading, writing, and managing Google Sheets through Claude Desktop.

How to use Google Sheets MCP Server?

Install Python 3.10+, set up a virtual environment, install dependencies with uv, and configure Google Cloud OAuth 2.0 credentials. Then add the server to Claude Desktop’s claude_desktop_config.json with the path to the Python interpreter and the credentials file. Run the server manually once to complete browser-based OAuth authentication; the token is saved automatically. After setup, use commands like create_sheet, format_range, or write_formula directly in Claude Desktop.

Key features of Google Sheets MCP Server

  • Create new Google Sheets
  • Read and write data to existing sheets
  • Format cells and ranges
  • Add and delete sheets
  • Write formulas
  • Search for sheets
  • List available sheets

Use cases of Google Sheets MCP Server

  • Automate spreadsheet creation and data entry via conversation
  • Format ranges and apply formulas without leaving Claude Desktop
  • Manage multiple sheets (add/delete) through natural language
  • Quickly look up or list existing Google Sheets

よくある質問

1

What are the prerequisites?

Python 3.10 or higher, a Google Cloud Project with the Sheets API and Drive API enabled, OAuth 2.0 credentials, and the `uv` package manager. Claude Desktop is also required.

2

How do I set up OAuth authentication?

Download OAuth 2.0 credentials from the Google Cloud Console as a JSON file and save it to `~/.config/google_sheets_mcp/google-sheets-mcp.json`. The first server run will open a browser to authorize the application; the resulting token is saved automatically.

3

What tools/commands are available?

Tools include `create_sheet`, `format_range`, `write_formula`, `add_sheet`, `delete_sheet`, and `get_sheet_properties`.

4

How do I troubleshoot authentication issues?

Ensure the OAuth credentials file is valid, that your email is added as a test user in the Google Cloud project, and try deleting `token.json` and re‑authenticating.

5

What if the server won’t connect?

Check that the server is running, verify the credentials path in the Claude Desktop configuration, and review logs in Claude Desktop for error messages.

コメント

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

Blender

ahujasid

Open-source MCP to use Blender with any LLM

23.6K

Figs, Relationship Expert

Figs O'Sullivan, LMFT

Couples therapist Figs O'Sullivan (LMFT, 17 years, endorsed by Sue Johnson, creator of EFT) inside your AI. Ask relationship questions answered from his clinical writing, name the pattern in a fight, get a three-step rep

Codelf

unbug

A search tool helps dev to solve the naming things problem.

14.2K

Soar Flight Booking MCP

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

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

広告掲載