PasteSheet icon PasteSheet logo mark — a spreadsheet grid with a curly brace on a green rounded square PasteSheet

Connect Google Sheets to Manus AI

Manus AI can pull live data from a Google Sheet over MCP. Add your PasteSheet endpoint as a custom MCP connector and the agent can list tabs, read the schema, and query rows — no Google Cloud project and no code.

Last updated

View as .md

Key facts

  • Manus adds custom MCP servers under Settings → Connectors → Custom MCP, by Direct Configuration (name, transport and server URL) or by importing JSON. It then verifies the server and loads its tools. source
  • MCP is an open protocol built on JSON-RPC 2.0. A server exposes Resources, Prompts and Tools to any MCP client — Claude, Cursor, ChatGPT, VS Code and Windsurf all speak it. source
  • PasteSheet's MCP server exposes three tools — list_tabs, get_schema and query_rows — and is read-only by design: an agent can query your sheet but can never modify it.
  • It needs no Google Cloud project, no OAuth consent screen and no service-account JSON. You paste a share URL, and MCP is included on the Free plan.

Can Manus AI read a Google Sheet?

Yes — Manus supports custom MCP servers, and PasteSheet turns any Google Sheet into one. Paste the sheet's share URL into PasteSheet, add the resulting MCP URL to Manus as a custom connector, and the agent can query your spreadsheet mid-task.

There is no Google Cloud project, service account, or code to write — PasteSheet hosts the MCP server for you, and the connection is read-only, so Manus can read and analyze the data but never change the sheet.

Add PasteSheet as a custom MCP server in Manus

In Manus, custom MCP servers live under Connectors:

  1. 1 Open Settings → Connectors and click + Add Connectors.
  2. 2 Choose the Custom MCP tab, click + Add Custom MCP, and pick Direct Configuration.
  3. 3 Give it a name, set the transport to HTTP, and paste your endpoint's MCP URL as the Server URL.
  4. 4 Save. Manus verifies the server and loads its tools — list_tabs, get_schema, and query_rows — then you can ask it about your sheet.

Or import it as JSON

Manus also accepts an Import by JSON config on the same Custom MCP tab:

Custom MCP (Import by JSON) 
{
  "mcpServers": {
    "pastesheet": {
      "url": "https://pastesheet.com/mcp/sheets/your-endpoint-id"
    }
  }
}

Public vs private sheets

A public endpoint is keyless — paste the MCP URL and it works. For a private endpoint, append ?api_key=YOUR_KEY to the Server URL. To expose every sheet you own through one connector, use the workspace server at https://pastesheet.com/mcp. See the MCP overview for how the connection works.

What it costs

MCP is included on the Free plan. Connect any public endpoint over MCP with no Google Cloud project and no credit card. Private endpoints and the account-wide workspace server need a paid plan (from Starter ($9/mo)) for the keys and OAuth they authenticate with.

Pro adds full-text search and aggregation (count, sum, avg, group_by) that your AI agent can call through query_rows.

Starter

For indie makers shipping a real app.

$9 /mo
Endpoints
10
Requests / mo
50,000
Row cap
5,000
  • MCP for AI agents
Choose Starter
Compare plans Start free

Frequently asked questions

How do I add a Google Sheets MCP server in Manus AI?

In Manus, go to Settings → Connectors → + Add Connectors → Custom MCP, choose Direct Configuration, set the transport to HTTP, and paste your PasteSheet endpoint's MCP URL as the Server URL.

Does it need a Google Cloud project?

No. PasteSheet reads a shared Google Sheet and hosts the MCP server, so there is no Google Cloud project, service account, or OAuth screen to set up.

Can Manus edit my sheet?

No. The connection is read-only by design — Manus can query and analyze your data through list_tabs, get_schema, and query_rows, but cannot modify the spreadsheet.

Sources

Related guides

Google Sheets MCP Server for Claude & ChatGPT

Turn any Google Sheet into an MCP server so Claude, Cursor, and ChatGPT can read and query it in plain English. No code, no backend — connect in minutes.

Connect Google Sheets to ChatGPT via MCP

Connect a Google Sheet to ChatGPT using PasteSheet's workspace MCP server and OAuth. Let ChatGPT query your spreadsheet data in plain English, no code required.

Connect Google Sheets to Cursor via MCP

Add a Google Sheet to Cursor as an MCP server so the editor's AI can query your spreadsheet while you code. No backend — copy one URL and you are connected.

Turn your sheet into an API in minutes

Paste a Google Sheet URL and get a live REST API and MCP server — no backend, no code, free to start.

Start free See pricing