Advertise
MCP.so
Sign In

Spreadsheet MCP Server

@Ryo-Muramatsu

Repository

Basic information

Category

Other

Transports

stdio

Author

Ryo-Muramatsu

About Spreadsheet MCP Server

No overview available yet

#mcp-server#spreadsheet#mcp

Spreadsheet MCP Server config

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

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

Spreadsheet MCP Server tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

Fetch the live tool list by running this server in a temporary sandbox using the button above.

Overview

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

Frequently asked questions

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

Comments

More Other MCP servers

Hindsight

vectorize-io

Hindsight: Agent Memory That Learns

50.4K

Activepieces

activepieces

AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents

23.2K

Volley.sh

Volley

A good sequence diagram can solve almost any communication problem in engineering. Volley lets your agent write them as plain text, with the real request and response payloads on every arrow. It checks its own syntax wi

MCP Toolbox for Databases

googleapis

MCP Toolbox for Databases is an open source MCP server for databases.

15.9K

Senso MCP for Joomla

sensomedia

Senso MCP turns a Joomla 5 or 6 site into a remote MCP server. It runs inside Joomla itself (no extra server, no Node.js bridge) and is secured with OAuth 2.1 and Joomla's own ACL. The free pack lets an AI assistant crea

Advertise