Spreadsheet MCP Server

@Ryo-Muramatsu

リポジトリ

基本情報

カテゴリ

その他

トランスポート

stdio

作者

Ryo-Muramatsu

Spreadsheet MCP Server について

概要はまだありません

#mcp-server #spreadsheet #mcp

Spreadsheet MCP Server の設定

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

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

Spreadsheet MCP Server のツール

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

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

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

概要

What is Spreadsheet MCP Server?

Spreadsheet MCP Server is a Model Context Protocol (MCP) server that provides LLMs with direct access to Google Spreadsheet data. It retrieves spreadsheet information and sheet data, formatting the output as markdown for use by MCP clients such as Claude for Desktop.

How to use Spreadsheet MCP Server?

Clone the repository, install dependencies with npm install, copy .env.example to .env, set GAS_WEB_APP_URL and GAS_API_KEY, then run npm run build and npm start. For integration with Claude for Desktop, add the server configuration to claude_desktop_config.json.

Key features of Spreadsheet MCP Server

Retrieves spreadsheet basic info and sheet list
Fetches specific sheet data as markdown tables
Integrates with MCP clients like Claude for Desktop
Operates in mock mode when environment variables are unset

Use cases of Spreadsheet MCP Server

Let an LLM browse sheet names and structure in a spreadsheet
Provide an LLM with formatted data from a specific sheet for analysis
Enable conversational querying of spreadsheet contents via Claude for Desktop

よくある質問

How does data access and authentication work?

The server connects to a Google Apps Script Web App using a URL and API key set in environment variables. This avoids a full Google OAuth flow while maintaining spreadsheet security.

What happens if I don't set the environment variables?

If `GAS_WEB_APP_URL` and `GAS_API_KEY` are not configured, the server runs in mock mode and returns test data instead of real spreadsheet content.

What tools does the server provide?

It provides two tools: `getSpreadsheet` (returns spreadsheet name, ID, and sheet list with row/column counts) and `getSheetData` (returns the contents of a specific sheet as a markdown table).

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

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