Skip to main content

Connect Funnel MCP to a Microsoft Copilot Studio agent

Configure OAuth manually to add Funnel MCP to a Microsoft Copilot Studio agent and optionally publish it to Microsoft 365 Copilot and Microsoft Teams.

Connect Funnel MCP to an agent in Microsoft Copilot Studio. The agent can then use your Funnel workspace data and field definitions. You can publish the agent so Microsoft 365 Copilot and Microsoft Teams can use Funnel MCP.

​

During setup, Copilot Studio creates a callback URL. You must add this URL to Funnel before you complete the connection.

​

For more information, see Connect your agent to an existing Model Context Protocol (MCP) server in the Microsoft documentation.

​

Before you begin

  • You have a Funnel subscription and an owner role.

  • You have access to at least one Funnel workspace.

  • The workspace has at least one connected data source.

  • You have permission to edit or create an agent and add tools in Microsoft Copilot Studio.

​

Connect your Copilot Studio agent to Funnel MCP

1. Create a Copilot client in Funnel

  1. In Funnel, open your profile menu.

    ​

  2. Select Subscription overview.

    ​

  3. From the Subscription Management left navigation pane, select Users.

    ​

  4. Select the System users tab.

    ​

  5. Click + Create System user.

    ​

  6. Select MCP Client/App.

    ​

  7. Click + Continue.

    ​

  8. Select Microsoft Copilot Studio.

    ​

  9. Enter a name for your Copilot Studio agent.

    ​

  10. Click Create Copilot client.

​

Funnel opens the System user details page. Keep this page open. You must copy values from this page to Copilot Studio.

​

2. Add Funnel MCP to your Copilot Studio agent

  1. In Copilot Studio, open your agent.

    ​

  2. Click + next to Tools.

    ​

  3. In Add a tool, select Model Context Protocol (MCP).

    ​

  4. In Add MCP server, enter a Server name.

    ​

  5. Enter a Server description.

    ​

  6. Copy the Server URL from Funnel.

    ​

  7. Paste the URL into Server URL in Copilot Studio.

    ​

  8. Under Authentication, select OAuth 2.0.

    ​

  9. Under Configuration type, select Manual.

    ​

  10. Copy each value from Funnel into the matching field in Copilot Studio:

    • Client ID to Client ID

    • Client secret to Client secret

    • Authorization URL to Authorization URL

    • Token URL to Token URL

    • Refresh URL to Refresh token URL

    • Scope to Scopes

    ​

  11. Click Add. Copilot Studio shows a dialog with the redirect URL.

​

3. Add the Copilot Studio callback URL in Funnel

  1. Copy the redirect URL.

    ​

    The Save your redirect URL dialog with the redirect URL, Copy and Next

    ​

  2. Return to the System user details page in Funnel.

    ​

  3. Paste the URL into Allowed Callback URLs.

    ​

  4. Click Save callback URLs. Paste the callback URL exactly. Do not add wildcards or change the URL.

​

4. Finish the connection in Copilot Studio

  1. Return to Copilot Studio.

    ​

  2. In the Save your redirect URL dialog, click Next.

    ​

  3. In Select a connection, open the Connection menu.

    ​

  4. Select Create new connection.

    ​

    The Connection menu with Create new connection selected

    ​

  5. In the connection dialog, click Create.

    ​

  6. In the Funnel authorization window, review the requested access.

    ​

  7. Click Accept.

    ​

  8. In Select a connection, select the connected Funnel MCP connection.

    ​

  9. Click Add. Funnel MCP appears in the list of tools.

    ​

  10. Open the Funnel MCP tool.

    ​

  11. Select the tools that the agent can use.

    ​

  12. Under Authentication mode, select User.

    ​

  13. Click Confirm.

    ​

  14. Open Preview.

    ​

  15. Enter a prompt to verify the connection.

    ​

  16. When Copilot Studio requests permission to use the Funnel MCP tool, click Allow.

    ​

  17. Save the changes.

    ​

  18. (Optional) Evaluate the agent before you publish it. For the procedure, see Evaluate an agent (preview).

​

5. (Optional) Publish the agent to Microsoft 365 Copilot and Microsoft Teams

Publish the agent to Microsoft 365 Copilot or Microsoft Teams.

​

For channel requirements, see Publish overview for agents.

​

  1. In Copilot Studio, open your agent.

    ​

  2. Expand the Publish options.

    ​

  3. Select the Teams + Microsoft 365 check box.

    ​

  4. Under Turn on Microsoft 365, select Make agent available in Microsoft 365 Copilot.

    ​

    If you do not select Make agent available in Microsoft 365 Copilot, the agent is available only in Microsoft Teams.

    ​

  5. Click Save and publish.

    ​

    Publishing can take a few minutes. For status descriptions, see Publish states.

    ​

  6. To open the agent in Microsoft 365 Copilot, click See agent in Microsoft 365.

    ​

  7. To open the agent in Microsoft Teams, click See agent in Teams.

    ​

    The Publish agent dialog with Teams + Microsoft 365 selected and Save and publish

    ​

  8. When a permission prompt appears, grant the requested access.

Note: To publish the agent to another channel, see Available channels for agents. An administrator can block a channel. If the Teams + Microsoft 365 channel is unavailable, ask your administrator to allow the channel for Copilot Studio agents.

What to expect

Your Copilot Studio agent is connected to Funnel MCP with OAuth. The agent can use the enabled Funnel MCP tools to query workspace data and field definitions. These tools are read-only and run on behalf of the signed-in user.

​

If you publish the agent, users who install it can use the same tools in Microsoft 365 Copilot and in a private Microsoft Teams chat. Each user must authorize Funnel MCP.

Did this answer your question?