Amazon Ads, Seller Central & Vendor Central in Microsoft Copilot

How do I connect Amazon Ads to Microsoft Copilot?

Microsoft 365 Copilot connects to Amazon Ads, Seller Central, and Vendor Central through a Copilot Studio agent that uses the Marketplace Ad Pros MCP server. In Copilot Studio, add a Model Context Protocol tool with the server URL https://app.marketplaceadpros.com/mcp, choose OAuth 2.0 with dynamic discovery, sign in, and publish the agent to Microsoft 365 Copilot or Teams. The free consumer Copilot app does not support custom MCP servers.

Last updated: September 16, 2026. Setup steps follow Microsoft's Copilot Studio MCP documentation.

Detailed Setup Instructions

Step 1: Add the MCP server to a Copilot Studio agent

1. Open Copilot Studio and create an agent (or open an existing one).
2. Go to the agent's Tools page and select Add a tool.
3. Select New tool, then Model Context Protocol. The MCP onboarding wizard opens.
4. For Server name, enter Marketplace Ad Pros.
5. For Server description, enter a description the agent can use to decide when to call it, such as Amazon Ads, Seller Central, and Vendor Central data: campaigns, keywords, search terms, sales, inventory, and recommendations.
6. For Server URL, enter https://app.marketplaceadpros.com/mcp

Step 2: Configure authentication and sign in

1. For authentication, select OAuth 2.0, then choose Dynamic discovery.
2. Select Create. Copilot Studio discovers the Marketplace Ad Pros sign-in endpoints and registers itself, so there is no client ID or secret to copy.
3. In the Add tool dialog, select Create a new connection. Sign in with your Marketplace Ad Pros login and choose which permissions to grant.
4. Select Add to agent.

Step 3: Publish to Microsoft 365 Copilot and Teams

1. Test the agent in Copilot Studio's test pane with a question like "List my Amazon Ads profiles."
2. Select Publish, then add the Teams and Microsoft 365 Copilot channel.
3. Open Microsoft 365 Copilot Chat and pick your agent from the Agents list. Sharing it across your organization may need admin approval.

Alternative: API key authentication

If OAuth sign-in is blocked in your tenant, use an API key. Anyone who uses the agent with this connection acts as the key's owner, so prefer OAuth for shared agents.

1. Create an MCP key on the Marketplace Ad Pros Integrations page (read-only or read and write).
2. In the MCP onboarding wizard, choose API key as the authentication type.
3. Set Type to Query and the parameter name to token.
4. Select Create, then paste your key when you create the connection.

Example Prompts for Copilot

• "Which Sponsored Products search terms spent over $50 in the last 30 days with no orders?"
• "What was my TACoS last month for each marketplace?"
• "Which ASINs have less than 30 days of FBA inventory but rising ad spend?"
• "Compare Vendor Central ordered revenue with ad spend week over week for the last 8 weeks."
• "Summarize this week's Amazon performance for the Monday team meeting."

Want more? Browse 50 Amazon Ads prompts for AI.