spreadsheet-mcp-server
If you are the rightful owner of spreadsheet-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
This project is a Model Context Protocol (MCP) server for accessing Google Spreadsheet data, allowing LLMs to directly utilize spreadsheet information.
The Spreadsheet MCP Server is designed to facilitate seamless access to Google Spreadsheet data through the Model Context Protocol (MCP). It enables Language Learning Models (LLMs) to directly interact with spreadsheet data, providing a structured way to retrieve and format spreadsheet information. The server supports integration with MCP clients like Claude for Desktop, allowing users to access and manipulate spreadsheet data efficiently. The server can be configured using environment variables to connect to a Google Apps Script Web App, which handles the actual data retrieval from Google Spreadsheets. This setup ensures secure access to spreadsheet data while maintaining ease of use and integration with existing MCP tools.
Features
- Retrieve basic spreadsheet information, including sheet lists.
- Fetch specific sheet data and format it in Markdown.
- Integrate with MCP clients like Claude for Desktop.
- Operate in mock mode if environment variables are not set.
- Secure access to Google Spreadsheets via Google Apps Script Web App.
Tools
getSpreadsheet
Retrieves basic spreadsheet information and a list of sheets.
getSheetData
Fetches data from a specific sheet in Markdown table format.
