Cover image
Try Now
2025-04-14

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

相关推荐

  • av
  • 毫不费力地使用一个命令运行LLM后端,API,前端和服务。

  • 1Panel-dev
  • 🔥1Panel提供了直观的Web接口和MCP服务器,用于在Linux服务器上管理网站,文件,容器,数据库和LLMS。

  • WangRongsheng
  • 🧑‍🚀 llm 资料总结(数据处理、模型训练、模型部署、 o1 模型、mcp 、小语言模型、视觉语言模型)|摘要世界上最好的LLM资源。

  • Byaidu
  • PDF科学纸翻译带有保留格式的pdf -基于ai完整保留排版的pdf文档全文双语翻译

  • rulego
  • ⛓️Rulego是一种轻巧,高性能,嵌入式,下一代组件编排规则引擎框架。

  • sigoden
  • 使用普通的bash/javascript/python函数轻松创建LLM工具和代理。

  • hkr04
  • 轻巧的C ++ MCP(模型上下文协议)SDK

  • RockChinQ
  • 😎简单易用、🧩丰富生态 -大模型原生即时通信机器人平台| 适配QQ / 微信(企业微信、个人微信) /飞书 /钉钉 / discord / telegram / slack等平台| 支持chatgpt,deepseek,dify,claude,基于LLM的即时消息机器人平台,支持Discord,Telegram,微信,Lark,Dingtalk,QQ,Slack

  • dmayboroda
  • 带有可配置容器的本地对话抹布

  • paulwing
  • 使用MCP服务创建的测试存储库

    Reviews

    5 (2)
    Avatar
    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!

    Avatar
    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!