Google-Sheet Universal MCP Server
Provides tools for interacting with Google Sheets, enabling AI agents to create, read, update, and manage spreadsheet data programmatically.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@Google-Sheet Universal MCP ServerCreate a new spreadsheet named 'Team Tasks'"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
Google-Sheet Universal MCP Server
This repository contains an implementation of an Google-Sheet Universal MCP (Model Context Protocol) server. It provides a standardized interface for interacting with Google-Sheet's tools and services through a unified API.
The server is built using the Universal MCP framework.
This implementation follows the MCP specification, ensuring compatibility with other MCP-compliant services and tools.
Usage
You can start using Google-Sheet directly from agentr.dev. Visit agentr.dev/apps and enable Google-Sheet.
If you have not used universal mcp before follow the setup instructions at agentr.dev/quickstart
Related MCP server: Google-Drive Universal MCP Server
Available Tools
The full list of available tools is at ./src/universal_mcp_google_sheet/README.md
Local Development
š Prerequisites
Ensure you have the following before you begin:
Python 3.11+ (recommended)
uv (install globally with
pip install uv)
š ļø Setup Instructions
Follow the steps below to set up your development environment:
Sync Project Dependencies
uv syncThis installs all dependencies from
pyproject.tomlinto a local virtual environment (.venv).Activate the Virtual Environment
For Linux/macOS:
source .venv/bin/activateFor Windows (PowerShell):
.venv\Scripts\ActivateStart the MCP Inspector
mcp dev src/universal_mcp_google_sheet/server.pyThis will start the MCP inspector. Make note of the address and port shown in the console output.
Install the Application
mcp install src/universal_mcp_google_sheet/server.py
š Project Structure
.
āāā src/
ā āāā universal_mcp_google_sheet/
ā āāā __init__.py # Package initializer
ā āāā server.py # Server entry point
ā āāā app.py # Application tools
ā āāā README.md # List of application tools
āāā tests/ # Test suite
āāā .env # Environment variables for local development
āāā pyproject.toml # Project configuration
āāā README.md # This fileš License
This project is licensed under the MIT License.
Generated with MCP CLI ā Happy coding! š
This server cannot be deployed
Maintenance
Related MCP Connectors
Connect AI assistants to Google Sheets through controlled tools for reading and updating rows.
Query your Google Sheets as structured JSON: list sheets and tabs, read schemas, filter rows.
Create and manage documents, spreadsheets, and presentations from your AI assistant.
Provides tools for searching Google Workspace documentation and much more.
Related MCP Servers
- AlicenseNot gradedqualityDmaintenanceProvides a standardized interface for interacting with Google-Gemini's tools and services through a unified API.MIT
- AlicenseNot gradedqualityDmaintenanceProvides a standardized interface for interacting with Google Drive tools and services through a unified API.MIT
- AlicenseNot gradedqualityDmaintenanceProvides unified access to Google Workspace APIs including Gmail, Drive, Sheets, Calendar, Docs, Forms, and Chat through a single interface, enabling email management, file operations, spreadsheet editing, event scheduling, and more via natural language.MIT
- AlicenseNot gradedqualityDmaintenanceEnables AI assistants to interact with Google Sheets via natural language, supporting CRUD operations, listing, sharing, and batch updates.MIT