HosakaKeigo_spreadsheet-mcp-server
If you are the rightful owner of HosakaKeigo_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, making it easier to retrieve and format information in a structured manner. The server integrates with MCP clients like Claude for Desktop, providing a robust solution for accessing and manipulating spreadsheet data. The server is built using Node.js and requires specific environment variables for configuration, including the Google Apps Script Web App URL and API key. It supports both standalone operation and integration with other platforms, offering flexibility in deployment and usage. The server also includes tools for retrieving spreadsheet metadata and specific sheet data, formatted in markdown for easy readability.
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.
- Support for Google Apps Script Web App integration.
Tools
getSpreadsheet
Retrieves basic spreadsheet information and sheet list.
getSheetData
Fetches data from a specific sheet in markdown table format.
