Public
Google-Sheets-MCP
2025-04-08
Google Sheets MCP Server 📊🤖
1
Github Watches
5
Github Forks
31
Github Stars
Google Sheets MCP
A Model Context Protocol (MCP) connector for Google Sheets that allows AI agents to interact with spreadsheets directly.
Demo
https://github.com/user-attachments/assets/cc4729d9-4e6e-437b-848b-6da9a09418c3
Setup
- Clone this repository:
git clone https://github.com/mkummer225/google-sheets-mcp
cd google-sheets-mcp
-
Install dependencies:
npm install -
Build:
npm run build -
Create OAuth credentials in Google Cloud Platform:
- Create a new project in Google Cloud Console
- Enable the Google Sheets API
- Configure the OAuth consent screen
- Create OAuth client ID credentials (Desktop application) with an appropriate redirect URI (ex: http://localhost:3000/oauth2callback)
- Download the credentials and save as
gcp-oauth.keys.jsonin thedistsubdirectory
-
Start the MCP server (you'll automatically be prompted to authenticate/re-authenticate your Google account when necessary):
npm run start
Usage
Sample config:
{
"mcpServers": {
"google-sheets-mcp": {
"command": "node",
"args": [
"/{path_to_dir}/google-sheets-mcp/dist/index.js"
]
}
}
}
Then you should be able to simply specify your spreadsheetId or ask your agent to create a new one for you.
Available Actions
| Action | Description |
|---|---|
refresh_auth |
Re-authenticate your Google Account when credentials expire |
list_sheets |
List all sheets/tabs in a Google Spreadsheet |
create_sheet |
Create a new sheet/tab in a Google Spreadsheet |
create_spreadsheet |
Create a new Google Spreadsheet |
read_all_from_sheet |
Read all data from a specified sheet |
read_headings |
Read the column headings from a sheet |
read_rows |
Read specific rows from a sheet |
read_columns |
Read specific columns from a sheet |
edit_cell |
Edit a single cell in a sheet |
edit_row |
Edit an entire row in a sheet |
edit_column |
Edit an entire column in a sheet |
insert_row |
Insert a new row at specified position |
insert_column |
Insert a new column at specified position |
rename_sheet |
Rename a sheet/tab in a spreadsheet |
rename_doc |
Rename a Google Spreadsheet |
License
MIT
相关推荐
I find academic articles and books for research and literature reviews.
Confidential guide on numerology and astrology, based of GG33 Public information
Converts Figma frames into front-end code for various mobile frameworks.
Advanced software engineer GPT that excels through nailing the basics.
Take an adjectivised noun, and create images making it progressively more adjective!
Embark on a thrilling diplomatic quest across a galaxy on the brink of war. Navigate complex politics and alien cultures to forge peace and avert catastrophe in this immersive interstellar adventure.
Entdecken Sie die umfassendste und aktuellste Sammlung von MCP-Servern auf dem Markt. Dieses Repository dient als zentraler Hub und bietet einen umfangreichen Katalog von Open-Source- und Proprietary MCP-Servern mit Funktionen, Dokumentationslinks und Mitwirkenden.
Die All-in-One-Desktop & Docker-AI-Anwendung mit integriertem Lappen, AI-Agenten, No-Code-Agent Builder, MCP-Kompatibilität und vielem mehr.
Ein leistungsstarkes Neovim -Plugin für die Verwaltung von MCP -Servern (Modellkontextprotokoll)
MCP -Server für den Fetch -Webseiteninhalt mit dem Headless -Browser von Dramatikern.
Brücke zwischen Ollama und MCP -Servern und ermöglicht es lokalen LLMs, Modellkontextprotokoll -Tools zu verwenden
Fair-Code-Workflow-Automatisierungsplattform mit nativen KI-Funktionen. Kombinieren Sie visuelles Gebäude mit benutzerdefiniertem Code, SelbstHost oder Cloud, 400+ Integrationen.
🧑🚀 全世界最好的 llm 资料总结（数据处理、模型训练、模型部署、 O1 模型、 MCP 、小语言模型、视觉语言模型） | Zusammenfassung der weltbesten LLM -Ressourcen.
Reviews
4
(1)
user_14l8cjnF
2025-04-17
As a loyal user of the google-sheets-mcp, I find it incredibly efficient for managing and automating my Google Sheets tasks. It seamlessly integrates and enhances productivity with its intuitive design. Kudos to mkummer225 for developing such a valuable tool! Highly recommended for anyone looking to streamline their Google Sheets experience. Check it out here: https://github.com/mkummer225/google-sheets-mcp.