logo
Login
Cover image
google-sheets-mcp
Private

google-sheets-mcp

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

相关推荐

harbor

harbor

  • av

    • Effortlessly run LLM backends, APIs, frontends, and services with one command.

    2 (1)
    awesome-LLM-resourses

    awesome-LLM-resourses

  • WangRongsheng

    • 🧑‍🚀 全世界最好的LLM资料总结（Agent框架、辅助编程、数据处理、模型训练、模型推理、o1 模型、MCP、小语言模型、视觉语言模型） | Summary of the world's best LLM resources.

    3.5 (4)
    1Panel

    1Panel

  • 1Panel-dev

    • 🔥 1Panel provides an intuitive web interface and MCP Server to manage websites, files, containers, databases, and LLMs on a Linux server.

    2 (1)
    rulego

    rulego

  • rulego

    • ⛓️RuleGo is a lightweight, high-performance, embedded, next-generation component orchestration rule engine framework for Go.

    3.7 (10)
    mcp-gateway

    mcp-gateway

  • lasso-security

    • A plugin-based gateway that orchestrates other MCPs and allows developers to build upon it enterprise-grade agents.

    4.2 (5)
    PDFMathTranslate

    PDFMathTranslate

  • Byaidu

    • PDF scientific paper translation with preserved formats - 基于 AI 完整保留排版的 PDF 文档全文双语翻译，支持 Google/DeepL/Ollama/OpenAI 等服务，提供 CLI/GUI/MCP/Docker/Zotero

    2 (1)
    cpp-mcp

    cpp-mcp

  • hkr04

    • Lightweight C++ MCP (Model Context Protocol) SDK

    3 (1)
    llm-functions

    llm-functions

  • sigoden

    • Easily create LLM tools and agents using plain Bash/JavaScript/Python functions.

    1 (1)
    LangBot

    LangBot

  • RockChinQ

    • 😎简单易用、🧩丰富生态 - 大模型原生即时通信机器人平台 | 适配 QQ / 微信（企业微信、个人微信）/ 飞书 / 钉钉 / Discord / Telegram / Slack 等平台 | 支持 ChatGPT、DeepSeek、Dify、Claude、Gemini、xAI、PPIO、Ollama、LM Studio、阿里云百炼、火山方舟、SiliconFlow、Qwen、Moonshot、ChatGLM、SillyTraven、MCP 等 LLM 的机器人 / Agent | LLM-based instant messaging bots platform, supports Discord, Telegram, WeChat, Lark, DingTalk, QQ, Slack

    5 (1)
    agentscope

    agentscope

  • modelscope

    • Start building LLM-empowered multi-agent applications in an easier way.

    2 (1)

    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!