> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superjoin.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Model Control Protocol (MCP) for Copilot

> Discover how to integrate and use the Model Control Protocol (MCP) with your Copilot, enabling seamless interaction with external tools and services.

<Check>Only available on Google Sheets</Check>

# Superjoin MCP Integration Guide

Unlock the power of AI agents with the <b>Model Control Protocol (MCP)</b>! 🚀 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 🚀

<Card title="Quickstart" icon="flag-checkered" iconType="duotone" href="/quickstart">
  Install Superjoin in under a minute and start pulling your data instantly.
</Card>

### 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

<Frame>
  <img src="https://mintcdn.com/superjoin/Fj1m3rGY5-lshl-N/images/copilot/mcp/step-1.png?fit=max&auto=format&n=Fj1m3rGY5-lshl-N&q=85&s=e473a6aff1915d1abad4e22e6ed20026" height="200" width="200" data-path="images/copilot/mcp/step-1.png" />
</Frame>

### Step 4: Configure Connection Details

Fill in the required connection information:

<Frame>
  <img src="https://mintcdn.com/superjoin/Fj1m3rGY5-lshl-N/images/copilot/mcp/step-2.png?fit=max&auto=format&n=Fj1m3rGY5-lshl-N&q=85&s=a199cf7d956030f289cd5943d6ae3511" width="300" data-path="images/copilot/mcp/step-2.png" />
</Frame>

#### 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:

<Note>
  We also allow connecting to servers which support OAuth 2.1 authentication
  methods
</Note>

<Frame>
  <img src="https://mintcdn.com/superjoin/Fj1m3rGY5-lshl-N/images/copilot/mcp/step-auth.png?fit=max&auto=format&n=Fj1m3rGY5-lshl-N&q=85&s=93a97f2effd86f09cb50f0825c52e171" width="300" data-path="images/copilot/mcp/step-auth.png" />
</Frame>

### 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

<Frame>
  <img src="https://mintcdn.com/superjoin/Fj1m3rGY5-lshl-N/images/copilot/mcp/step-3.png?fit=max&auto=format&n=Fj1m3rGY5-lshl-N&q=85&s=09f31d38d95d5f929b04856fc9ac2393" width="300" data-path="images/copilot/mcp/step-3.png" />
</Frame>

* **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

<Frame>
  <img src="https://mintcdn.com/superjoin/Fj1m3rGY5-lshl-N/images/copilot/mcp/step-4.png?fit=max&auto=format&n=Fj1m3rGY5-lshl-N&q=85&s=17ca03bb939981d7b938029aa81cdf2c" width="200" data-path="images/copilot/mcp/step-4.png" />
</Frame>

### 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

<AccordionGroup>
  <Accordion title="Connection Failed">
    * Verify the server URL is correct and accessible - Check authentication
      credentials - Ensure your network allows connections to the MCP server
  </Accordion>

  {" "}

  <Accordion title="Authentication Errors">
    * Verify API keys or tokens are valid and not expired - Check if the service
      requires specific scopes or permissions - For OAuth, try re-authorizing the
      connection
  </Accordion>

  <Accordion title="Data Retrieval Issues">
    * Confirm the MCP server supports the requested operation - Check if you
      have necessary permissions to access the requested data - Verify the query
      syntax matches the server's expected format
  </Accordion>
</AccordionGroup>

## 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.