
How to Connect Manus AI to Google Sheets via Mushrooms MCP
What You're Actually Trying to Do
You want Manus AI to read from, write to, and manipulate Google Sheets — without copy-pasting data, without brittle scripts, and without switching tabs every five minutes.
That's what Mushrooms, viaSocket's MCP server platform, makes possible. Instead of treating your spreadsheet as a static file, Mushrooms exposes 2,500+ apps (including Google Sheets) as live tools that Manus can call directly — query ranges, update cells, append rows, all from a single instruction.
Prerequisites
|
Step 1: Understand What Mushrooms MCP Is
MCP (Model Context Protocol) is an open standard that lets AI agents connect to external tools via a standardized interface. Mushrooms is viaSocket's MCP server platform — it wraps 2,500+ app APIs and exposes them as MCP-compatible tools.
When connected to Manus, Mushrooms gives the agent real-time, read-write access to your apps — no prompting tricks required.
Step 2: Get Your Mushrooms MCP Endpoint
Go to viasocket.com and create a free account
Navigate to Integrations → Google Sheets and connect via OAuth
Go to MCP Servers in the sidebar → find your Mushrooms cluster
Copy your personal MCP Endpoint URL — it looks like: https://mcp.viasocket.com/mcp/your-unique-id
You can also copy a ready-made JSON config directly from the dashboard.
⚠️ Security Warning: Treat your MCP Endpoint URL like a password. Anyone with this URL can run tools attached to your server and access your data. Never share it publicly. |
Step 3: Add Mushrooms MCP to Manus AI
Manus supports two methods. Use whichever you prefer.
Option 1 — Direct Configuration (URL)
Go to Settings → Connectors in the sidebar
Click "+ Add Connectors" → go to the "Custom MCP" tab
Click "+ Add Custom MCP" → select "Direct Configuration"
Fill in:
Name: Mushrooms
Transport: SSE
Server URL: https://mcp.viasocket.com/mcp/your-unique-id
Click Save
Option 2 — Import by JSON
Go to Settings → Connectors → "Custom MCP" tab
Click "+ Add Custom MCP" → select "Import by JSON"
Paste:
{...}{ "mcpServers": { "mushroom": { "url": "https://mcp.viasocket.com/mcp/your-unique-id", "transport": "sse" } } }
Click save
Note: The transport: SSE field is required — omitting it may cause the connection to fail.
Step 4: Test the Connection
Start a new Manus task and type:
Read the values in range A1:C10 from my spreadsheet [YOUR_SPREADSHEET_ID] and tell me what you find.
If data comes back, you're live.
Step 5: Run Real Workflows
Auto-summarize a sheet:
Look at the sheet "Q2 Sales" in spreadsheet [ID]. Summarize total revenue by region.
Append a row:
Add to my "Tasks" sheet — "Write MCP blog post" | Owner: Jatin | Status: Done | Date: today
Conditional alert:
Check if any value in column D of sheet "Inventory" is below 10. If yes, list those rows.
Troubleshooting
Error | Fix |
"Tool not found" | Re-add the URL in Settings → Connectors |
"Permission denied" | Re-authorize Google OAuth in viaSocket |
"Spreadsheet not found" | Check spreadsheet ID (no slashes) |
Stale data | Refresh the Manus session |
Why This Matters
MCP-connected agents flip the usual AI-on-data model. Instead of working on a copy-pasted snapshot, Manus has live read-write access to your actual data source. Workflows trigger on real conditions. Outputs write back where your team already works.
And since Mushrooms connects 2,500+ apps — not just Google Sheets — the same setup extends to Slack, Notion, Airtable, Gmail, and more.
What to Build Next
Manus + Sheets + Slack — agent reads sheet, posts summary to a channel
Form → Sheet → Agent — process Google Form submissions automatically
Multi-app chains — trigger workflows across any of viaSocket's 2,500+ integrations
The same Mushrooms connection you set up here powers all of it.