Spreadsheet MCP Server

What is Spreadsheet MCP Server?

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

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 Google Spreadsheet data programmatically.
2. Integrating spreadsheet data into applications using LLMs.
3. Testing and developing applications that require spreadsheet data.

FAQ from Spreadsheet MCP Server?

• Can I use this server without Google Apps Script?

No, the server requires Google Apps Script for actual data access.

• Is there a mock mode?

Yes, if environment variables are not set, the server runs in mock mode and returns test data.

• How do I set up the environment variables?

You can set them in the .env file, including GAS_WEB_APP_URL and GAS_API_KEY.