広告掲載
MCP.so
ログイン

Spreadsheet MCP Server

@HosakaKeigo

リポジトリ

基本情報

カテゴリ

その他

トランスポート

stdio

作者

HosakaKeigo

Spreadsheet MCP Server について

概要はまだありません

#spreadsheet#mcp#server

Spreadsheet MCP Server の設定

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

{
  "mcpServers": {
    "spreadsheet-mcp-server": {
      "command": "npx",
      "args": [
        "@modelcontextprotocol/inspector",
        "node",
        "build/index.js"
      ]
    }
  }
}

Spreadsheet MCP Server のツール

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

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

上のボタンで一時的なサンドボックスでこのサーバーを実行し、ツール一覧を取得できます。

概要

What is Spreadsheet MCP Server?

It is a Model Context Protocol (MCP) server that provides access to Google Spreadsheet data, enabling LLMs to directly use spreadsheet information.

How to use Spreadsheet MCP Server?

Clone the repository, install dependencies with npm install, configure environment variables (GAS_WEB_APP_URL and GAS_API_KEY) in a .env file, then build with npm run build. Start the server standalone with npm start or integrate it with Claude for Desktop by editing claude_desktop_config.json. If environment variables are not set, the server runs in mock mode.

Key features of Spreadsheet MCP Server

  • Retrieve spreadsheet basic info (list of sheets)
  • Fetch specific sheet data formatted as markdown tables
  • Integrate with MCP clients such as Claude for Desktop
  • Mock mode when Google Apps Script credentials are missing
  • Avoids Google OAuth flow by using a Google Apps Script Web App

Use cases of Spreadsheet MCP Server

  • An LLM reading and analyzing data from a Google Sheet
  • Building an AI assistant that queries spreadsheet content
  • Automating reports by pulling sheet data into a chat interface
  • Testing spreadsheet access without real credentials (mock mode)

よくある質問

1

What runtime dependencies does Spreadsheet MCP Server require?

Node.js and npm are required. The project uses TypeScript and compiles to JavaScript.

2

How do I set up authentication for the server?

Set the environment variables `GAS_WEB_APP_URL` (the URL of your Google Apps Script Web App) and `GAS_API_KEY` (the API key for accessing that Web App). If not set, the server runs in mock mode.

3

Where does the spreadsheet data live?

Data remains in the user's Google Sheets. The server accesses it via a Google Apps Script Web App, without storing spreadsheets locally.

4

How do I change the transport or authentication method?

The server uses MCP over stdio by default. No other transports are mentioned. Authentication is handled via an API key passed to the GAS Web App; no alternative auth methods are documented.

5

Are there any known limits or restrictions?

The README notes that if environment variables are not set, the server will not access real Google Sheets and returns mock data. No other limits are stated.

コメント

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

Awesome Mlops

visenger

A curated list of references for MLOps

14.0K

Screenpipe

screenpipe

YC (S26) | Open Computer History | Continuously record your company computer work, map your workflows, help you find work worth automating, and power your agents' context

22.0K

Codelf

unbug

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

14.2K

Yuppsy

Yuppsy MCP: build and publish real estate websites from your AI assistant. Yuppsy lets your AI assistant create live websites for real estate agents and individual property listings. You don't need a designer or any code

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

広告掲載