How to integrate Share point MCP with Google ADK

Connect Google ADK to Share point MCP. Create a new project folder in sharepoint, add a task item to the marketing list, and more using natural language, with authentication handled for you.

Share point logoShare point
Oauth2S2s Oauth2

SharePoint is a Microsoft platform for secure document management and team collaboration. It helps organizations store, organize, and share content efficiently.

146 Tools

Introduction

This guide walks you through connecting Share point to Google ADK using the Composio tool router. By the end, you'll have a working Share point agent that can manage lists and list items, upload and organize files, search across sites, publish site pages, and create sharing links through natural language commands.

This guide will help you understand how to give your Google ADK agent real control over a Share point account through Composio's Share point MCP server.

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

Also integrate Share point with

TL;DR

Here's what you'll learn:
  • Get a Share point account set up and connected to Composio
  • Install the Google ADK and Composio packages
  • Create a Composio Tool Router session for Share point
  • Build an agent that connects to Share point through MCP
  • Interact with Share point using natural language

What is Google ADK?

Google ADK (Agents Development Kit) is Google's framework for building AI agents powered by Gemini models. It provides tools for creating agents that can use external services through the Model Context Protocol.

Key features include:

  • Gemini Integration: Native support for Google's Gemini models
  • MCP Toolset: Built-in support for Model Context Protocol tools
  • Streamable HTTP: Connect to external services through streamable HTTP
  • CLI and Web UI: Run agents via command line or web interface

What is the Share point MCP server, and what's possible with it?

The Share point MCP server is an implementation of the Model Context Protocol that connects your AI agent and assistants like Claude, Cursor, etc directly to your SharePoint account. It provides structured and secure access to your SharePoint sites, so your agent can create folders, manage lists, handle users, and organize your team's content with ease.

  • Automated folder creation and organization: Instruct your agent to create new folders in SharePoint to keep your documents neatly organized by project, department, or workflow.
  • List and item management: Let your agent create new SharePoint lists for tracking tasks, issues, or inventory, and add items to lists automatically as your needs evolve.
  • User provisioning and access control: Quickly create new SharePoint users or remove existing ones, helping you manage team access and collaboration securely and efficiently.
  • User lookup and verification: Have your agent search for users across Microsoft Graph and SharePoint to confirm their existence and check their status in your organization.

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:

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

Step-by-step Guide

Step by step09 STEPS
1

Prerequisites

Before starting, make sure you have:
  • A Google API key for Gemini models
  • A Composio account and API key
  • Python 3.9 or later installed
  • Basic familiarity with Python
2

Getting API Keys for Google and Composio

Google API Key
  • Go to Google AI Studio and create an API key.
  • Copy the key and keep it safe. You will put this in GOOGLE_API_KEY.
Composio API Key and User ID
  • Log in to the Composio dashboard.
  • Go to Settings → API Keys and copy your Composio API key. Use this for COMPOSIO_API_KEY.
  • Decide on a stable user identifier to scope sessions, often your email or a user ID. Use this for COMPOSIO_USER_ID.
3

Install dependencies

bash
pip install google-adk composio python-dotenv

Inside your virtual environment, install the required packages.

What's happening:

  • google-adk is Google's Agents Development Kit
  • composio connects your agent to Share point via MCP
  • python-dotenv loads environment variables
4

Set up ADK project

bash
adk create my_agent

Set up a new Google ADK project.

What's happening:

  • This creates an agent folder with a root agent file and .env file
5

Set environment variables

bash
GOOGLE_API_KEY=your-google-api-key
COMPOSIO_API_KEY=your-composio-api-key
COMPOSIO_USER_ID=your-user-id-or-email

Save all your credentials in the .env file.

What's happening:

  • GOOGLE_API_KEY authenticates with Google's Gemini models
  • COMPOSIO_API_KEY authenticates with Composio
  • COMPOSIO_USER_ID identifies the user for session management
6

Import modules and validate environment

python
import os
import warnings

from composio import Composio
from dotenv import load_dotenv
from google.adk.agents.llm_agent import Agent
from google.adk.tools.mcp_tool.mcp_session_manager import StreamableHTTPConnectionParams
from google.adk.tools.mcp_tool.mcp_toolset import McpToolset

load_dotenv()

warnings.filterwarnings("ignore", message=".*BaseAuthenticatedTool.*")

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.")
What's happening:
  • os reads environment variables
  • Composio is the main Composio SDK client
  • GoogleProvider declares that you are using Google ADK as the agent runtime
  • Agent is the Google ADK LLM agent class
  • McpToolset lets the ADK agent call MCP tools over HTTP
7

Create Composio client and Tool Router session

python
composio_client = Composio(api_key=COMPOSIO_API_KEY)

composio_session = composio_client.create(
    user_id=COMPOSIO_USER_ID,
    toolkits=["share_point"],
)

COMPOSIO_MCP_URL = composio_session.mcp.url,
print(f"Composio MCP URL: {COMPOSIO_MCP_URL}")
What's happening:
  • Authenticates to Composio with your API key
  • Declares Google ADK as the provider
  • Spins up a short-lived MCP endpoint for your user and selected toolkit
  • Stores the MCP HTTP URL for the ADK MCP integration
8

Set up the McpToolset and create the Agent

python
composio_toolset = McpToolset(
    connection_params=StreamableHTTPConnectionParams(
        url=COMPOSIO_MCP_URL,
        headers={"x-api-key": COMPOSIO_API_KEY}
    )
)

root_agent = Agent(
    model="gemini-2.5-flash",
    name="composio_agent",
    description="An agent that uses Composio tools to perform actions.",
    instruction=(
        "You are a helpful assistant connected to Composio. "
        "You have the following tools available: "
        "COMPOSIO_SEARCH_TOOLS, COMPOSIO_MULTI_EXECUTE_TOOL, "
        "COMPOSIO_MANAGE_CONNECTIONS, COMPOSIO_REMOTE_BASH_TOOL, COMPOSIO_REMOTE_WORKBENCH. "
        "Use these tools to help users with Share point operations."
    ),
    tools=[composio_toolset],
)

print("\nAgent setup complete. You can now run this agent directly ;)")
What's happening:
  • Connects the ADK agent to the Composio MCP endpoint through McpToolset
  • Uses Gemini as the model powering the agent
  • Lists exact tool names in instruction to reduce misnamed tool calls
9

Run the agent

bash
# Run in CLI mode
adk run my_agent

# Or run in web UI mode
adk web

Execute the agent from the project root. The web command opens a web portal where you can chat with the agent.

What's happening:

  • adk run runs the agent in CLI mode
  • adk web . opens a web UI for interactive testing

Complete Code

Here's the complete code to get you started with Share point and Google ADK:

python
import os
import warnings

from composio import Composio
from composio_google import GoogleProvider
from dotenv import load_dotenv
from google.adk.agents.llm_agent import Agent
from google.adk.tools.mcp_tool.mcp_session_manager import StreamableHTTPConnectionParams
from google.adk.tools.mcp_tool.mcp_toolset import McpToolset

load_dotenv()
warnings.filterwarnings("ignore", message=".*BaseAuthenticatedTool.*")

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.")

composio_client = Composio(api_key=COMPOSIO_API_KEY, provider=GoogleProvider())

composio_session = composio_client.create(
    user_id=COMPOSIO_USER_ID,
    toolkits=["share_point"],
)

COMPOSIO_MCP_URL = composio_session.mcp.url


composio_toolset = McpToolset(
    connection_params=StreamableHTTPConnectionParams(
        url=COMPOSIO_MCP_URL,
        headers={"x-api-key": COMPOSIO_API_KEY}
    )
)

root_agent = Agent(
    model="gemini-2.5-flash",
    name="composio_agent",
    description="An agent that uses Composio tools to perform actions.",
    instruction=(
        "You are a helpful assistant connected to Composio. "
        "You have the following tools available: "
        "COMPOSIO_SEARCH_TOOLS, COMPOSIO_MULTI_EXECUTE_TOOL, "
        "COMPOSIO_MANAGE_CONNECTIONS, COMPOSIO_REMOTE_BASH_TOOL, COMPOSIO_REMOTE_WORKBENCH. "
        "Use these tools to help users with Share point operations."
    ),  
    tools=[composio_toolset],
)

print("\nAgent setup complete. You can now run this agent directly ;)")

Conclusion

You've successfully integrated Share point with the Google ADK through Composio's MCP Tool Router. Your agent can now interact with Share point using natural language commands.

Key takeaways:

  • The Tool Router approach dynamically routes requests to the appropriate Share point tools
  • Environment variables keep your credentials secure and separate from code
  • Clear agent instructions reduce tool calling errors
  • The ADK web UI provides an interactive interface for testing and development

You can extend this setup by adding more toolkits to the toolkits array in your session configuration.

TOOLS

Supported Tools

Every Share point action and event your agent gets out of the box.

Add Attachment to List Item

Tool to add an attachment to a SharePoint list item.

Add Default View Field

Add one existing field to a SharePoint list's default view.

Add Field Link to Content Type

Tool to add a field link to a list content type.

Add Role Assignment to Document by Path

Add a SharePoint role assignment to a file or folder selected by server-relative path after role inheritance has been broken.

Add Role Assignment to List Item

Tool to add a role assignment to a list item.

Add Role Assignment to SharePoint List

Tool to add a role assignment to a SharePoint list.

Break Role Inheritance on List Item

Tool to break permission inheritance on a list item.

Break Role Inheritance on List

Breaks permission inheritance on a SharePoint list, allowing you to set unique permissions.

Check In SharePoint File

Tool to check in a file.

Check Out SharePoint Site Page

Check out a modern SharePoint page by its positive Site Pages list-item ID.

Clear Default View Fields

Remove every field from a SharePoint list's default view without deleting the fields themselves.

Configure SharePoint List View

Update a SharePoint list view's title, CAML query, row limit, or visible fields, then read back the resulting configuration.

Copy Drive Item

Start an asynchronous copy of a drive item and return Microsoft's monitor URL.

Create Content Type

Creates a SharePoint site content type with a name and optional description, group, and ID for use with lists or libraries.

Create Drive Folder by Path

Create a folder beneath a path-addressed parent in a SharePoint document-library drive.

Create Drive Item Sharing Link

Tool to create a sharing link for a drive item in SharePoint or OneDrive.

Create SharePoint List Field

Tool to create a new field (column) in a SharePoint list.

Create SharePoint List Field from XML

Create a SharePoint list field from native Field XML and AddFieldOptions flags.

Create SharePoint List Item by GUID

Tool to create a new item in a SharePoint list using the list's GUID.

Create List Item in Folder

Tool to create a list item in a specific folder within a SharePoint list.

Create SharePoint List View

Create a view in a SharePoint list selected by GUID or exact title.

Create SharePoint Navigation Child

Create a child link beneath an existing SharePoint navigation node.

Create Quick Launch Node

Add a navigation link to the selected SharePoint site's Quick Launch collection.

Create SharePoint Site Collection

Start provisioning a modern communication or non-group team site collection and return its initial provisioning status; status 1 is not yet ready.

Create SharePoint Site Field

Create a reusable web-level SharePoint field (site column) in the selected site.

Create SharePoint Site Field from XML

Create a reusable site-scoped SharePoint field from complete field schema XML.

Create Unpublished SharePoint Article Page

Create an unpublished Article-layout modern SharePoint site page draft.

Create Drive Upload Session

Create a resumable upload session for a new file and return its preauthenticated upload URL.

Create SharePoint Subsite

Tool to create a new SharePoint subsite under the current site.

Delete SharePoint Drive Item

Move a drive item selected by drive and item IDs to the SharePoint recycle bin.

Delete Drive Item Version Content

Tool to delete content for a specific version of a drive item in SharePoint.

Delete SharePoint File

Delete a SharePoint document library file by server-relative path.

Delete SharePoint Folder

Deletes a SharePoint document library folder by its server-relative path.

Delete SharePoint List

Tool to delete a SharePoint list.

Delete SharePoint List By Title

Tool to delete a SharePoint list by its title.

Delete SharePoint List Field

Delete one field, identified by canonical field GUID, from an explicitly selected SharePoint list.

Delete SharePoint List Item

Tool to delete a SharePoint list item.

Delete Multiple SharePoint List Items

Tool to delete multiple SharePoint list items in bulk.

Delete Recycle Bin Item Permanently

Tool to permanently delete a SharePoint Recycle Bin item.

Download File by Server-relative URL

Tool to download a file by server-relative URL.

Ensure SharePoint User

Ensure a user exists in a SharePoint site using a login name or email, returning their user information.

Follow SharePoint Actor

Follow a SharePoint user, document, site, or tag.

Get All SharePoint Folders

Retrieves folders from a SharePoint web for site discovery.

Get SharePoint List Changes

Tool to retrieve changes from SharePoint list change log.

Get Content Type

Retrieves a SharePoint site content type by ID, including its metadata and available form properties.

Get Site Content Types

Retrieves all content types from the current SharePoint site.

Get Content Types for List

Tool to retrieve all content types for a specific SharePoint list by GUID.

Get SharePoint Context Info

Tool to retrieve SharePoint context information including the form digest value.

Get Current SharePoint User

Tool to retrieve the current user for the site.

Get Current User OneDrive

Resolve and return the connected user's default OneDrive using delegated authentication.

Get Default Drive Root

Get the root drive item of a SharePoint site's default document library.

Get Drive by ID

Get one SharePoint or OneDrive drive by its drive ID from the selected site endpoint.

Get Drive Item Analytics

Tool to get analytics for a SharePoint drive item.

Get Drive Item by ID

Get metadata for one file or folder by drive ID and item ID from a SharePoint site or provider-derived OneDrive for Business personal-site URL.

Get Drive Item by Path

Get a file or folder from a site's default document library by its drive-root-relative path.

Get Drive Item Changes

Return one page of drive-item changes and the opaque next or delta link.

Get Drive Item Thumbnails by Path

Retrieve thumbnail URL and dimension sets for a default-drive item by path.

Get Group Users

Lists users in a SharePoint group by name, returning a page of user information.

Get Group Users By ID

Lists users in a SharePoint site group by numeric group ID, returning a page of user information.

Download List Item Attachment

Tool to download an attachment from a SharePoint list item.

Get SharePoint List by GUID

Tool to retrieve a SharePoint list by its GUID.

Get SharePoint List By Title

Tool to retrieve a SharePoint list by its title.

Get Content Type by ID

Retrieves a SharePoint list content type by list ID and content type ID, returning its metadata and any schema or fields supplied in the response.

Get SharePoint List Field

Get one field definition from a SharePoint list by field GUID or exact internal name/title.

Get List Item by ID

Tool to retrieve a SharePoint list item by ID.

Get SharePoint List Items

Tool to retrieve items from a SharePoint list.

Get SharePoint List Items by GUID

Tool to retrieve items from a SharePoint list using its GUID.

Get List Item Version

Tool to retrieve a specific version of a SharePoint list item.

Get Followed Entities

Tool to get entities the current user is following.

Get My Followers

Retrieves the list of users who are following the authenticated user in SharePoint.

Get Role Definitions

Tool to list role definitions at the web level.

Get Shared Item

Access a shared SharePoint file or folder by share ID or encoded sharing URL without granting lasting access.

Get SharePoint Site by Hostname

Retrieve SharePoint site information by hostname or URL.

Get SharePoint Site by ID

Retrieve metadata for a SharePoint site web by its GUID within the selected site collection, such as its title, URL, language, or template information.

Get SharePoint Site Collection Info

Fetch metadata for the selected SharePoint site collection, including its URL, ID, and root web information.

Get Site Drive Item by Path

Tool to retrieve a file or folder by its server-relative path in a SharePoint site.

Get SharePoint Site Field

Retrieve one web-scoped SharePoint field by its GUID.

Get SharePoint Site Page Content

Tool to retrieve modern SharePoint Site Pages content by reading list item fields.

Get SharePoint Root Site

Retrieves metadata about the root web of a SharePoint site collection.

Get SharePoint Site Time Zone

Get the regional time-zone definition for a selected SharePoint site.

Get User Effective Permissions on Web

Get a user's effective permissions on the current SharePoint site (Web).

Get SharePoint Webhook Subscription

Tool to retrieve a specific webhook subscription by ID from a SharePoint list.

Get SharePoint Webhook Subscriptions

Tool to retrieve all webhook subscriptions on a SharePoint list.

Get SharePoint Web Info

Tool to retrieve information about the current SharePoint web (site) using REST API.

Check Follow Status

Tool to check if the current user is following a specified actor.

List SharePoint Lists

Retrieves all lists in the current SharePoint web/site.

List Default View Fields

List the field internal names currently displayed in a SharePoint list's default view.

List Drive Children

List a page of files and folders in a SharePoint drive's root or a specified folder using REST API v2.

List Drive Item Permissions

List effective sharing permissions for one drive item.

List Drive Item Versions

List retained versions of a SharePoint drive item, newest first.

List Recently Modified Drive Items

List recently modified files and folders in a SharePoint drive's root, ordered by modification time.

List Drives via SharePoint REST API

Tool to retrieve drives using SharePoint REST API v2.

List Files in Folder

List files directly within a SharePoint folder by server-relative path, without recursively enumerating subfolders.

List Item Attachments

Tool to list all attachments for a SharePoint list item.

List SharePoint List Columns

List column definitions for a SharePoint list.

List SharePoint List Views

List saved views for a SharePoint list selected by GUID or exact title, with optional OData projection, filtering, sorting, and offset pagination.

List SharePoint Media Transcripts

List transcript metadata for a media item in the selected SharePoint site's or explicit OneDrive personal site's default drive, without downloading transcript content.

List SharePoint Navigation Children

List child navigation nodes beneath a specified SharePoint navigation node.

List SharePoint Quick Launch Navigation

List a site's SharePoint Quick Launch navigation nodes.

List Recycle Bin Items

Tool to list items in the SharePoint Recycle Bin.

List Scoped Role Assignments

List a page of principals and expanded permission-level bindings on a SharePoint list or list item.

List Site Drives

List a page of document libraries (drives) accessible in a SharePoint site, including default and custom libraries.

List SharePoint Site Fields

List reusable web-level SharePoint fields (site columns).

List Site Groups

Tool to list SharePoint site groups for a site collection.

List SharePoint Site Pages

List one provider page of modern SharePoint site pages, optionally filtering or selecting fields.

List SharePoint Sites

Search for SharePoint sites accessible to the user.

List Site Users

Tool to list users in the site collection.

List Subfolders in Folder

Tool to list immediate child folders within a SharePoint folder.

List Web Role Assignments

List principals assigned SharePoint permission levels on a web/site, including each principal and its bound role definitions.

Log SharePoint Event

Log a SharePoint usage analytics event for a user activity, such as a document view, edit, or custom interaction, for usage reporting.

Move SharePoint Item by Path

Move an existing SharePoint file or folder to a new server-relative path.

Publish SharePoint Site Page

Publish the latest version of a modern SharePoint site page by its positive item ID.

Query SharePoint List Items With CAML

Execute a CAML query against a SharePoint list and return native list-item records.

Recycle SharePoint File

Tool to move a file to the Recycle Bin.

Recycle SharePoint List Item

Tool to move a list item to the Recycle Bin.

Redeem Shared Item Access

Redeem a SharePoint sharing link and grant the connected account durable access to the shared file or folder.

Rename SharePoint Folder

Renames a SharePoint folder by updating its list item metadata.

Render List Data As Stream

Retrieve list items from SharePoint with rich metadata and formatting.

Resolve SharePoint Sharing Link

Resolve a SharePoint sharing URL or provider share token to its underlying drive item.

Restore Drive Item Version

Tool to restore a previous version of a SharePoint drive item.

Restore Recycle Bin Item

Tool to restore a SharePoint Recycle Bin item.

Search Files Across All Sites

Search for files across all SharePoint sites and OneDrive using Keyword Query Language.

Search SharePoint Site

Search SharePoint content using Keyword Query Language (KQL).

Search Suggest

Tool to get search query suggestions.

Check Out SharePoint File

Tool to check out a file in a document library.

Create SharePoint Folder

Create a folder in a SharePoint document library and return its server-relative URL; if the folder already exists, the action can return the existing folder instead.

Create SharePoint List

Creates a SharePoint list from a specified template, name, and optional description.

Create SharePoint List Item

Creates a new item in a SharePoint list selected by title.

Find SharePoint User

Look up a user in a SharePoint site by email and return available user details.

Remove SharePoint User

Removes a user from SharePoint.

Undo SharePoint File Checkout

Tool to undo a file checkout, discarding any changes made while checked out.

Update SharePoint Content Type

Tool to update a SharePoint content type's properties such as name, description, group, or hidden status.

Update Drive Item

Update a SharePoint file or folder's name or title by server-relative path.

Update File Item Metadata

Tool to update metadata fields on a SharePoint file item via its ListItemAllFields.

Update SharePoint List

Tool to update properties of an existing SharePoint list.

Update SharePoint List Field

Update one or more mutable properties of an existing SharePoint list field identified by list and field GUID.

Update SharePoint List Item

Update fields on an existing SharePoint list item via MERGE.

Manage SharePoint List View Fields

Add, move, or remove all fields in one SharePoint list view selected by GUID or title.

Update SharePoint Site

Tool to update properties of the current SharePoint site (web).

Update Site Drive Item

Rename or move a SharePoint site drive item, or set its client file-system timestamps, and return the updated item.

Update SharePoint Site Field

Update mutable properties of an existing SharePoint site field by GUID, changing reusable web-level schema for the selected site.

Upload File to Folder

Tool to upload a file to a SharePoint document library or folder.

Upload File from URL to SharePoint

Fetch a file from a URL and upload it to SharePoint.

Upload Large File

Create a direct-v2 upload session and upload one file in sequential chunks.

Validate and Update Document Fields

Validate and commit document-library field values for a SharePoint file.

Validate SharePoint Credentials

Validate SharePoint credentials by attempting to retrieve the current user information.

FAQ

Frequently asked questions

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

Yes, you can. Google ADK 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 Share point tools.

Yes, absolutely. You can configure which Share point 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 Share point data and credentials are handled as safely as possible.

Start with Share point.It takes 30 seconds.

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

Start building