Sign in Book a demo
Back to Tools
Productivity & Docs OAuth
Build Your Agent View SharePoint Docs
microsoft-sharepoint logo

Microsoft SharePoint MCP Tools for AI Agents

Let an agent find SharePoint sites and files, read Word documents and slides, update Excel cells, and create or organize content.

Available Tools

37 tools available in this integration

MicrosoftSharepoint.AddWorksheet

Add a new worksheet to a SharePoint Excel workbook.

MicrosoftSharepoint.CopyItem

Copy a file or folder.

MicrosoftSharepoint.CreateFolder

Create a new folder in a SharePoint drive.

MicrosoftSharepoint.CreatePresentation

Create a new PowerPoint presentation in a SharePoint drive.

MicrosoftSharepoint.CreateShareLink

Create a share link for a SharePoint drive item.

MicrosoftSharepoint.CreateSlide

Append a new slide to the end of an existing PowerPoint presentation in a SharePoint drive.

MicrosoftSharepoint.CreateTwoContentSlide

Append a TWO_CONTENT slide with side-by-side content areas to a SharePoint PowerPoint.

MicrosoftSharepoint.CreateWordDocument

Create a new Word document in a SharePoint drive.

MicrosoftSharepoint.CreateWorkbook

Create a new Excel workbook (.xlsx) in a SharePoint drive.

MicrosoftSharepoint.DeleteItem

Delete a file or folder from a SharePoint drive.

MicrosoftSharepoint.DeleteWorksheet

Delete a worksheet from a SharePoint Excel workbook.

MicrosoftSharepoint.GetAllSlideNotes

Get all speaker notes from every slide in a SharePoint PowerPoint presentation.

MicrosoftSharepoint.GetCopyStatus

Check status of an async copy operation using the token returned when it was started.

MicrosoftSharepoint.GetDrivesFromSite

Retrieve drives / document libraries from a SharePoint site.

MicrosoftSharepoint.GetItemsFromList

Retrieve items from a list in a SharePoint site.

MicrosoftSharepoint.GetListsFromSite

Retrieve lists from a SharePoint site.

MicrosoftSharepoint.GetPage

Retrieve metadata and the contents of a page in a SharePoint site.

MicrosoftSharepoint.GetPresentationAsMarkdown

Get the content of a PowerPoint presentation stored in a SharePoint drive as markdown.

MicrosoftSharepoint.GetSite

Retrieve information about a specific SharePoint site by its ID, URL, or name.

MicrosoftSharepoint.GetSlideNotes

Get the speaker notes from a specific slide in a SharePoint PowerPoint presentation.

MicrosoftSharepoint.GetWordDocument

Get a Word document's metadata and content from a SharePoint drive.

MicrosoftSharepoint.GetWorkbookMetadata

Get metadata about an Excel workbook in a SharePoint drive, including worksheet list.

MicrosoftSharepoint.GetWorksheetData

Read cell values from a worksheet in a SharePoint Excel workbook.

MicrosoftSharepoint.InsertTextAtEndOfWordDocument

Append text to the end of an existing Word document.

MicrosoftSharepoint.ListItemsInFolder

Retrieve items from a folder in a drive in a SharePoint site.

MicrosoftSharepoint.ListPages

Retrieve pages from a SharePoint site.

MicrosoftSharepoint.ListRootItemsInDrive

Retrieve items from the root of a drive in a SharePoint site.

MicrosoftSharepoint.ListSites

List all SharePoint sites accessible to the current user.

MicrosoftSharepoint.MoveItem

Move a file or folder to a new location in a SharePoint drive.

MicrosoftSharepoint.ReadFile

Read the text of a PDF or plain-text file in a SharePoint drive.

MicrosoftSharepoint.RenameWorksheet

Rename an existing worksheet in a SharePoint Excel workbook.

MicrosoftSharepoint.SearchDriveItems

Search for items in one or more Sharepoint drives.

MicrosoftSharepoint.SearchSites

Search for SharePoint sites by name or description.

MicrosoftSharepoint.SetSlideNotes

Set or update the speaker notes on a specific slide in a SharePoint PowerPoint.

MicrosoftSharepoint.UpdateCell

Update a single cell value in a SharePoint Excel workbook.

MicrosoftSharepoint.UpdateRange

Update multiple cells in a SharePoint Excel worksheet using sparse dict format.

MicrosoftSharepoint.WhoAmI

Get information about the current user and their SharePoint environment.

Why agent-optimized tools matter

Built for intent, not API schemas

Ask the agent to "find the latest project brief, summarize its decisions, and cite the source files." Arcade picks the right SharePoint actions without guessing site, drive, folder, or item identifiers.

Up to 100x fewer tokens

SharePoint searches and folder listings return file and folder metadata before the agent reads document text, spreadsheet cells, or presentation notes, so it can narrow the work without loading entire libraries into the model.

Complete the workflow end to end

Find the site, locate the library, read the source files, update the document or workbook, request approval, and create a share link through one toolkit designed around the complete SharePoint task.

Make actions predictable and controlled

Arcade tools return structured results and useful errors across users and runs. Teams can apply scope restrictions, redaction, and approval policies so agents follow the same controls every time.

Securing Microsoft SharePoint

The more capabilities agents get, the more useful they are. However, more capabilities bring more risks of undesired effects such as data loss and exfiltration.

This is why Arcade provides you with contextual rules that dictate how and when a tool is allowed to run. Arcade’s contextual access lets you govern tool visibility and behavior at every stage of execution and control who can see a tool, what inputs are allowed, and what comes back.

Learn about Contextual Access Policies

For Microsoft SharePoint, you can implement some of these policies:

Access when tools are listed for a user
  • Hide MicrosoftSharepoint.DeleteItem from agents unless the roles your IDP marks as SharePoint owners are active, so regular users cannot remove files or folders.
  • Restrict MicrosoftSharepoint.CreateShareLink to agents operating under your document-sharing role, so unapproved automation cannot expose internal files through new links.
  • Deny MicrosoftSharepoint.MoveItem to agents outside your content-management role, so they cannot move files into restricted or public folders.
Pre-execution before each tool call
  • Require human approval before MicrosoftSharepoint.UpdateRange changes a workbook used for financial, payroll, or production reporting, so an agent cannot overwrite multiple business-critical cells without review.
  • Block MicrosoftSharepoint.InsertTextAtEndOfWordDocument when the target document is marked legal, contractual, or approved, so an agent cannot append unreviewed language to a controlled record.
  • Require human approval before MicrosoftSharepoint.DeleteWorksheet runs, so an agent cannot remove a worksheet containing source data or audit history.
Post-execution after the tool returns
  • Redact MicrosoftSharepoint.GetWordDocument results by removing personal phone numbers, home addresses, access tokens, and secrets before the document content reaches the model.
  • Strip customer names, confidential project details, and speaker notes containing internal strategy from MicrosoftSharepoint.GetPresentationAsMarkdown results before the model sees the presentation.
  • Redact MicrosoftSharepoint.GetWorksheetData results by masking employee tax IDs, bank details, compensation, and other payroll fields before they reach the model.

How to use Microsoft SharePoint with your agent

Connect Microsoft SharePoint to your MCP client through Arcade, then authorize each user's SharePoint account. The walkthrough takes you from setup to your first site search or document update.

Your questions, answered

A Microsoft SharePoint MCP server exposes SharePoint sites, document libraries, lists, pages, files, Word documents, Excel workbooks, and PowerPoint presentations as structured tools an AI agent can call through the Model Context Protocol. After a user authorizes their account, the agent can perform the permitted read and write actions.

Microsoft SharePoint provides the underlying APIs and services, while Arcade hosts an integration built for agent use and adds per-user OAuth, approval workflows, response redaction, scope controls, and one MCP connection for supported clients.

Arcade agents can find sites, libraries, folders, files, lists, and pages; read Word, PDF, text, Excel, and PowerPoint content; create and update documents, workbooks, worksheets, slides, and speaker notes; move, copy, rename, and delete items; and create share links. They can also retrieve list items and inspect workbook and presentation metadata.

Each user grants access through their own Microsoft OAuth authorization. The granted SharePoint and Microsoft Graph permissions must cover the actions the agent performs: reading content for read workflows, write access for creating or updating files, and additional permissions for moving, sharing, or deleting items. Use the narrowest permissions that support the workflow.

Yes. Each user authorizes their own Microsoft account through OAuth. SharePoint actions run under that user's access, so the agent can reach only the sites, libraries, files, and permissions available to that user.

Yes. Contextual Access policies can require human approval before consequential SharePoint actions such as deleting files, changing workbook data, moving content, creating share links, or writing documents. The call proceeds only after the policy's conditions have been satisfied.

Arcade proxies SharePoint API calls and does not persist your content as part of normal tool execution. Where credentials are required, Arcade brokers them and stores them encrypted at rest, and the model never receives them.

Any framework or client that can connect to Arcade's MCP gateway or tool APIs works, including LangChain, OpenAI Agents, CrewAI, Claude Desktop, Claude Code, Cursor, Visual Studio Code, Microsoft Copilot Studio, and GitHub Copilot.

Arcade refreshes access while the user's Microsoft authorization remains valid. If it is revoked, rotated, or can no longer be refreshed, SharePoint calls stop until the user reconnects their account.

Microsoft Graph and SharePoint service throttling, tenant limits, and account permissions still apply to actions performed through Arcade. The available details do not define a separate Arcade quota, so plan for Microsoft service limits and handle throttled calls with retry and backoff logic.

Ready to actually ship your agent?

Connect your agent to Microsoft SharePoint with managed OAuth, agent-optimized tools and approval controls for consequential actions.

Build Your Agent Read the Microsoft SharePoint Quickstart