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 分