Skip to main content
Glama

Google Sheets MCP

by mkummer225

Google 表格 MCP

Google Sheets 的模型上下文协议 (MCP) 连接器允许 AI 代理直接与电子表格交互。

演示

https://github.com/user-attachments/assets/cc4729d9-4e6e-437b-848b-6da9a09418c3

设置

  1. 克隆此存储库:
git clone https://github.com/mkummer225/google-sheets-mcp cd google-sheets-mcp
  1. 安装依赖项: npm install
  2. 构建: npm run build
  3. 在 Google Cloud Platform 中创建 OAuth 凭据:
  4. 启动 MCP 服务器(必要时会自动提示您验证/重新验证您的 Google 帐户): npm run start

用法

示例配置:

{ "mcpServers": { "google-sheets-mcp": { "command": "node", "args": [ "/{path_to_dir}/google-sheets-mcp/dist/index.js" ] } } }

然后您应该能够简单地指定您的电子表格 ID 或让您的代理为您创建一个新的电子表格 ID。

可用操作

行动描述
refresh_auth凭据过期时重新验证您的 Google 帐户
list_sheets列出 Google 电子表格中的所有工作表/标签
create_sheet在 Google 电子表格中创建新的工作表/标签
create_spreadsheet创建新的 Google 电子表格
read_all_from_sheet读取指定工作表中的所有数据
read_headings读取工作表中的列标题
read_rows从工作表中读取特定行
read_columns读取工作表中的特定列
edit_cell编辑工作表中的单个单元格
edit_row编辑工作表中的整行
edit_column编辑工作表中的整列
insert_row在指定位置插入新行
insert_column在指定位置插入新列
rename_sheet重命名电子表格中的工作表/标签
rename_doc重命名 Google 电子表格

执照

麻省理工学院

-
security - not tested
-
license - not tested
-
quality - not tested

hybrid server

The server is able to function both locally and remotely, depending on the configuration or use case.

模型上下文协议 (MCP) 连接器允许 AI 代理直接与 Google 表格交互,从而能够通过自然语言创建、阅读和修改电子表格。

  1. 演示
    1. 设置
      1. 用法
        1. 可用操作
          1. 执照

            Related MCP Servers

            • -
              security
              F
              license
              -
              quality
              A demonstration project that uses Cloudflare Workers MCP to create custom AI tools that can be integrated with Claude, Cursor, and other AI assistants supporting the Model Context Protocol.
              Last updated -
              26
              TypeScript
            • -
              security
              F
              license
              -
              quality
              Implements the Model Context Protocol (MCP) to provide AI models with a standardized interface for connecting to external data sources and tools like file systems, databases, or APIs.
              Last updated -
              90
              Python
              • Apple
              • Linux
            • -
              security
              A
              license
              -
              quality
              A Model Context Protocol server that enables AI assistants like Claude to read from, append to, and format text in Google Documents programmatically.
              Last updated -
              24
              TypeScript
              MIT License
              • Linux
              • Apple
            • -
              security
              -
              license
              -
              quality
              An open-source implementation of the Model Context Protocol (MCP) that bridges AI agents with enterprise systems, enabling secure access to real-world data and capabilities.
              Last updated -
              1
              Python
              Apache 2.0

            View all related MCP servers

            MCP directory API

            We provide all the information about MCP servers via our MCP API.

            curl -X GET 'https://glama.ai/api/mcp/v1/servers/mkummer225/google-sheets-mcp'

            If you have feedback or need assistance with the MCP directory API, please join our Discord server