Google Sheets MCP by InsightfulPipe

com.insightfulpipe由 insightfulpipe.com 發布v1.0.0更新於 Nov 4, 2026

Hosted Google Sheets MCP server, with each action switched on or off per account.

已驗證Streamable HTTP可網頁執行效率與工作流資料與分析

概覽

AI 產生的概覽

託管的 Google Sheets MCP 伺服器，讓助理讀取、查詢、寫入與格式化試算表資料，並可依帳號逐項開關每個動作。

可以做什麼
  • 檢視試算表：預覽欄位與範例資料、列出工作表分頁與其詮釋資料、以類 SQL 的 SELECT 與 WHERE 查詢資料。
  • 寫入或覆寫儲存格值，包括一次批次更新多個範圍。
  • 新增、複製、重新命名、隱藏或刪除工作表分頁，並插入空白列。
  • 格式化範圍：粗體、色彩、字型、數字格式、對齊、框線、隔列底色、合併與自動調整大小。
  • 加入結構與控制項：命名範圍、受保護範圍、篩選檢視、基本篩選、交叉分析篩選器、資料驗證與排序。
  • 建立與移除內嵌圖表，例如長條圖、折線圖、圓餅圖、面積圖與散佈圖。
適用情境
適合需要助理直接操作線上 Google Sheets 資料的情境，例如彙整工作表與欄位標題、追加表單送出的資料列、製作圖表，或套用格式與驗證規則，而不必使用本機腳本或安裝套件。
執行需求
在用戶端（Claude 連接器、ChatGPT 開發人員模式、Claude Code 或 Cursor）加入遠端 MCP 端點。需以 OAuth 登入 InsightfulPipe，存取權限綁定付費的 InsightfulPipe 方案，並提供 7 天試用。
安裝前請注意
多數動作會寫入試算表：26 個動作中有 23 個會修改儲存格、分頁、格式、圖表或保護設定，部分動作會刪除圖表或分頁。破壞性動作預設關閉，需由管理員開啟；唯讀連線會把助理限制為唯讀動作。權限依已連線帳號授予，使用前請確認所用帳號及已啟用的動作。

安裝

在 SourceWeft 中

  1. 開啟 儀表板中的 Google Sheets MCP by InsightfulPipe，將其新增到工作區。
  2. 連接 所需的 憑證。它們會被私密儲存，絕不會在公開頁面上展示。
  3. 為需要使用其工具的對話啟用該服務。

Web executable，透過 Streamable HTTP。 遠端服務在工作區中設定後即可從網頁執行環境執行。

交給代理程式安裝

把這段提示詞貼上到 Claude Code、Codex、Cursor 等代理程式，或 SourceWeft 對話中。代理程式會讀取該伺服器的安裝指南，先向你展示發布者、端點和登入方式，經你同意後再把它新增到你的客戶端。金鑰不會寫進任何命令。

閱讀 https://sourceweft.com/mcp/com.insightfulpipe%2Fgoogle-sheets/install.md，並按其中說明把這個 MCP 伺服器接入我的客戶端。修改任何設定之前，先告訴我它的發布者、端點和登入方式，等我確認。不要把 API 金鑰寫進命令或我會提交的檔案；問我金鑰應從哪裡取得。

檢視代理程式所依據的安裝指南

其他 MCP 客戶端

把它新增到你客戶端的 mcpServers 設定中。 客戶端會在首次連接時完成 OAuth 登入。

{
  "mcpServers": {
    "google-sheets-by-insightfulpipe": {
      "type": "http",
      "url": "https://google-sheets.insightfulmcp.com/"
    }
  }
}

README

Google Sheets MCP Server by Insightful Pipe

[MCP Compatible] [Insightful Pipe] [License]

Connect Google Sheets to AI assistants: read, write and format spreadsheet data.

Part of the Insightful Pipe MCP Server Collection — use Google Sheets from Claude, ChatGPT, Cursor, and other AI assistants through the Model Context Protocol (MCP).

[Google Sheets MCP Server]

MCP Server URL

https://google-sheets.insightfulmcp.com/

What is Google Sheets MCP?

Google Sheets MCP is a remote Model Context Protocol server hosted by InsightfulPipe. Preview tabs, headers, and targeted ranges from connected Google Sheets to pair manual data with AI workflows.

Installation

Claude

  1. Copy the MCP Server URL: https://google-sheets.insightfulmcp.com/
  2. Open Claude Connectors Settings
  3. Scroll to the bottom and click Add custom connector
  4. Paste the URL and click Add
  5. Click Connect and sign in to InsightfulPipe if asked. Claude then lists the connector as connected.

ChatGPT

Custom MCP servers are added through ChatGPT's Developer mode. Availability depends on your ChatGPT plan, and workspace admins may need to allow it.

  1. Turn on Developer mode in ChatGPT settings
  2. Create a new app for a remote MCP server and paste the URL: https://google-sheets.insightfulmcp.com/
  3. Sign in to InsightfulPipe if asked. The connection finishes as soon as you are signed in.

See OpenAI's guide: Developer mode and MCP apps in ChatGPT

Claude Code

bash
claude mcp add --transport http google-sheets https://google-sheets.insightfulmcp.com/

Cursor

Add the server to ~/.cursor/mcp.json (all projects) or .cursor/mcp.json (one project):

json
{  "mcpServers": {    "google-sheets": {      "url": "https://google-sheets.insightfulmcp.com/"    }  }}

When Cursor shows Needs authentication, click Connect and sign in to InsightfulPipe if asked.

Available Actions

26 actions: 3 read, 23 write.

Read Actions (3)

ActionDescription
get_sheet_peakPeek at sheet to see available columns and sample data
list_sheetsList sheet/tab metadata inside a spreadsheet (sheet_id, title, index, optional gridProperties)
query_sheet_dataQuery sheet data with SQL-like operations (SELECT, WHERE)

Write Actions (23)

ActionDescription
add_bandingApply alternating (banded) row colours to a range
add_conditional_formatAdd a conditional formatting rule (colour scale or boolean condition) to a range
add_filter_viewCreate a named saved filter view that can be activated later
add_named_rangeCreate a named range that can be referenced in formulas across the spreadsheet
add_protected_rangeLock a cell range so that only editors you choose can modify it
add_rowsInsert blank rows into a sheet (default inserts at the end)
add_slicerAdd an interactive slicer (filter control) anchored to a sheet
auto_resizeAuto-fit column widths or row heights to content
batch_update_cellsUpdate multiple ranges in a single call by providing a mapping of range => 2D array of values
create_chartAdd an embedded chart (bar, line, pie, column, area, scatter) to a sheet
create_sheetAdd a new tab to an existing spreadsheet with optional row/column counts and index
delete_chartRemove an embedded chart from the spreadsheet
duplicate_sheetClone an existing sheet tab into a new tab within the same spreadsheet
format_cellsApply formatting (bold, colours, fonts, number formats, alignment) to a cell range
merge_cellsMerge a range of cells into one
set_basic_filterSet the basic auto-filter on a sheet range (shows filter dropdowns in column headers)
set_data_validationAdd a data validation rule (drop-down list, number constraint, etc.) to a range
sort_rangeSort a range of cells by one or more columns
unmerge_cellsUnmerge previously merged cells in a range
update_bordersSet or clear borders on a cell range
update_cellsOverwrite a contiguous range of cells with the provided 2D array of values
update_sheet_propertiesRename a tab, change its tab colour, freeze rows/columns, or hide/show it
update_slicerModify an existing slicer's column index or data range

Control What Your AI Can Do

You decide what AI agents can do with each connected account:

  • Turn individual actions on or off for every connected account, so agents only see the actions you allow.
  • Connect as Read-only or Read & Write. A read-only connection can only enable read actions.
  • Destructive actions stay off by default. Actions such as deletes are disabled until an admin enables them.
  • Team access per account. Restricted team members only use the accounts they are granted, with the read actions enabled on them.

Usage Examples

"Summarize the tabs and headers in my "Q3 Budget" spreadsheet"
"Add a row to the Leads sheet with today's form submissions"
"Create a chart of monthly revenue"

Pricing

The Google Sheets MCP server is included in every InsightfulPipe plan, together with all other MCP servers and the CLI. Plans start at $29.99/month, and you can try it for 7 days. See insightfulpipe.com/pricing for current plans.

Ready-Made Skills and Prompts

Explore More MCP Servers by Insightful Pipe

Visit insightfulpipe.com/mcp-servers to discover our full collection of MCP servers.

View All MCP Servers →

Resources

Support

Insightful Pipe — AI-powered marketing analytics through MCP servers. Explore all integrations →

License

MIT License - see LICENSE for details.

來源：README.md，提交 e5a53c4

工具

0
該伺服器需要登入，因此 SourceWeft 無法在沒有帳號的情況下讀取其工具，也未收錄。已連接帳號所能看到的內容可能因帳號及其權限而異。

版本歷史

1
  1. v1.0.0最新Oct 21, 2026

評分

已滿足適用檢查項的 85%

該評分衡量此收錄條目的完整程度，依據註冊中心條目、端點與公開來源計算得出。它不是對伺服器本身的評價，也不表示伺服器安全或目前可用：可連通性是帶日期的檢查結果，評分也不包含安裝量或使用者評價。

  • 近 30 天內可連通必需25 分
  • 已宣告認證方式必需10 分
  • 已列出工具15 分

    請讓伺服器在無憑證時回應 tools/list，或發布可在沙箱中無憑證啟動的軟體包。

  • 描述必需15 分
  • 圖示10 分
  • 文件15 分
  • 授權條款10 分