H

Hosakakeigo Spreadsheet MCP Server

This project is an MCP server that connects to Google Sheets, allowing LLM to directly access and manipulate spreadsheet data. It provides functions for obtaining basic information, querying data, and formatting, and supports integration with MCP clients such as Claude.
2 points
6

What is Spreadsheet MCP Server?

This is a bridge service that enables AI assistants (such as Claude) to securely read Google Sheets data. Through the standardized MCP protocol, AI can obtain the table structure information and specific content and present it in an easy-to-read format.

How to use this service?

You can directly integrate it through the Claude desktop client or run it separately using the command-line tool. The service will automatically convert the table data into an AI-friendly format.

Use cases

Suitable for scenarios where AI is required to analyze spreadsheet data, such as structured data processing tasks like financial data analysis, customer list processing, and project progress tracking.

Main features

Get spreadsheet metadataObtain the basic information of the spreadsheet, including the list of worksheets it contains and their number of rows and columns
Query worksheet dataRead the complete content of the specified worksheet and automatically convert it into an easy-to-read Markdown table format
MCP protocol compatibilitySupport seamless integration with AI clients that follow the Model Context Protocol, such as Claude

Advantages and limitations

Advantages
Allow AI to access table data without complex configuration
Ensure data security through the Google Apps Script middle layer
Automatically format the output to improve AI processing efficiency
Limitations
Currently only supports read operations, not write operations
Requires pre-deployment of the Google Apps Script service
Large tables may have performance limitations

How to use

Environment preparation
Install the Node.js runtime environment (version 16+) and clone the code repository
Configure the connection
Set your Google Apps Script Web App address and API key in the.env file
Start the service
Run the service and keep the terminal window open
Client integration
Add the MCP server settings to the Claude client configuration file (see the documentation for details)

Usage examples

Sales data analysisLet the AI assistant analyze the trends in the quarterly sales report
Customer list processingExtract key information from the customer list

Frequently Asked Questions

What permissions are required to use this service?
How is the data security ensured?
What size of spreadsheet files are supported?

Related resources

Google Apps Script documentation
Official development documentation
MCP protocol specification
Technical specification of the Model Context Protocol
Example deployment video tutorial
Step-by-step configuration guide
Installation
Copy the following command to your Client for configuration
{
  "mcpServers": {
    "spreadsheet": {
      "command": "node",
      "args": ["<absolute-path-to-project>/build/index.js"]
    }
  }
}

{
  "mcpServers": {
    "spreadsheet": {
      "command": "node",
      "args": ["<absolute-path-to-project>/build/index.js"],
      "env": {
        "GAS_WEB_APP_URL": "https://script.google.com/macros/s/your-deployment-id/exec",
        "GAS_API_KEY": "your-api-key"
      }
    }
  }
}
Note: Your key is sensitive information, do not share it with anyone.
Featured MCP Services
D
Duckduckgo MCP Server
Certified
The DuckDuckGo Search MCP Server provides web search and content scraping services for LLMs such as Claude.
Python
827
4.3 points
G
Gitlab MCP Server
Certified
The GitLab MCP server is a project based on the Model Context Protocol that provides a comprehensive toolset for interacting with GitLab accounts, including code review, merge request management, CI/CD configuration, and other functions.
TypeScript
85
4.3 points
M
Markdownify MCP
Markdownify is a multi-functional file conversion service that supports converting multiple formats such as PDFs, images, audio, and web page content into Markdown format.
TypeScript
1.7K
5 points
N
Notion Api MCP
Certified
A Python-based MCP Server that provides advanced to-do list management and content organization functions through the Notion API, enabling seamless integration between AI models and Notion.
Python
140
4.5 points
U
Unity
Certified
UnityMCP is a Unity editor plugin that implements the Model Context Protocol (MCP), providing seamless integration between Unity and AI assistants, including real - time state monitoring, remote command execution, and log functions.
C#
563
5 points
F
Figma Context MCP
Framelink Figma MCP Server is a server that provides access to Figma design data for AI programming tools (such as Cursor). By simplifying the Figma API response, it helps AI more accurately achieve one - click conversion from design to code.
TypeScript
6.7K
4.5 points
M
Minimax MCP Server
The MiniMax Model Context Protocol (MCP) is an official server that supports interaction with powerful text-to-speech, video/image generation APIs, and is suitable for various client tools such as Claude Desktop and Cursor.
Python
752
4.8 points
G
Gmail MCP Server
A Gmail automatic authentication MCP server designed for Claude Desktop, supporting Gmail management through natural language interaction, including complete functions such as sending emails, label management, and batch operations.
TypeScript
282
4.5 points
AIbase
Zhiqi Future, Your AI Solution Think Tank
© 2025AIbase