Spreadsheet MCP Server
by MCP-Mirror
This project is a Model Context Protocol (MCP) server designed to access data from Google Spreadsheets. It enables Large Language Models (LLMs) to directly utilize spreadsheet information.
Last updated: N/A
What is Spreadsheet MCP Server?
The Spreadsheet MCP Server is a tool that allows LLMs to interact with and retrieve data from Google Spreadsheets using the Model Context Protocol. It acts as a bridge between the LLM and the spreadsheet, providing structured access to the data.
How to use Spreadsheet MCP Server?
To use the server, you need to clone the repository, install dependencies, configure environment variables (GAS_WEB_APP_URL and GAS_API_KEY) to connect to your Google Apps Script Web App, build the project, and then run it. It can be integrated with Claude for Desktop by adding a configuration entry. You can also test it with the MCP Inspector.
Key features of Spreadsheet MCP Server
Retrieves basic spreadsheet information (e.g., sheet list)
Retrieves data from specific sheets and formats it as Markdown
Integrates with MCP clients like Claude for Desktop
Supports both standalone operation and integration with other applications
Includes mock mode for testing without accessing actual Google Spreadsheets
Use cases of Spreadsheet MCP Server
Enabling LLMs to answer questions based on spreadsheet data
Automating data analysis and reporting using LLMs
Building applications that require real-time access to spreadsheet information
Integrating spreadsheet data into conversational AI workflows
FAQ from Spreadsheet MCP Server
What is GAS_WEB_APP_URL?
What is GAS_WEB_APP_URL?
It's the URL of your Google Apps Script Web App that provides access to the spreadsheet data.
What is GAS_API_KEY?
What is GAS_API_KEY?
It's the API key used to authenticate access to your Google Apps Script Web App.
How do I set up the Google Apps Script Web App?
How do I set up the Google Apps Script Web App?
You need to create a Google Apps Script project, implement an API to access your spreadsheet data, and deploy it as a Web App. Refer to the api/README.md file for API specifications.
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 tool to test the server's functionality and ensure it's working correctly.