Google Sheets Mcp
What is Google Sheets Mcp
google-sheets-mcp is an MCP server written in Rust that allows users to interact with Google Sheets using any compatible client.
Use cases
Use cases include automating data entry in spreadsheets, creating reports, managing project timelines, and integrating Google Sheets with other applications.
How to use
To use google-sheets-mcp, clone the repository, set up your Google Cloud Project with a service account, and configure the necessary environment variables for your Drive folder ID and service account credentials. Finally, run the server using ‘cargo run’.
Key features
Key features include getting sheet data, updating cells, batch updating cells, adding rows and columns, listing sheets, copying sheets, and creating spreadsheets.
Where to use
google-sheets-mcp can be used in various fields such as data analysis, project management, and any application that requires interaction with Google Sheets.
Clients Supporting MCP
The following are the main client software that supports the Model Context Protocol. Click the link to visit the official website for more information.
Overview
What is Google Sheets Mcp
google-sheets-mcp is an MCP server written in Rust that allows users to interact with Google Sheets using any compatible client.
Use cases
Use cases include automating data entry in spreadsheets, creating reports, managing project timelines, and integrating Google Sheets with other applications.
How to use
To use google-sheets-mcp, clone the repository, set up your Google Cloud Project with a service account, and configure the necessary environment variables for your Drive folder ID and service account credentials. Finally, run the server using ‘cargo run’.
Key features
Key features include getting sheet data, updating cells, batch updating cells, adding rows and columns, listing sheets, copying sheets, and creating spreadsheets.
Where to use
google-sheets-mcp can be used in various fields such as data analysis, project management, and any application that requires interaction with Google Sheets.
Clients Supporting MCP
The following are the main client software that supports the Model Context Protocol. Click the link to visit the official website for more information.
Content
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
- [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
Dev Tools Supporting MCP
The following are the main code editors that support the Model Context Protocol. Click the link to visit the official website for more information.
