Notion + Microsoft Copilot Studio: Complete MCP Integration
Notion is a MCP server that Notion's official hosted MCP server providing secure AI tool access to workspace content including pages, databases, and comments through OAuth authentication..
When integrated with Microsoft Copilot Studio, you can:
- Search and retrieve live context from Notion workspace based on user access and permissions
- Access and query Notion databases to retrieve structured information
- Read page content and metadata from workspace pages you have access to
This guide provides step-by-step instructions to set up Notion in Microsoft Copilot Studio, including configuration, examples, and troubleshooting.
What You'll Achieve
After completing this setup:
- Notion will be fully integrated and operational
- You can use Notion tools directly in Microsoft Copilot Studio
- All Notion capabilities will be available for your workflows
- Access to 4 different tools
Prerequisites
Before starting, ensure you have:
- Node.js 18 or higher (for STDIO transport only)
- Active Notion workspace with appropriate access permissions
- MCP client that supports remote servers (HTTP/SSE) or STDIO transport
- Notion account with workspace access
- Supported AI tool with MCP client capabilities
- Permission to connect external applications to workspace
- Microsoft Copilot Studio installed and configured
- Compatible operating system (Web Browser, Microsoft 365)
Installation
Step 1: Install Notion
Install using npm:
npx -y mcp-remote https://mcp.notion.com/mcp
Verify installation:
Connection verified through OAuth flow in your AI tool
Configuration
Step 2: Configure Microsoft Copilot Studio
- Enable Generative Orchestration
Generative Orchestration must be enabled in your Copilot Studio environment to use MCP
Visit: https://learn.microsoft.com/en-us/microsoft-copilot-studio/agent-extend-action-mcp
Note: This is a prerequisite - MCP will not work without it
- Access Copilot Studio
Log in to Microsoft Copilot Studio with appropriate permissions to create and configure agents
Visit: https://copilotstudio.microsoft.com
Note: Requires organizational access or trial subscription
- Navigate to Connectors
In Copilot Studio, go to the Connectors section where you can add new integrations
Note: Location may vary based on interface updates
- Create MCP Connector
Click "Add Connector" and select "Model Context Protocol (MCP)" from the available connector types
Note: Use the YAML schema template provided by Copilot Studio
- Configure {server_name} Connection
Fill in the YAML schema with {server_name} server details including command, arguments, and environment variables
npx
Note: Copilot Studio dynamically reflects changes as tools and resources are updated on the MCP server
- Add Tools to Agent
Once connected, add the MCP server tools and resources to your specific agent through the Copilot Studio UI
Note: Currently supports Tools and Resources (Prompts not yet supported)
- Test Agent Capabilities
Test your agent to verify it can access and use the {server_name} tools correctly
Configuration Details
Connect MCP server to Microsoft Copilot Studio:
Step 1: Create YAML Connector Schema
In Copilot Studio, navigate to the connectors section and create a new MCP connector using the YAML schema template:
# MCP Connector Configuration for Notion
name: Notion-mcp-connector
description: Notion's official hosted MCP server providing secure AI tool access to workspace content including pages, databases, and comments through OAuth authentication.
mcp_server:
command: npx
args: "-y", "mcp-remote", "https://mcp.notion.com/mcp", "https://mcp.notion.com/mcp"
env:
Step 2: Add to Agent
Once connected, add the MCP server's tools and resources to your Copilot Studio agent through the UI.
Examples
Once configured, you can use Notion in Microsoft Copilot Studio:
Create Project Documentation
Generate PRDs, tech specs, or architecture docs by pulling context from existing Notion pages
Ask Microsoft Copilot Studio: "Create a technical specification for the new authentication system based on our security guidelines in Notion"
Expected Result: AI retrieves security guidelines from Notion workspace and generates comprehensive tech spec
Track Campaign Progress
Monitor and report on campaign status using Notion database data
Ask Microsoft Copilot Studio: "Give me a summary of all marketing campaigns in progress with their current metrics"
Expected Result: AI queries the campaigns database and provides formatted progress report
Search Meeting Notes
Find specific information across all meeting notes in workspace
Ask Microsoft Copilot Studio: "What decisions did we make about the API redesign in recent meetings?"
Expected Result: AI searches meeting notes and returns relevant decisions with links to source pages
Generate Release Notes
Build release documentation by aggregating information from multiple Notion pages
Ask Microsoft Copilot Studio: "Create release notes for version 2.0 using our changelog and feature pages"
Expected Result: AI compiles information from multiple pages into formatted release notes
Task Management
Query and analyze tasks from Notion databases
Ask Microsoft Copilot Studio: "Show me all overdue tasks assigned to the engineering team"
Expected Result: AI filters and presents overdue engineering tasks with details and links
Testing Your Setup
- Launch Microsoft Copilot Studio
- Verify Notion is available in the tools list
- Test basic Notion functionality
Troubleshooting
Common Issues
AI Tool Cannot Connect to Notion MCP
Symptoms: Connection timeout or failed errors, Notion MCP not appearing in tool directory, OAuth flow not starting
Cause: AI tool may not support MCP clients or remote MCP connections
Solution:
- Verify your AI tool supports MCP client functionality
- Check if tool supports remote MCP servers (HTTP/SSE transport)
- For tools without remote support, use STDIO with mcp-remote proxy: npx -y mcp-remote https://mcp.notion.com/mcp
- If tool lacks MCP support entirely, request feature from developers
OAuth Connection Fails
Symptoms: Authorization screen does not appear, Cannot complete OAuth flow, Connection succeeds but no workspace access
Cause: OAuth flow interrupted or workspace permissions issue
Solution:
- Use Notion app Settings > Connections > Notion MCP for easiest setup
- Ensure popup blockers are disabled during OAuth
- Check you have appropriate workspace permissions
- Try disconnecting and reconnecting through Notion app
Cannot Access Specific Pages or Databases
Symptoms: Some content returns not found errors, Searches return incomplete results, Database queries fail or return empty
Cause: Content access based on user permissions - AI tool can only see what you can see
Solution:
- Verify you have access to the pages/databases in Notion app
- Check workspace sharing settings for restricted content
- Ensure pages are not in private sections you cannot access
- Contact workspace admin if you need broader access
STDIO Transport Connection Issues
Symptoms: mcp-remote command fails, Connection drops frequently, Slow response times
Cause: STDIO transport requires mcp-remote proxy for hosted Notion MCP
Solution:
- Prefer Streamable HTTP or SSE transport if your tool supports it
- Ensure Node.js and npx are properly installed for STDIO
- Use config: npx -y mcp-remote https://mcp.notion.com/mcp
- Check network connectivity to mcp.notion.com
Tool Does Not Support Remote MCP Servers
Symptoms: Only local/STDIO servers work in tool, HTTP/SSE connections not available, No option to add remote server URL
Cause: Some MCP clients only support local STDIO servers
Solution:
- Use mcp-remote as proxy to convert HTTP to STDIO
- Configuration: command: npx, args: [-y, mcp-remote, https://mcp.notion.com/mcp]
- Alternative: Use open-source notion-mcp-server for local deployment
- Check tool documentation for remote server support roadmap
Generative Orchestration Not Available
Symptoms: MCP option not visible, Cannot add MCP connectors
Cause: Generative Orchestration is not enabled for your environment
Solution:
- Contact your Microsoft 365 administrator
- Enable Generative Orchestration in tenant settings
- Verify your subscription includes Copilot Studio with MCP support
- Check Microsoft Learn documentation for enablement steps
MCP Connector Connection Failed
Symptoms: Connector shows "Disconnected" status, Tools not available to agent
Cause: MCP server not accessible or configuration error
Solution:
- Verify the MCP server command is correct and accessible
- Check all required environment variables are set
- Test the MCP server independently outside Copilot Studio
- Review YAML schema for syntax errors
- Check network connectivity and firewall rules
Tools Not Appearing in Agent
Symptoms: Connector connected but tools missing, Agent cannot invoke MCP tools
Cause: Tools not added to agent or synchronization issue
Solution:
- Manually add tools to agent through Copilot Studio UI
- Refresh connector to sync latest tools from MCP server
- Verify tools are published on the MCP server
- Check agent configuration includes the MCP connector
MCP Server Tools Update Not Reflected
Symptoms: New tools not appearing, Old tools still visible after removal
Cause: Copilot Studio cache or sync delay
Solution:
- Disconnect and reconnect the MCP connector
- Wait a few minutes for dynamic sync to occur
- Manually refresh the connector in Copilot Studio
- Restart the MCP server if possible
Notion not appearing in Microsoft Copilot Studio
Symptoms: Server not listed, Tools not available
Cause: Configuration or installation issue
Solution:
- Verify configuration syntax
- Check Notion installation
- Restart Microsoft Copilot Studio
- Check logs for error messages
Next Steps
Now that Notion is integrated with Microsoft Copilot Studio:
- Explore all Notion capabilities through Microsoft Copilot Studio
- Check out other MCP servers that work with Microsoft Copilot Studio
- Join the MCP community for tips and support
- Consider contributing to Notion development
Need Help?
- Search for Notion documentation
- Check the Microsoft Copilot Studio MCP guide
- Join the MCP community discussions