Give your chatbot a Google Sheet to answer from

Answers from a row you control

A support or sales chatbot needs to answer from facts, not vibes. When those facts — product specs, return windows, plan limits, canned Q&A — live in a Google Sheet, PasteSheet turns the sheet into a Model Context Protocol server the bot queries at answer time. Edit a cell and the next reply reflects it; there is no retraining and no redeploy.

Crucially, this is publish, not connect: you are not wiring your Google account into the bot. You publish one sheet as a read-only knowledge base that your chatbot — or a teammate's — reads through three tools, with no write access and no Google Cloud project to stand up.

The tools the bot gets

Connect the endpoint and the chatbot can call three read-only tools:

• list_tabs — discover the tabs in the sheet, e.g. FAQ, Products, Policies.
• get_schema — read each column's name, alias, and type before querying.
• query_rows — match a question with filters, partial matches, and full-text search, then return the answer row.

Connect the knowledge sheet

Each endpoint has its own MCP URL. Copy it from the Connect via MCP panel and add it to your bot's runtime as a custom connector:

{
  "mcpServers": {
    "pastesheet": {
      "url": "https://pastesheet.com/mcp/sheets/your-endpoint-id"
    }
  }
}

Read-only, so the facts stay put

Because the endpoint is read-only by design, it is safe to expose publicly or hand to a teammate: consumers can read and query the data but can never change the sheet. And there is no Google Cloud project, OAuth screen, or service account to set up — you paste a share URL and get a live API.

What it costs

Frequently asked questions

Sources

• Model Context Protocol specification — Model Context Protocol
• Installing and using an MCP server — Anthropic

Related use cases