Spreadsheet MCP Server
by Ryo-Muramatsu
This project is a Model Context Protocol (MCP) server for accessing Google Spreadsheet data. It allows LLMs to directly utilize spreadsheet information.
Last updated: N/A
What is Spreadsheet MCP Server?
The Spreadsheet MCP Server is a server that provides an interface for Large Language Models (LLMs) to access and utilize data stored in Google Spreadsheets via the Model Context Protocol (MCP). It acts as a bridge between the LLM and the Google Spreadsheet, allowing the LLM to retrieve information and use it in its reasoning and generation processes.
How to use Spreadsheet MCP Server?
- Clone the repository.
- Install dependencies using
npm install. - Configure environment variables (
GAS_WEB_APP_URLandGAS_API_KEY) in a.envfile. - Build the project using
npm run build. - Start the server using
npm startor integrate it with Claude for Desktop by adding the server configuration toclaude_desktop_config.json.
Key features of Spreadsheet MCP Server
Retrieves basic spreadsheet information (sheet list, etc.).
Retrieves data from specific sheets and formats it as Markdown.
Integrates with MCP clients (e.g., Claude for Desktop).
Supports mock mode for testing without accessing real Google Spreadsheets.
Provides tools to get spreadsheet information and sheet data.
Use cases of Spreadsheet MCP Server
Enabling LLMs to answer questions based on data in Google Spreadsheets.
Generating reports or summaries from spreadsheet data using LLMs.
Automating tasks that require access to spreadsheet data.
Integrating spreadsheet data into LLM-powered applications.
FAQ from Spreadsheet MCP Server
What is GAS_WEB_APP_URL?
What is GAS_WEB_APP_URL?
The URL of your Google Apps Script Web App that accesses the spreadsheet.
What is GAS_API_KEY?
What is GAS_API_KEY?
The API key used to access your Google Apps Script Web App.
How do I set up a Google Apps Script Web App?
How do I set up a Google Apps Script Web App?
Create a new Google Apps Script project, implement an API to access your spreadsheet, and deploy it as a Web App. Refer to the Google Apps Script documentation for detailed instructions.
What happens if I don't set the environment variables?
What happens if I don't set the environment variables?
The server will run in mock mode and return test data instead of accessing a real Google Spreadsheet.
How do I test the server?
How do I test the server?
You can use the MCP Inspector with the command npx @modelcontextprotocol/inspector node build/index.js.