Mcp Google Sheets

Name: Mcp Google Sheets
Author: xing5

@xing5

リポジトリ

Mcp Google Sheets について

This MCP server integrates with your Google Drive and Google Sheets, to enable creating and modifying spreadsheets.

#google #mcp #spreadsheet #mcp-server

基本情報

カテゴリ

ファイルとストレージ

ライセンス

MIT

ランタイム

python

トランスポート

stdio

公開者

xing5

設定

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

{
  "mcpServers": {
    "mcp-google-sheets": {
      "command": "uvx",
      "args": [
        "mcp-google-sheets@latest"
      ]
    }
  }
}

ツール

ツールは検出されませんでした

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

概要

What is mcp-google-sheets?

mcp-google-sheets is a Python-based MCP server that acts as a bridge between any MCP‑compatible client (like Claude Desktop) and the Google Sheets API. It enables AI‑driven automation and data manipulation on Google Spreadsheets through a defined set of tools.

How to use mcp-google-sheets?

Install uv, set the environment variables SERVICE_ACCOUNT_PATH and DRIVE_FOLDER_ID with your Google Cloud service‑account credentials, then run uvx mcp-google-sheets@latest. Configure your MCP client (e.g., Claude Desktop) to connect to the server, optionally using tool filtering with --include-tools or ENABLED_TOOLS to reduce context usage.

Key features of mcp-google-sheets

Seamless integration with Google Drive & Sheets APIs
19 comprehensive tools (CRUD, listing, batching, sharing, formatting)
Flexible authentication: Service Accounts, OAuth 2.0, or credential injection
Zero‑install deployment via uvx
AI‑ready for natural‑language spreadsheet interaction
Tool filtering to reduce context window consumption

Use cases of mcp-google-sheets

Automate spreadsheet creation, reading, and updating from an AI assistant
Manage multiple spreadsheets and sheets (list, search, copy, rename)
Batch update cells across multiple ranges in a single API call
Share spreadsheets and control access programmatically
Retrieve cell formulas and grid data for advanced analysis

FAQ from mcp-google-sheets

What tools does mcp-google-sheets provide?

It provides 19 tools including get_sheet_data, update_cells, list_spreadsheets, list_sheets, create_spreadsheet, batch_update_cells, add_rows, share_spreadsheet, and more. See the full list in the README.

Do I need a Google Cloud Platform setup?

Yes. You must configure Google Cloud credentials (service account recommended) and enable the Google Sheets and Drive APIs before running the server.

How can I reduce the context usage of the server?

Use tool filtering via the --include-tools command‑line argument or the ENABLED_TOOLS environment variable to enable only the tools you need. By default, all 19 tools are exposed (~13K tokens).

How do I authenticate with Google Sheets?

Authentication is done through environment variables. The recommended method is to set SERVICE_ACCOUNT_PATH pointing to a service‑account key JSON file and DRIVE_FOLDER_ID. Alternative methods include OAuth 2.0 and inline credential configuration via CREDENTIALS_CONFIG.

Where does the data live?

Data stays in your Google Drive and Sheets. The server acts only as a bridge; it does not store any spreadsheet data itself. All operations are performed through the official Google Sheets API.