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 分