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.
- AnaellaOAuthcom.anaella
One API for your agent: email, calendars, Drive, Sheets, Slack, ads, analytics, social posts.
Google Sheets via Apify: write Apify datasets or JSON rows to a sheet, or read a sheet as JSON.
Query your Google Sheets as structured JSON: list sheets and tabs, read schemas, filter rows.
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