PasteSheet — Google Sheets

com.pastesheet由 pastesheet.com 發布官方發布者v1.0.0更新於 Oct 24, 2026

Query your Google Sheets as structured JSON: list sheets and tabs, read schemas, filter rows.

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

概覽

AI 產生的概覽

託管的唯讀 Google Sheets MCP 伺服器，讓助理以結構化 JSON 列出分頁、讀取欄位結構並查詢列資料。

可以做什麼
列出工作區中的試算表及其 id，並列出某個試算表的分頁與預設分頁（僅工作區伺服器支援列出試算表）。查詢前讀取每欄的名稱、別名與型別。依篩選條件、部分比對、全文搜尋、排序與分頁讀取列資料。助理會自行串接這些步驟，因此可以用自然語言提問，不必指定工具名稱。
適用情境
適合讓助理根據試算表資料回答問題，例如篩選列、尋找紀錄或依欄位彙總，而不必建立 Google Cloud 專案或服務帳戶。單一試算表端點適合只把某一份試算表開放給助理。
執行需求
遠端 MCP 端點，無需安裝或執行任何程式。工作區端點需要一次性 OAuth 授權。單一試算表端點對公開試算表免金鑰，私有試算表需要 Authorization Bearer 權杖。需要 PasteSheet 帳號與方案；免費額度為 3 個端點、每月 2,000 次請求、500 列、每份試算表 1 個分頁。
安裝前請注意
設計上為唯讀：可以列出、檢視與查詢試算表，但不能修改。試算表資料會由託管的 PasteSheet 服務讀取，請評估這些資料是否允許離開 Google。私有端點、更高額度、自訂快取 TTL 與全文搜尋需要付費方案；免費額度有列數與分頁限制。

安裝

在 SourceWeft 中

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

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

交給代理程式安裝

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

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

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

其他 MCP 客戶端

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

{
  "mcpServers": {
    "pastesheet-google-sheets": {
      "type": "http",
      "url": "https://pastesheet.com/mcp"
    }
  }
}

README

Google Sheets MCP Server

A hosted Google Sheets MCP server. Connect any Google Sheet to Claude, ChatGPT, Cursor, or Claude Code — and query it in plain English.

No Google Cloud project. No service account. No server to run. Paste a share URL and you get an MCP endpoint.

Read-only by design. The server can list, inspect, and query your sheet. It cannot modify it. Safe to hand to an agent.

Powered by PasteSheet. Published to the official MCP Registry as com.pastesheet/google-sheets.

Quick start

Claude Code

bash
claude mcp add --transport http pastesheet https://pastesheet.com/mcp

Claude Desktop / Claude web

Settings → Connectors → Add custom connector → paste:

https://pastesheet.com/mcp

You'll be sent through OAuth once, then Claude can query every sheet in your workspace.

Cursor

~/.cursor/mcp.json — see examples/cursor-mcp.json:

json
{  "mcpServers": {    "pastesheet": {      "url": "https://pastesheet.com/mcp"    }  }}

ChatGPT

Settings → Connectors → Add custom connector → https://pastesheet.com/mcp, then authorize with OAuth.

Two servers, two URLs

ServerURLUse it when
Workspacehttps://pastesheet.com/mcpYou want one connector that exposes every sheet in your account. Authenticates with OAuth. Start here.
Single sheethttps://pastesheet.com/mcp/sheets/{endpoint-id}You want to expose exactly one sheet. Public sheets are keyless; private ones take Authorization: Bearer ps_....

The workspace URL is the same for everyone — OAuth resolves which account you are, and you only ever see your own sheets.

Tools

ToolWhat it does
list_sheetsDiscover the sheets in your workspace and their ids. (workspace server only)
list_tabsList a sheet's tabs and the default one.
get_schemaRead each column's name, alias, and type before querying.
query_rowsRead rows with filters, partial matches, full-text search, sorting, and pagination.

Example prompts

Once connected, just ask:

  • "What's in my Products sheet?"
  • "Which rows in the Q3 tab have status = shipped?"
  • "Total revenue by region from my Sales sheet."
  • "Find every customer whose company starts with 'Acme'."

The agent calls list_sheets → get_schema → query_rows on its own. You don't name the tools.

Why not talk to the Google Sheets API directly?

You can — it's free. But it's built for a different job:

  • It reads cells and ranges, not records. You reassemble rows yourself.
  • It needs a Google Cloud project plus OAuth or a service account.
  • It meters you: 300 read requests per minute per project, 60 per minute per user, then returns 429 (Google's published limits).

That last one bites with agents, because agents are chatty — one question becomes a schema read plus several filtered queries. PasteSheet reads the sheet once, caches it, and serves the rest from cache, so the tenth query costs Google nothing.

Pricing

The free tier runs 3 endpoints, 2,000 requests/month, 500 rows, 1 tab per sheet — no credit card. Paid plans raise the caps and add private endpoints, custom cache TTL, and full-text search.

See pastesheet.com/pricing.

Links

Issues and questions: open an issue here, or get in touch.

來源：README.md，提交 a441b61

工具

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

版本歷史

1
  1. v1.0.0最新Sep 16, 2026

評分

已滿足適用檢查項的 75%

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

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

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

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

    請在儲存庫或註冊中心條目中宣告授權條款。