google-sheets-mcp

## 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: ```bash 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 - [x] Get Sheet Data - [x] Update Cells - [x] Batch Update Cells - [x] Add Rows - [x] Add Columns - [x] List Sheets - [x] Copy Sheet - [x] Create Spreadsheet