
Google-Sheets-MCP
3 years
Works with Finder
0
Github Watches
0
Github Forks
0
Github Stars
Google Sheets MCP, in Rust.
An MCP server for interacting with Google Sheets using whatever client (that can use MCP) you want.
How to use
Pre-requisites
To use this MCP server, you need the following:
- Google Cloud Project with a created service account (as well as Drive & Sheets APIs)
- The credentials file
- Google Drive folder that your service account has Editor access to
Usage
To use this MCP server, do the following:
- Clone this repo:
cargo add https://github.com/joshua-mo-143/google-sheets-mcp.git
cd google-sheets-mcp
- Add your Google Drive folder ID and service account credentials relative filepath (to the project root folder) as environment variables:
export DRIVE_FOLDER_ID=<drive_folder_id>
export SVC_ACC_PATH=<service_account_creds_file_location>
- Use
cargo run
!
Note that you can also additionally use cargo run --transport stdio
to run this server as stdio
.
Features
- Get Sheet Data
- Update Cells
- Batch Update Cells
- Add Rows
- Add Columns
- List Sheets
- Copy Sheet
- Create Spreadsheet
相关推荐
😎简单易用、🧩丰富生态 -大模型原生即时通信机器人平台| 适配QQ / 微信(企业微信、个人微信) /飞书 /钉钉 / discord / telegram / slack等平台| 支持chatgpt,deepseek,dify,claude,基于LLM的即时消息机器人平台,支持Discord,Telegram,微信,Lark,Dingtalk,QQ,Slack
Reviews

user_hFRgRNBY
I've been using google-sheets-mcp by joshua-mo-143 and it's fantastic! It seamlessly integrates with Google Sheets, enhancing my productivity and workflow. The interface is intuitive, making it easy to manage and manipulate data efficiently. Highly recommend it for anyone looking to streamline their spreadsheet tasks!

user_iivkDlcH
Google-sheets-mcp has significantly streamlined my workflow. As an avid user of Joshua Mo's tools, I appreciate the seamless integration and enhanced functionalities this plugin offers. It's user-friendly and boosts productivity, making data management in Google Sheets effortless. Highly recommend!