Spreadsheet MCP Server

@HosakaKeigo

About Spreadsheet MCP Server

No overview available yet

Config

Add this server to your MCP-compatible client using the configuration below.

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

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

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)

FAQ from Spreadsheet MCP Server

What runtime dependencies does Spreadsheet MCP Server require?

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

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.

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.

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.

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.

Frequently asked questions