Skip to main content
Glama
enesjakozh

Google Sheets MCP

by mkummer225
GitHub
JavaScript
MIT License
81
OverviewInspectNewSchemaRelated ServersReviewsScore
Need Help?View Source CodeReport Issue

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 电子表格

执照

麻省理工学院

This server cannot be installed

-
security - not tested
A
license - permissive license
-
quality - not tested

How are these scores calculated?

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

            • mcp-google

              Ejb503
              -
              security
              F
              license
              -
              quality
              A specialized Model Context Protocol (MCP) server that integrates Google services (Gmail, Calendar, etc.) into your AI workflows. This server enables seamless access to Google services through MCP, allowing AI agents to interact with Gmail, Google Calendar, and other Google services.
              Last updated -
              10
              3
              TypeScript

            • mcp-google-sheets

              xing5
              -
              security
              A
              license
              -
              quality
              A Model Context Protocol server that integrates with Google Drive and Google Sheets, enabling users to create, read, update, and manage spreadsheets through natural language commands.
              Last updated -
              295
              Python
              MIT License
              • Linux
              • Apple

            • Spreadsheet MCP Server

              HosakaKeigo
              A
              security
              F
              license
              A
              quality
              Provides a Model Context Protocol (MCP) server that enables LLMs to directly access and interact with Google Spreadsheet data.
              Last updated -
              2
              1
              TypeScript
              • Apple

            • MCP Google Workspace Server

              josedu90
              A
              security
              A
              license
              A
              quality
              A Model Context Protocol server that enables AI agents to interact with Google Workspace services including Drive, Docs, and Sheets through natural language commands.
              Last updated -
              8
              Python
              MIT License
              • Linux
              • Apple

            View all related MCP servers

            Appeared in Searches

            New 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