广告合作
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.

评论

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

EverArt

modelcontextprotocol

Model Context Protocol Servers

88.1K
P

PickFu MCP

PickFu MCP is a Model Context Protocol (MCP) server that connects AI assistants, developers, marketers, product managers, and AI agents to PickFu's consumer research platform. It enables users to create surveys, conduct

Soar Flight Booking MCP

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

Reactive Resume

amruthpillai

A one-of-a-kind resume builder that keeps your privacy in mind. Completely secure, customizable, portable, open-source and free forever. Try it out today!

39.5K

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.

广告合作