How to integrate One drive MCP with CrewAI

Connect CrewAI to One drive MCP. Share project folder with your team, download the latest version of report.docx, and more using natural language, with authentication handled for you.

Get started for free Get a demo

One drive

Oauth2S2s Oauth2

OneDrive is Microsoft’s cloud storage for storing, syncing, and sharing files across devices. Access your files securely anywhere with real-time collaboration and offline support.

93 Tools9 Triggers

Managed auth

Connect One drive without auth hassles

We manage OAuth, API keys, token refresh, and scopes — you just build.

Book a call

Explore the MCP Gateway

Introduction

This guide walks you through connecting One drive to CrewAI using the Composio tool router. By the end, you'll have a working One drive agent that can share project folder with your team, download the latest version of report.docx, check who can access budget.xlsx through natural language commands.

This guide will help you understand how to give your CrewAI agent real control over a One drive account through Composio's One drive MCP server.

Before we dive in, let's take a quick look at the key ideas and tools involved.

TL;DR

Here's what you'll learn:

Get a Composio API key and configure your One drive connection
Set up CrewAI with an MCP enabled agent
Create a Tool Router session or standalone MCP server for One drive
Build a conversational loop where your agent can execute One drive operations

What is CrewAI?

CrewAI is a powerful framework for building multi-agent AI systems. It provides primitives for defining agents with specific roles, creating tasks, and orchestrating workflows through crews.

Key features include:

Agent Roles: Define specialized agents with specific goals and backstories
Task Management: Create tasks with clear descriptions and expected outputs
Crew Orchestration: Combine agents and tasks into collaborative workflows
MCP Integration: Connect to external tools through Model Context Protocol

What is the One drive MCP server, and what's possible with it?

The OneDrive MCP server is an implementation of the Model Context Protocol that connects your AI agent and assistants like Claude, Cursor, etc directly to your OneDrive account. It provides structured and secure access to your files, folders, sharing settings, activity history, and Excel workbooks, so your agent can inspect, copy, share, track, and manage content on your behalf.

File and folder management: Have your agent inspect file details, copy content to another location, delete unwanted items, or permanently remove sensitive files.
Sharing and access control: Let the agent create sharing links, invite people to files or folders, review permissions, and revoke access when it is no longer needed.
Activity and version tracking: Direct your agent to review recent OneDrive activity, inspect changes to specific files, track root folder updates, and retrieve version history.
Excel workbook operations: Instruct your agent to open workbook sessions, inspect table contents, format spreadsheet ranges, and close sessions when the work is complete.
SharePoint content management: Have your agent read site details and page content, review or create list items, track list changes, inspect site columns, and manage list permissions.

What is the Composio tool router, and how does it fit here?

What is Composio SDK?

Composio's Composio SDK helps agents find the right tools for a task at runtime. You can plug in multiple toolkits (like Gmail, HubSpot, and GitHub), and the agent will identify the relevant app and action to complete multi-step workflows. This can reduce token usage and improve the reliability of tool calls. Read more here: Getting started with Composio SDK

The tool router generates a secure MCP URL that your agents can access to perform actions.

How the Composio SDK works

The Composio SDK follows a three-phase workflow:

Discovery: Searches for tools matching your task and returns relevant toolkits with their details.
Authentication: Checks for active connections. If missing, creates an auth config and returns a connection URL via Auth Link.
Execution: Executes the action using the authenticated connection.

Step-by-step Guide

Step by step08 STEPS

Prerequisites

Before starting, make sure you have:

Python 3.9 or higher
A Composio account and API key
A One drive connection authorized in Composio
An OpenAI API key for the CrewAI LLM
Basic familiarity with Python

Getting API Keys for OpenAI and Composio

OpenAI API Key

Go to the OpenAI dashboard and create an API key. You'll need credits to use the models, or you can connect to another model provider.
Keep the API key safe.

Composio API Key

Log in to the Composio dashboard.
Navigate to your API settings and generate a new API key.
Store this key securely as you'll need it for authentication.

Install dependencies

bash

pip install composio crewai crewai-tools[mcp] python-dotenv

What's happening:

composio connects your agent to One drive via MCP
crewai provides Agent, Task, Crew, and LLM primitives
crewai-tools[mcp] includes MCP helpers
python-dotenv loads environment variables from .env

Set up environment variables

bash

COMPOSIO_API_KEY=your_composio_api_key_here
USER_ID=your_user_id_here
OPENAI_API_KEY=your_openai_api_key_here

Create a .env file in your project root.

What's happening:

COMPOSIO_API_KEY authenticates with Composio
USER_ID scopes the session to your account
OPENAI_API_KEY lets CrewAI use your chosen OpenAI model

Import dependencies

python

import os
from composio import Composio
from crewai import Agent, Task, Crew
from crewai_tools import MCPServerAdapter
import dotenv

dotenv.load_dotenv()

COMPOSIO_API_KEY = os.getenv("COMPOSIO_API_KEY")
COMPOSIO_USER_ID = os.getenv("COMPOSIO_USER_ID")

if not COMPOSIO_API_KEY:
    raise ValueError("COMPOSIO_API_KEY is not set")
if not COMPOSIO_USER_ID:
    raise ValueError("COMPOSIO_USER_ID is not set")

What's happening:

CrewAI classes define agents and tasks, and run the workflow
MCPServerHTTP connects the agent to an MCP endpoint
Composio will give you a short lived One drive MCP URL

Create a Composio Tool Router session for One drive

python

composio_client = Composio(api_key=COMPOSIO_API_KEY)
session = composio_client.create(user_id=COMPOSIO_USER_ID, toolkits=["one_drive"])

url = session.mcp.url

What's happening:

You create a One drive only session through Composio
Composio returns an MCP HTTP URL that exposes One drive tools

Initialize the MCP Server

python

server_params = {
    "url": url,
    "transport": "streamable-http",
    "headers": {"x-api-key": COMPOSIO_API_KEY},
}

with MCPServerAdapter(server_params) as tools:
    agent = Agent(
        role="Search Assistant",
        goal="Help users search the internet effectively",
        backstory="You are a helpful assistant with access to search tools.",
        tools=tools,
        verbose=False,
        max_iter=10,
    )

What's Happening:

Server Configuration: The code sets up connection parameters including the MCP server URL, streamable HTTP transport, and Composio API key authentication.
MCP Adapter Bridge: MCPServerAdapter acts as a context manager that converts Composio MCP tools into a CrewAI-compatible format.
Agent Setup: Creates a CrewAI Agent with a defined role (Search Assistant), goal (help with internet searches), and access to the MCP tools.
Configuration Options: The agent includes settings like verbose=False for clean output and max_iter=10 to prevent infinite loops.
Dynamic Tool Usage: Once created, the agent automatically accesses all Composio Search tools and decides when to use them based on user queries.

Create a CLI Chatloop and define the Crew

python

print("Chat started! Type 'exit' or 'quit' to end.\n")

conversation_context = ""

while True:
    user_input = input("You: ").strip()

    if user_input.lower() in ["exit", "quit", "bye"]:
        print("\nGoodbye!")
        break

    if not user_input:
        continue

    conversation_context += f"\nUser: {user_input}\n"
    print("\nAgent is thinking...\n")

    task = Task(
        description=(
            f"Conversation history:\n{conversation_context}\n\n"
            f"Current request: {user_input}"
        ),
        expected_output="A helpful response addressing the user's request",
        agent=agent,
    )

    crew = Crew(agents=[agent], tasks=[task], verbose=False)
    result = crew.kickoff()
    response = str(result)

    conversation_context += f"Agent: {response}\n"
    print(f"Agent: {response}\n")

What's Happening:

Interactive CLI Setup: The code creates an infinite loop that continuously prompts for user input and maintains the entire conversation history in a string variable.
Input Validation: Empty inputs are ignored to prevent processing blank messages and keep the conversation clean.
Context Building: Each user message is appended to the conversation context, which preserves the full dialogue history for better agent responses.
Dynamic Task Creation: For every user input, a new Task is created that includes both the full conversation history and the current request as context.
Crew Execution: A Crew is instantiated with the agent and task, then kicked off to process the request and generate a response.
Response Management: The agent's response is converted to a string, added to the conversation context, and displayed to the user, maintaining conversational continuity.

Complete Code

Here's the complete code to get you started with One drive and CrewAI:

python

from crewai import Agent, Task, Crew, LLM
from crewai_tools import MCPServerAdapter
from composio import Composio
from dotenv import load_dotenv
import os

load_dotenv()

GOOGLE_API_KEY = os.getenv("GOOGLE_API_KEY")
COMPOSIO_API_KEY = os.getenv("COMPOSIO_API_KEY")
COMPOSIO_USER_ID = os.getenv("COMPOSIO_USER_ID")

if not GOOGLE_API_KEY:
    raise ValueError("GOOGLE_API_KEY is not set in the environment.")
if not COMPOSIO_API_KEY:
    raise ValueError("COMPOSIO_API_KEY is not set in the environment.")
if not COMPOSIO_USER_ID:
    raise ValueError("COMPOSIO_USER_ID is not set in the environment.")

# Initialize Composio and create a session
composio = Composio(api_key=COMPOSIO_API_KEY)
session = composio.create(
    user_id=COMPOSIO_USER_ID,
    toolkits=["one_drive"],
)
url = session.mcp.url

# Configure LLM
llm = LLM(
    model="gpt-5",
    api_key=os.getenv("OPENAI_API_KEY"),
)

server_params = {
    "url": url,
    "transport": "streamable-http",
    "headers": {"x-api-key": COMPOSIO_API_KEY},
}

with MCPServerAdapter(server_params) as tools:
    agent = Agent(
        role="Search Assistant",
        goal="Help users with internet searches",
        backstory="You are an expert assistant with access to Composio Search tools.",
        tools=tools,
        llm=llm,
        verbose=False,
        max_iter=10,
    )

    print("Chat started! Type 'exit' or 'quit' to end.\n")

    conversation_context = ""

    while True:
        user_input = input("You: ").strip()

        if user_input.lower() in ["exit", "quit", "bye"]:
            print("\nGoodbye!")
            break

        if not user_input:
            continue

        conversation_context += f"\nUser: {user_input}\n"
        print("\nAgent is thinking...\n")

        task = Task(
            description=(
                f"Conversation history:\n{conversation_context}\n\n"
                f"Current request: {user_input}"
            ),
            expected_output="A helpful response addressing the user's request",
            agent=agent,
        )

        crew = Crew(agents=[agent], tasks=[task], verbose=False)
        result = crew.kickoff()
        response = str(result)

        conversation_context += f"Agent: {response}\n"
        print(f"Agent: {response}\n")

Conclusion

You now have a CrewAI agent connected to One drive through Composio's Tool Router. The agent can perform One drive operations through natural language commands.

Next steps:

Add role-specific instructions to customize agent behavior
Plug in more toolkits for multi-app workflows
Chain tasks for complex multi-step operations

TOOLS & TRIGGERS

Supported Tools and Triggers

Every One drive action and event your agent gets out of the box.

Add Workbook Worksheet

Adds a new worksheet to an existing Excel workbook in OneDrive or SharePoint.

Check In Drive Item

Tool to check in a checked out driveItem resource, making the version of the document available to others.

Checkout Drive Item

Tool to check out a driveItem to prevent others from editing it and make your changes invisible until checked in.

Clear Workbook Range

Clears values, formats, or both from a worksheet range in an Excel workbook stored in OneDrive or SharePoint without deleting cells or shifting neighboring data.

Close Workbook Session

Close an Excel workbook session without deleting the workbook.

Copy Item

Tool to copy a DriveItem (file or folder) to a new location asynchronously.

Create Drive Item Permission

Tool to create a new permission on a OneDrive drive item.

Create Sharing Link

Tool to create a sharing link for a DriveItem (file or folder) by its unique ID.

Create SharePoint List Item

Create an item in a SharePoint list using Microsoft Graph through the OneDrive connection.

Create Workbook Session

Create a persistent or temporary session for an Excel workbook.

Delete Item

Tool to delete a DriveItem (file or folder) by its unique ID from the authenticated user's OneDrive.

Permanently Delete Drive Item

Tool to permanently delete a driveItem by its ID without moving it to the recycle bin.

Delete Drive Item Permission

Tool to delete a permission from a drive item.

Delete Shares Permission

Tool to delete the permission navigation property for a shared drive item.

Delete SharePoint Item Permission

Revoke a Microsoft Graph beta permission from a SharePoint list or list item.

Delete Workbook Range

Deletes a range of cells from a worksheet in an Excel workbook stored in OneDrive.

Delete Workbook Worksheet

Deletes a worksheet from a workbook in OneDrive by its ID or name.

Discard Checkout

Tool to discard the checkout of a driveItem, releasing it and discarding any changes made while checked out.

Download a file

Downloads a file from a user's OneDrive using its item ID, which must refer to a file and not a folder.

Download file by path

Downloads the contents of a file from OneDrive by its path.

Download item as format

Tool to download the contents of a driveItem converted to a specific format (e.

Download Drive Item Version Content

Tool to download the contents of a specific previous version of a drive item (file).

Download Thumbnail by Path

Download thumbnail image bytes for a path-addressed item in the current user's OneDrive.

Follow Drive Item

Tool to follow a driveItem (file or folder) in OneDrive or SharePoint.

Format Workbook Range

Apply dimensions, alignment, wrapping, font, fill, and borders to a workbook range.

Get document comments

Extracts comments from a Word .

Get Drive

Retrieves the properties and relationships of a Drive resource by its unique ID.

Get DriveItem by Sharing URL

Tool to resolve a OneDrive/SharePoint sharing URL (or shareId) to a DriveItem with driveId and itemId.

Get Drive Item List Item

Retrieve the SharePoint list item associated with a driveItem.

Get Drives Following

Tool to retrieve a specific followed driveItem from a drive.

Get Group Drive

Tool to retrieve the document library (drive) for a Microsoft 365 group.

Get Item Metadata

Retrieves the metadata of a DriveItem by its unique ID.

Get Item by Path

Retrieve OneDrive or SharePoint driveItem metadata by drive-relative path.

Get Item Permissions

Retrieves the permissions of a DriveItem by its unique ID within a specific Drive.

Get Item Thumbnails

Tool to retrieve the thumbnails associated with a DriveItem.

Get Item Versions

Tool to retrieve the version history of a DriveItem by its unique ID.

Get Drive Root Folder

Tool to retrieve metadata for the root folder of the signed-in user's OneDrive.

Get Shared Item by ShareId

Tool to access a shared DriveItem or collection of shared items using a shareId or encoded sharing URL.

Get SharePoint List Items

Tool to get the items (list items) within a specific SharePoint list on a site.

Get Site Details

Retrieves metadata for a specific SharePoint site by its ID.

Get SharePoint Site Page Content

Gets the content of a modern SharePoint site page.

Get Drive Special Folder

Tool to retrieve a special folder in OneDrive by name.

Get User Profile

Retrieves the properties and profile information for a specific Microsoft user by their user ID or user principal name.

Get Workbook Range Fill

Read the fill color applied to an Excel worksheet range.

Get Workbook Used Range

Retrieves the used range of a worksheet in an Excel workbook stored in OneDrive or SharePoint without requiring the caller to know an explicit A1 range address.

Get Workbook Worksheet

Retrieves a specific worksheet from an Excel workbook stored in OneDrive or SharePoint using Microsoft Graph API.

Grant Shares Permission

Tool to grant users access to a link represented by a permission using an encoded sharing URL.

Grant SharePoint Item Permission

Grant an application permission on a SharePoint list or list item using Microsoft Graph beta.

Inspect Workbook Table

Read a workbook table's occupied range and one page of its columns.

Invite User to Drive Item

Tool to invite users or grant permissions to a specific item in a OneDrive drive.

List Drive Activities

Tool to retrieve recent activities on the authenticated user's OneDrive.

List All Drive Items

Lists a complete OneDrive or SharePoint drive safely, one Microsoft Graph delta page per invocation.

List Drive Bundles

Tool to retrieve a list of bundle resources from a specified drive.

List Drives

Tool to retrieve a list of Drive resources available to the authenticated user, or for a specific user, group, or site.

List Folder Children

List the direct children (files/folders) of a OneDrive/SharePoint folder by DriveItem ID or path.

List Drive Item Activities

Tool to list recent activities for a specific item in a OneDrive drive.

List OneDrive Shared Items

List files shared from other people's OneDrive accounts using Microsoft Graph Search match-all and a OneDrive-personal URL heuristic.

List Root Drive Changes

Tool to list changes in the root of the user's primary drive using a delta token.

List Shares Permission

Tool to retrieve permission details for a shared OneDrive or SharePoint item using a share ID.

List SharePoint Item Permissions

List Microsoft Graph beta permissions from a SharePoint list or list item.

List SharePoint List Items Delta

Tool to track changes to items in a SharePoint list using a delta query.

List Site Columns

Tool to list all column definitions for a SharePoint site.

List Site Drive Items Delta

Tool to track changes to DriveItems in the default document library of a SharePoint site.

List Site Lists

Tool to list all lists under a specific SharePoint site.

List Site Recycle Bin Items

Return one page of deleted items from a SharePoint site's recycle bin.

List Site Subsites

Tool to list all subsites of a SharePoint site.

List Subscriptions

Tool to list the current subscriptions for the authenticated user or app.

List Workbook Worksheets

Retrieves a list of all worksheets in an Excel workbook stored in OneDrive or SharePoint.

Move Item

Tool to move a file or folder to a new parent folder in OneDrive.

Create folder

Creates a new folder in the user's OneDrive with configurable conflict behavior, optionally within a specified parent_folder (by ID or full path from root) which, if not the root, must exist and be accessible.

Create a new text file

Creates a new plain-text file with specified content in the authenticated user's personal OneDrive, using either the folder's unique ID or its absolute path relative to the user's OneDrive root (paths are automatically resolved to IDs); note that OneDrive may rename or create a new version if the filename already exists.

Find Item

Non-recursively finds an item (file or folder) in a specified OneDrive folder; if `folder` is provided as a path, it must actually exist.

Find Folder

Finds folders by name within an accessible parent folder in OneDrive, or lists all its direct child folders if no name is specified.

List OneDrive items

Retrieves one page of files and folders as `driveItem` resources from the root of a specified user's OneDrive.

Upload file

Uploads a file to a specified OneDrive folder, automatically creating the destination folder if it doesn't exist, renaming on conflict, and supporting large files via chunking.

Preview Drive Item

Generates or retrieves a short-lived, permission-bound embeddable URL for a preview of a specific item.

Read Workbook Range

Reads a range of cells from an Excel workbook worksheet stored in OneDrive or SharePoint using Microsoft Graph API.

Restore Deleted Item

Tool to restore a deleted OneDrive driveItem (file or folder) from the recycle bin.

Restore Item Version

Restores a previous version of a DriveItem (file) by creating a new version with the content of the specified version.

Search Drive Items

Search OneDrive and accessible SharePoint files with Microsoft Graph Search.

Search Items

Search OneDrive for files and folders by keyword.

Search SharePoint Sites

Search SharePoint sites visible to an organizational Microsoft account.

Track Folder Changes

Track changes beneath one folder, one Microsoft Graph delta page at a time.

Delete Drive Following

Tool to unfollow a driveItem by removing it from the user's followed items collection.

Update Drive Item Metadata

Tool to update the metadata of a specific item (file or folder) in OneDrive.

Update Drive Item Permissions

Tool to update the roles of an existing permission on a OneDrive drive item.

Update File Content

Tool to update an existing file's content in OneDrive.

Update SharePoint Item Permission

Update an application permission on a SharePoint list or list item using Microsoft Graph beta.

Update SharePoint List Item Fields

Update field values on a SharePoint list item using Microsoft Graph through the OneDrive connection.

Update Table Column Range

Update values, formulas, number formats, or row and column visibility in a table column's whole or data-body range.

Update Workbook Range

Updates a range in a workbook worksheet using Microsoft Graph API.

Update Workbook Worksheet

Updates properties of a worksheet in an Excel workbook stored in OneDrive.

Write Workbook Cell

Updates the value, formula, or format of a specific cell in an Excel workbook stored in OneDrive.

FRAMEWORKS

How to build One drive MCP Agent with another framework

Claude Code

Use One drive MCP with Claude Code

Cursor

Use One drive MCP with Cursor

ChatGPT

Use One drive MCP with ChatGPT

Claude Cowork

Use One drive MCP with Claude Cowork

Antigravity

Use One drive MCP with Antigravity

OpenAI Agents SDK

Use One drive MCP with OpenAI Agents SDK

Claude Agent SDK

Use One drive MCP with Claude Agent SDK

Grok Bot

Use One drive MCP with Grok Bot

Muse

Use One drive MCP with Muse

Codex

Use One drive MCP with Codex

Grok Build

Use One drive MCP with Grok Build

VS Code

Use One drive MCP with VS Code

OpenCode

Use One drive MCP with OpenCode

OpenClaw

Use One drive MCP with OpenClaw

Hermes

Use One drive MCP with Hermes

Atomic Agent

Use One drive MCP with Atomic Agent

Google ADK

Use One drive MCP with Google ADK

LangChain

Use One drive MCP with LangChain

Vercel AI SDK

Use One drive MCP with Vercel AI SDK

Mastra AI

Use One drive MCP with Mastra AI

LlamaIndex

Use One drive MCP with LlamaIndex

Pydantic AI

Use One drive MCP with Pydantic AI

AutoGen

Use One drive MCP with AutoGen

MORE TOOLKITS

Explore Other Toolkits

Toolkit marketplace

Google Drive

Oauth2

Google Drive is a cloud storage platform for uploading, sharing, and collaborating on files. It's perfect for keeping your documents accessible and organized across devices.

Google Docs

Oauth2

Google Docs is a cloud-based word processor that enables document creation and real-time collaboration. Its seamless sharing and version history make team editing and content management a breeze.

Google Super

Oauth2Api Key

Google Super is an all-in-one suite combining Gmail, Drive, Calendar, Sheets, Analytics, and more. It gives you a unified platform to manage your digital life, boosting productivity and organization.

ActiveMerge

Api Key

ActiveMerge is a document automation platform for generating documents, images, merged files, and e-signature workflows. It helps teams turn templates and stored files into finished, shareable documents faster.

FAQ

Frequently asked questions

With a standalone One drive MCP server, the agents and LLMs can only access a fixed set of One drive tools tied to that server. However, with the Composio Tool Router, agents can dynamically load tools from One drive and many other apps based on the task at hand, all through a single MCP endpoint.

Yes, you can. CrewAI fully supports MCP integration. You get structured tool calling, message history handling, and model orchestration while Tool Router takes care of discovering and serving the right One drive tools.

Yes, absolutely. You can configure which One drive scopes and actions are allowed when connecting your account to Composio. You can also bring your own OAuth credentials or API configuration so you keep full control over what the agent can do.

All sensitive data such as tokens, keys, and configuration is fully encrypted at rest and in transit. Composio is SOC 2 Type 2 compliant and follows strict security practices so your One drive data and credentials are handled as safely as possible.

Start with One drive.It takes 30 seconds.

Managed auth, hosted MCP servers, and every One drive tool your agent needs.Free to start.

Start building

How to integrate One drive MCP with CrewAI

Connect One drive without auth hassles

Introduction

Also integrate One drive with

TL;DR

What is CrewAI?

What is the One drive MCP server, and what's possible with it?

What is the Composio tool router, and how does it fit here?

What is Composio SDK?

How the Composio SDK works

Step-by-step Guide

Prerequisites

Getting API Keys for OpenAI and Composio

Install dependencies

Set up environment variables

Import dependencies

Create a Composio Tool Router session for One drive

Initialize the MCP Server

Create a CLI Chatloop and define the Crew

Complete Code

Conclusion

Supported Tools and Triggers

How to build One drive MCP Agent with another framework

Claude Code

Cursor

ChatGPT

Claude Cowork

Antigravity

OpenAI Agents SDK

Claude Agent SDK

Grok Bot

Muse

Codex

Grok Build

VS Code

OpenCode

OpenClaw

Hermes

Atomic Agent

Google ADK

LangChain

Vercel AI SDK

Mastra AI

LlamaIndex

Pydantic AI

AutoGen

Explore Other Toolkits

Google Drive

Google Docs

Google Super

ActiveMerge

Frequently asked questions

What are the differences in Tool Router MCP and One drive MCP?+

Can I use Tool Router MCP with CrewAI?+

Can I manage the permissions and scopes for One drive while using Tool Router?+

How safe is my data with Composio Tool Router?+

Start with One drive.It takes 30 seconds.