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
相关推荐
Reviews
5
(2)
user_hFRgRNBY
2025-04-24
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
2025-04-24
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!