Spreadsheet MCP Server

What is Spreadsheet MCP Server?

Spreadsheet MCP Server is a Model Context Protocol (MCP) server that allows access to Google Spreadsheet data, enabling LLMs to utilize spreadsheet information directly.

How to use Spreadsheet MCP Server?

To use the server, clone the repository, install dependencies, set environment variables, and start the server. It can also be integrated with clients like Claude for Desktop.

Key features of Spreadsheet MCP Server?

• Retrieve basic information about spreadsheets (e.g., list of sheets).
• Fetch specific sheet data and format it in markdown.
• Integration with MCP clients like Claude for Desktop.

Use cases of Spreadsheet MCP Server?

1. Accessing and manipulating spreadsheet data programmatically.
2. Integrating spreadsheet functionalities into applications.
3. Facilitating data analysis and reporting through spreadsheets.

FAQ from Spreadsheet MCP Server?

• Can I use this server without Google Apps Script?

Yes, it can run in mock mode without actual Google Sheets access.

• What are the required environment variables?

You need to set GAS_WEB_APP_URL and GAS_API_KEY in the .env file.

• Is there a testing feature available?

Yes, you can test the server using the MCP Inspector.