SharePoint Graph
SharePoint Graph uses Microsoft Graph to access SharePoint sites, lists, list items, document libraries, files, folders, and sharing capabilities.
Verdict
Common use cases
- Append vendor invoices to a shared Excel tracker
- Pull document metadata for compliance audits
- Add chart summaries to quarterly report workbooks
- Sync content type schemas across site collections
- Insert meeting notes into a SharePoint list
Integration
- Vendor
- SharePoint Graph
- Category
- docs
- Auth
- OAUTH2
- Tools
- 50
- Composio slug
sharepoint_graph
Tools
- Add Column To SharePoint Content Type
Add a column (column link) to a SharePoint site or list content type.
- Add Content Type Copy From Hub
Add a copy of a content type from the tenant content type hub to a SharePoint site or list.
- Add Content Type Copy To SharePoint List
Copy a site content type into a SharePoint list.
- Add SharePoint Workbook Chart
Add a chart to a worksheet in an Excel workbook stored in SharePoint.
- Add SharePoint Workbook Named Item
Add a named item at the workbook scope in an Excel workbook stored in SharePoint.
- Add SharePoint Workbook Table
Add a table to an Excel workbook stored in SharePoint.
- Add SharePoint Workbook Table Row
Add rows to an Excel workbook table stored in SharePoint.
- Add SharePoint Workbook Worksheet
Add a worksheet to an Excel workbook stored in SharePoint.
- Apply SharePoint Workbook Table Column Filter
Apply a filter to a column of an Excel workbook table stored in SharePoint.
- Assign Sensitivity Label To SharePoint Drive Item
Assign a Microsoft Purview sensitivity label to a SharePoint drive item.
- Check In SharePoint Drive Item
Check in a SharePoint drive item.
- Checkout SharePoint Drive Item
Checkout SharePoint Drive Item.
- Close SharePoint Workbook Session
Close an Excel workbook session.
- Copy SharePoint Drive Item
Start an asynchronous copy of a SharePoint drive item.
- Create Microsoft Graph Subscription
Create a Microsoft Graph webhook subscription.
- Create SharePoint Folder
Create a folder inside a SharePoint drive folder.
- Create SharePoint List
Create a SharePoint list.
- Create SharePoint List Column
Create a SharePoint list column definition.
- Create SharePoint List Item
Create a SharePoint list item.
- Create SharePoint Sharing Link
Create a sharing link for a SharePoint drive item.
- Create SharePoint Site Column
Create a SharePoint site column definition.
- Create SharePoint Site Content Type
Create a SharePoint site content type.
- Create SharePoint Site Page
Create a modern SharePoint site page.
- Create SharePoint Site Permission
Grant an application (Sites.Selected) permission on a SharePoint site.
- Create SharePoint Upload Session
Create an upload session for large SharePoint file uploads.
- Create SharePoint Workbook Session
Create an Excel workbook session for a workbook stored in SharePoint.
- Delete Microsoft Graph Subscriptiondestructive
Delete a Microsoft Graph webhook subscription.
- Delete SharePoint Drive Itemdestructive
Delete a SharePoint drive item.
- Delete SharePoint Drive Item Permissiondestructive
Delete a sharing permission from a SharePoint drive item.
- Delete SharePoint Drive Item Versiondestructive
Delete a SharePoint drive item version.
- Delete SharePoint Listdestructive
Delete a SharePoint list.
- Delete SharePoint List Columndestructive
Delete a SharePoint list column definition.
- Delete SharePoint List Content Typedestructive
Delete a SharePoint list content type.
- Delete SharePoint List Itemdestructive
Delete a SharePoint list item.
- Delete SharePoint Share Permissiondestructive
Revoke the sharing-link permission for a shared SharePoint or OneDrive item.
- Delete SharePoint Site Columndestructive
Delete a SharePoint site column definition.
- Delete SharePoint Site Content Typedestructive
Delete a SharePoint site content type.
- Delete SharePoint Site Pagedestructive
Delete a SharePoint site page.
- Delete SharePoint Site Permissiondestructive
Revoke an application (Sites.Selected) permission from a SharePoint site.
- Delete SharePoint Workbook Tabledestructive
Delete a table from an Excel workbook stored in SharePoint.
- Delete SharePoint Workbook Worksheetdestructive
Delete a worksheet in an Excel workbook stored in SharePoint.
- Discard SharePoint Drive Item Checkout
Discard SharePoint Drive Item Checkout.
- Download SharePoint Drive Item
Download a SharePoint drive item. The file is streamed to the file backend and the response returns a downloadable file, so large files are handled without exhausting memory.
- Download SharePoint Drive Item By Path
Download a SharePoint drive item by path. The file is streamed to the file backend and the response returns a downloadable file, so large files are handled without exhausting memory.
- Download SharePoint Drive Item Version
Download the binary content of an earlier (non-current) version of a file in a SharePoint document library. The version's bytes are streamed to the file backend and returned as a downloadable file, so large files are handled without exhaust
- Execute Microsoft Graph Batch
Execute a Microsoft Graph JSON batch request.
- Extract SharePoint Drive Item Sensitivity Labels
Extract the Microsoft Purview sensitivity labels currently applied to a SharePoint drive item.
- Follow SharePoint Sites
Follow one or more SharePoint sites for a user.
- Get All SharePoint Sites
Enumerate all SharePoint sites across geographies in the organization.
- Get SharePoint Content Type Column
Get a single column of a SharePoint site or list content type.
Setup
Setup guide
- 11. In Switchy, open Settings and navigate to Integrations, then click Connect next to SharePoint Graph. 2. You'll be redirected to Microsoft's OAuth consent screen; sign in with an account that has access to the SharePoint sites and workbooks you want Switchy to touch. 3. Review the requested permissions — typically Sites.ReadWrite.All, Files.ReadWrite.All, and possibly User.Read — then click Accept. 4. If your tenant requires admin consent for application permissions, forward the consent URL to your IT admin or follow your org's approval process. 5. Once approved, you'll return to Switchy and see SharePoint Graph listed as Connected. 6. Open any Project, type '@SharePoint Graph list the columns in the Contracts content type on site ProjectAlpha' and confirm it returns column names — that means the connection works.
What teammates see: by default, memories from SharePoint Graph are scoped to the Project (PROJECT visibility) - you can mark any memory PRIVATE or share it ORG-wide.
Works well with
Top models
Compatibility data appears once enough Projects have used this MCP together with a given model.
How Switchy teams use it
Starter prompts
Add Invoice Row
@SharePoint Graph add a row to the 'Invoices' table in the Q1_Financials.xlsx workbook on the Finance site. Vendor: Acme Corp, Amount: 4500, Date: 2025-01-15, Status: Pending.
List Site Content Types
@SharePoint Graph list all content types on the ProjectAlpha SharePoint site and show their column definitions.
Insert Worksheet Chart
@SharePoint Graph add a column chart to the 'Summary' worksheet in Sales_Report.xlsx on the Sales site. Use data from range A1:B12.
Copy Content Type to List
@SharePoint Graph copy the 'Contract' content type from the Legal site into the 'Active Agreements' list.
Add Named Range
@SharePoint Graph add a named item called 'TotalRevenue' pointing to cell D50 in the Budget.xlsx workbook on the Finance site.
Example outputs
Illustrative - representative of the model's voice and quality, not literal recordings.
@SharePoint Graph list all content types in the 'Product Documentation' site and show me which columns each one has
Found 4 content types in the Product Documentation site: 'Technical Spec' (columns: Title, Version, Author, Review Date, Status), 'User Guide' (columns: Title, Product Line, Last Updated, Audience), 'Release Notes' (columns: Title, Release Version, Date, Breaking Changes), and 'API Reference' (columns: Title, Endpoint, Method, Deprecated). The Technical Spec type is used by 23 documents, User Guide by 17, Release Notes by 31, and API Reference by 8.
This read-heavy example shows the MCP's ability to inspect SharePoint site structure and metadata schemas. Requires Sites.Read.All scope. Useful for auditing content organization before bulk operations, but column details may be truncated if custom columns exceed typical limits.
@SharePoint Graph add a new column called 'Compliance Review Date' (date type) to the 'Technical Spec' content type in our main documentation site
Successfully added column 'Compliance Review Date' (type: dateTime) to the 'Technical Spec' content type in site 'Main Documentation'. The column is now available for all documents using this content type. Note: Existing documents will show this field as empty until populated. The column has been configured as optional; you can update individual documents or use bulk operations to set values.
This write example demonstrates schema modification at the content-type level, which propagates to all documents using that type. Requires Sites.FullControl.All scope—a high-privilege operation. Changes are immediate and affect the entire site; test in a non-production site first if unsure about impact.
@SharePoint Graph find all Excel workbooks in the 'Q4 Planning' folder, then add a new worksheet called 'Budget Summary' to each one with columns for Department, Allocated, and Spent
Located 6 Excel workbooks in 'Q4 Planning': FY24_Marketing.xlsx, FY24_Engineering.xlsx, FY24_Sales.xlsx, FY24_Operations.xlsx, FY24_HR.xlsx, FY24_Finance.xlsx. Added worksheet 'Budget Summary' to all 6 files with a table containing columns: Department (text), Allocated (currency), Spent (currency). Each table is named 'BudgetSummaryTable' and starts at cell A1. Workbooks are ready for data entry; consider using Add SharePoint Workbook Table Row to populate rows programmatically.
This synthesis example chains file discovery with bulk Excel manipulation, showcasing the MCP's ability to standardize workbook structure across multiple files. Requires Files.ReadWrite.All scope. Side-effect risk: modifying live workbooks can disrupt users with files open; coordinate timing with your team or target copies first.
Use-case deep-dives
When SharePoint Graph wins for regulated-industry record-keeping
A 6-person legal ops team at a healthcare startup needs to log every contract revision in a SharePoint list with metadata columns for review date, approver, and risk tier. The SharePoint Graph MCP lets them automate the logging from Slack or a standup chat without opening the browser—Add SharePoint Workbook Table Row writes the entry, Add Column To SharePoint Content Type enforces the schema. This works because the team already lives in SharePoint for compliance and the MCP's 50 tools cover the full CRUD surface. If your team isn't already committed to SharePoint as the system of record, the OAuth2 setup and Microsoft ecosystem lock-in make this a poor fit. For teams that are all-in on Microsoft 365, this MCP turns SharePoint into a programmable database you can update from any Switchy conversation.
When this MCP handles recurring spreadsheet updates at small scale
A 3-person finance team closes the books every month by updating a shared Excel workbook in SharePoint—adding rows for new transactions, refreshing pivot tables, and exporting charts for the board deck. The SharePoint Graph MCP automates the repetitive parts: Add SharePoint Workbook Table Row appends the transaction log, Add SharePoint Workbook Chart generates the visual, and the team reviews the output in SharePoint before export. This scenario works because the workbook is already the source of truth and the update cadence is monthly, not real-time. If your data lives in a proper database or you need sub-second refresh, this MCP is the wrong tool—Excel-in-SharePoint is not a transactional system. For small teams running their business on Office files, this MCP saves 20 minutes of copy-paste every close cycle.
When SharePoint Graph fits lightweight project tracking for non-technical teams
A 5-person customer success team onboards 8-10 new enterprise clients per quarter and tracks each onboarding step in a SharePoint list: kickoff call scheduled, training completed, integrations live. The SharePoint Graph MCP lets the team update the list from their daily Switchy standup instead of context-switching to the browser—Add Content Type Copy To SharePoint List enforces the checklist schema, and the OAuth2 auth means each update is attributed to the right CSM. This works because the team is non-technical, already uses SharePoint for client folders, and the onboarding volume is low enough that a list beats a dedicated tool. If you're onboarding 50+ clients per quarter or need SLA automation, you've outgrown SharePoint lists and should use a real CRM. For small teams that live in Microsoft 365, this MCP turns SharePoint into a collaborative task tracker you can update without leaving the conversation.
Frequently asked
What can SharePoint Graph MCP do in Switchy?
SharePoint Graph MCP lets your AI agents read and modify SharePoint sites, lists, content types, and Excel workbooks stored in SharePoint. It can add columns to lists, copy content types between sites, insert rows into Excel tables, and create worksheets — all without leaving your Switchy workspace. Think of it as giving your AI direct access to your SharePoint document libraries and structured data.
Do I need admin permissions to connect SharePoint Graph?
You need OAuth2 permissions that match what you want the MCP to do. For read-only tasks like querying lists, standard user access works. For structural changes like adding content types or modifying Excel workbooks, you'll need edit permissions on those specific sites or files. SharePoint Graph uses Microsoft's OAuth2 flow, so your IT admin may need to approve the app registration if your tenant restricts third-party integrations.
Can SharePoint Graph MCP create new SharePoint sites?
No. This MCP focuses on working within existing SharePoint sites — managing lists, content types, and Excel files. It can't provision new site collections or subsites. If you need to create sites programmatically, use Microsoft Graph API directly or ask your SharePoint admin to set up the site structure first, then connect this MCP to populate and manage content.
How is this different from using SharePoint's web UI?
SharePoint Graph MCP automates repetitive tasks your team would otherwise click through manually. Instead of opening SharePoint, navigating to a list, and adding rows one by one, your AI agent can bulk-insert data, sync content types across sites, or update Excel tables based on natural language instructions. It's faster for batch operations and integrates SharePoint data into multi-tool workflows inside Switchy.
Who on my team should connect this MCP?
Whoever owns the SharePoint sites your team needs to automate. That's usually a project manager, operations lead, or department admin with edit access to the relevant document libraries and lists. They'll authenticate once via OAuth2, and then any Switchy workspace member can invoke the MCP's tools within the permissions that connected user has in SharePoint.