Only available on Google Sheets

​
Superjoin MCP Integration Guide

Unlock the power of AI agents with the Model Control Protocol (MCP)! 🚀 MCP is an open standard that enables AI models to securely connect with external tools, APIs, and data sources. With MCP, your Copilot can perform complex tasks, access real-time information, and interact with various services directly from your workflow.

​
Overview

Superjoin’s Sheets Copilot supports Model Context Protocol (MCP) integration, allowing you to connect to external data sources and services directly from Google Sheets. This powerful feature enables you to pull data, perform complex analysis, and execute operations without leaving your spreadsheet environment.

​
Getting Started

​
Step 1: Install Superjoin

Follow the quickstart guide to Install and Launch Superjoin 🚀

Quickstart

Install Superjoin in under a minute and start pulling your data instantly.

​
Step 2: Access Sheets Copilot

  1. Open your Google Sheets document
  2. Navigate to Extensions in the menu bar
  3. Select Superjoin from the extensions list
  4. The Sheets Copilot interface will open

​
Setting Up MCP Connections

​
Step 3: Add a New Connection

  1. In the Copilot interface, look for the Toolbox icon
  2. Click on Plugins or the connection management area
  3. Select Add Connection tab
  4. You’ll see a connection setup form

​
Step 4: Configure Connection Details

Fill in the required connection information:

​
Server Name

  • Enter a descriptive name for your connection (e.g., “paypal”, “salesforce”, “github”)
  • This name will help you identify the connection later

​
Server URL

  • Enter the complete MCP server URL
  • Example: https://mcp.paypal.com/sse
  • Ensure the URL is correct and accessible

​
Authentication

Choose from multiple authentication methods:
We also allow connecting to servers which support OAuth 2.1 authentication methods

​
Step 5: Connect to Server

  1. After filling in all required fields, click Connect Server
  2. The system will attempt to establish a connection - In case of Oauth, it may redirect you to a different page.
  3. Upon successful connection, you’ll see a green indicator next to your connection
  4. Your connection will appear in the Connections tab with its status

​
Step 6: Managing Connections

  • View Connections: Switch to the Connections tab to see all active connections
  • Connection Status: Green dot indicates active connection
  • Delete Connection: Use the trash icon to remove connections you no longer need
  • Multiple Connections: You can connect to multiple MCP servers simultaneously

​
Using MCP in Your Workflow

​
Practical Example: PayPal Transaction Data

​
Advanced Usage Patterns

​
Multi-Source Data Integration

"Pull sales data from Salesforce and payment data from PayPal, then create a reconciliation report"

​
Real-time Analysis

"Get the latest customer support tickets from Zendesk and analyze sentiment trends"

​
Automated Reporting

"Fetch monthly revenue data from Stripe and create a financial dashboard with charts"

​
Security

  • Never share connection credentials: Each user should set up their own connections
  • Use least privilege: Only grant necessary permissions when setting up OAuth
  • Regular cleanup: Remove unused connections to maintain security hygiene

​
Troubleshooting

​
Common Connection Issues

​
Conclusion

Superjoin’s MCP integration transforms Google Sheets into a powerful data analysis and operations center. By connecting to external services through MCP, you can build sophisticated workflows without complex integrations or leaving your familiar spreadsheet environment. The combination of natural language queries, multiple authentication methods, and real-time data access makes it an ideal solution for teams that need flexible, powerful data tools with minimal technical overhead.