Gogcli Mcp Sheets

io.github.chrischall由 GitHub 账号 chrischall 发布v4.10.0更新于 Nov 7, 2026

Extended Google Sheets for Claude via gogcli — auth + full Sheets support

已验证STDIO仅桌面效率与工作流文件与存储数据与分析

概览

AI 生成的概览

通过 gogcli 命令行工具，让助手读取、编辑、格式化和管理 Google 表格，包括工作表标签、图表、表格和 Connected Sheets 数据源。

可以做什么
  • 读写单元格值，支持追加、清空、批量更新和区域查找替换
  • 管理标签与结构：新增、删除、重命名、复制、调整顺序标签，冻结、插入或删除行列，合并单元格
  • 设置格式：单元格与数字格式、行列尺寸、隔行变色、条件格式、数据验证、批注和超链接
  • 处理命名区域、Google 表格表格对象、嵌入式图表和基础筛选器
  • 查看和管理来自 BigQuery 或 Looker 的 Connected Sheets 数据源，包括刷新和限量读取
  • 将表格导出为 CSV、TSV、XLSX、PDF、ODS 或 HTML，并在高风险编辑前创建快照
适用场景
当助手需要直接在 Google 表格中操作而不只是读取数值时使用：搭建或重构表格、应用格式与数据验证、管理图表和表格对象，或刷新由 BigQuery 支持的 Connected Sheets 数据。
运行要求
以 npm 包形式在本机运行，需要 Node.js 22 或更高版本，并已安装 gogcli 且为目标 Google 账号完成认证。需设置 GOG_ACCOUNT 为账号邮箱，可选设置 GOG_PATH、DISPLAY_TZ 和 GOG_TIMEZONE。仅支持桌面客户端。
安装前请注意
许多工具会写入、重构或删除表格内容，包括删除标签、数据源、表格对象和图表；除非将 GOG_READONLY 设为 0、false、no 或 off，否则会阻止修改类请求。README 说明该代码库由 AI 开发，建议使用前审查代码和工具权限。它依赖你已有的 gogcli Google 认证。

安装

在 SourceWeft 中

  1. 打开 控制台中的 Gogcli Mcp Sheets，将其添加到工作区。
  2. 为需要使用其工具的对话启用该服务。

Desktop only，通过 STDIO。 STDIO 服务会启动本地进程，因此需要 SourceWeft 桌面宿主。

其他 MCP 客户端

参照 仓库 中的启动说明。

README

gogcli-mcp-sheets

[!WARNING] AI-developed project. This codebase was built and is actively maintained by Claude Code. Review all code and tool permissions before use.

Extended Google Sheets MCP server via gogcli. Includes auth tools plus 55 additional dedicated Sheets tools for tab management, formatting, named ranges, Connected Sheets, and more.

Requirements

  • gogcli installed and authenticated
  • Node.js 22+
bash
brew install gogcligog auth add [email protected] --services sheets

Installation

bash
npm install -g gogcli-mcp-sheets

Claude Desktop

Add to ~/Library/Application Support/Claude/claude_desktop_config.json:

json
{  "mcpServers": {    "gogcli-sheets": {      "command": "gogcli-mcp-sheets",      "env": {        "GOG_ACCOUNT": "[email protected]"      }    }  }}

Claude Code

bash
claude mcp add gogcli-sheets -- gogcli-mcp-sheets

Extra Sheets Tools (59)

Plus 8 auth tools and 8 base Sheets tools (get, update, append, clear, metadata, create, find-replace, run) — 75 in all.

ToolDescription
gog_sheets_add_tabAdd a new sheet tab
gog_sheets_delete_tabDelete a sheet tab
gog_sheets_rename_tabRename a sheet tab
gog_sheets_copyCopy a sheet to another spreadsheet
gog_sheets_exportExport as CSV, TSV, XLSX, PDF, ODS, or HTML
gog_sheets_freezeFreeze rows and/or columns
gog_sheets_insertInsert rows or columns
gog_sheets_mergeMerge cells
gog_sheets_unmergeUnmerge cells
gog_sheets_formatApply cell formatting (bold, color, etc.)
gog_sheets_number_formatSet number format (currency, percent, date, etc.)
gog_sheets_read_formatRead cell formatting
gog_sheets_resize_columnsResize column widths or auto-fit
gog_sheets_resize_rowsResize row heights or auto-fit
gog_sheets_named_ranges_listList named ranges
gog_sheets_named_ranges_getGet a named range by name or ID
gog_sheets_named_ranges_addCreate a named range
gog_sheets_named_ranges_updateUpdate a named range
gog_sheets_named_ranges_deleteDelete a named range
gog_sheets_notesRead cell notes
gog_sheets_update_noteAdd or update cell notes
gog_sheets_linksList hyperlinks in a range
gog_sheets_links_setSet =HYPERLINK() cells in one call (batch)
gog_sheets_snapshotBack up a whole spreadsheet before a risky edit
gog_sheets_datasource_listList Connected Sheets data sources (BigQuery / Looker) with sheet + execution status
gog_sheets_datasource_describeFull data-source spec, including its query, status and refresh schedules
gog_sheets_datasource_table_listList anchored data-source tables (extracts) and their A1 anchors
gog_sheets_datasource_table_describeDescribe the extract anchored at an A1 cell
gog_sheets_datasource_table_readRead a bounded number of rows out of an extract
gog_sheets_datasource_addAdd a BigQuery Connected Sheets data source (custom SQL or a native table)
gog_sheets_datasource_updateRepoint a data source's SQL, table or billing project
gog_sheets_datasource_refreshRe-run a data source so its sheet and extracts pick up current data
gog_sheets_datasource_deleteDelete a data source, its linked sheet, and unlink dependent objects
gog_sheets_list_tabsList tabs in a spreadsheet (sheetId, title, index, gridProperties)
gog_sheets_copy_pasteCopy a range's values/formulas/format to another range (tiles to fill down/across).
gog_sheets_validation_getRead data-validation rules (dropdowns, checkboxes, conditions) on a range.
gog_sheets_validation_setSet a data-validation rule on a range: dropdowns, checkboxes, number/date conditions, or custom formulas.
gog_sheets_validation_clearRemove all data-validation rules from a range.
gog_sheets_delete_dimensionDelete a row or column span, table-aware: intersecting tables are shrunk and their remaining data preserved.
gog_sheets_batch_updateUpdate values in multiple ranges atomically with one Sheets API request.
gog_sheets_reorder_tabMove a tab to a specific 0-based position.
gog_sheets_chart_listList embedded charts in a spreadsheet.
gog_sheets_chart_getGet a chart's full definition (spec + position) by chart ID.
gog_sheets_chart_createCreate an embedded chart from a JSON ChartSpec.
gog_sheets_chart_updateReplace a chart's spec by chart ID.
gog_sheets_chart_deleteDelete a chart by chart ID.
gog_sheets_table_listList Google Sheets tables in a spreadsheet.
gog_sheets_table_getGet a Google Sheets table by table ID.
gog_sheets_table_createCreate a Google Sheets table over a range with typed columns.
gog_sheets_table_appendAppend data rows to a table.
gog_sheets_table_clearClear all data rows from a table.
gog_sheets_table_deleteDelete a Google Sheets table. By default preserves the table's cell values and formulas (emulates "Convert to range"); set keep_data=false to also wipe the data.
gog_sheets_banding_listList alternating-color banded ranges.
gog_sheets_banding_setApply alternating colors to a range.
gog_sheets_banding_clearRemove alternating-color banding by ID or for a whole sheet.
gog_sheets_filter_setSet a basic filter on a range; replacing an existing filter requires replace=true.
gog_sheets_conditional_format_listList conditional formatting rules.
gog_sheets_conditional_format_addAdd a conditional formatting rule to a range (boolean or gradient).
gog_sheets_conditional_format_clearRemove conditional formatting rules from a sheet.

License

MIT

来源：packages/gogcli-mcp-sheets/README.md，提交 5ce766c

工具

0
SourceWeft 尚未在沙箱中启动过该软件包，因此其工具未知。

版本历史

22
  1. v4.10.0最新Nov 7, 2026
  2. v4.9.1Nov 5, 2026
  3. v4.8.1Oct 16, 2026
  4. v4.8.0Oct 12, 2026
  5. v4.7.1Oct 10, 2026
  6. v4.7.0Oct 7, 2026
  7. v4.6.3Oct 5, 2026
  8. v4.6.2Oct 5, 2026
  9. v4.6.1Oct 3, 2026
  10. v4.6.0Oct 2, 2026
  11. v4.5.2Sep 28, 2026
  12. v4.5.1Sep 25, 2026
  13. v4.5.0Sep 24, 2026
  14. v4.3.0Sep 23, 2026
  15. v4.2.5Sep 22, 2026
  16. v4.2.4Sep 21, 2026
  17. v4.2.3Sep 21, 2026
  18. v4.2.0Sep 20, 2026
  19. v4.1.0Sep 20, 2026
  20. v4.0.1Sep 18, 2026
  21. v3.0.0Sep 17, 2026
  22. v2.30.0Sep 16, 2026

评分

已满足适用检查项的 50%

该评分衡量此收录条目的完整程度，依据注册中心条目、端点与公开来源计算得出。它不是对服务器本身的评价，也不表示服务器安全或当前可用：可连通性是带日期的检查结果，评分也不包含安装量或用户评价。

  • 近 30 天内可连通25 分

    请保持端点能够响应 MCP 握手；SourceWeft 每 30 天探测一次。

  • 已声明认证方式10 分

    请在注册中心条目中声明凭据请求头，或保持端点能够响应探测，以便判定其认证方式。

  • 已列出工具15 分

    请让服务器在无凭据时响应 tools/list，或发布可在沙箱中无凭据启动的软件包。

  • 描述必需15 分
  • 图标10 分
  • 文档15 分
  • 许可证10 分