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:

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