广告合作
MCP.so
登录

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

常见问题

1

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.

2

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.

3

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).

评论

其他 分类下的更多 MCP 服务器

Soar Flight Booking MCP

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

FastMCP v2 🚀

jlowin

🚀 The fast, Pythonic way to build MCP servers and clients.

26.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

Health by Dr Brad

Dr Brad Stanfield

Health by Dr Brad works out a health plan from your own results: which screening is due at your age, and evidence-based suggestions, each with the reason and the published guideline or study behind it. Your record is one

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.

广告合作