Set up the Microsoft SharePoint connector
Configure the Microsoft SharePoint connector in AI Studio under Connectors & Tools. The Microsoft SharePoint connector supports two authentication options:- WRITER-managed OAuth (recommended): Writer provides the OAuth application. No setup required - just authorize access to your SharePoint.
- Organization-managed OAuth: Create your own Microsoft OAuth application for custom branding and control.
Most users should choose WRITER-managed OAuth for faster setup. Only use organization-managed OAuth if you need custom branding or have specific security requirements.
Create a Microsoft OAuth application (organization-managed only)
If you choose to create a self-managed OAuth application to connect, first create a new Microsoft OAuth application in Microsoft Entra ID (Azure AD):- Navigate to the Microsoft Entra admin center
- Go to Applications > App registrations
- Create a new registration
- Configure authentication with Web platform
- Add the Writer redirect URI to Redirect URIs:
- Add API permissions for the required Microsoft Graph scopes
- Create a client secret in Certificates & secrets
- Copy the application (client) ID and client secret
Required OAuth scopes
For self-managed OAuth, choose one of the following scope configurations based on the level of access you need:-
Option A — Broad access: Add the following scopes to grant read and manage access across all site collections:
Sites.Read.All- Read items in all site collectionsSites.Manage.All- Create, edit, and delete items and lists in all site collectionsFiles.ReadWrite.All- Read and write files the user can accessoffline_access- Maintain access to data
-
Option B — Selected sites only: Add the following scopes, then have a tenant admin grant
FullControlon specific sites through the Microsoft Graph API. This avoids granting access to your entire SharePoint environment.Sites.Selected- Access selected site collectionsUser.Read- Read user profile informationoffline_access- Maintain access to data
Configure the connector in AI Studio
- Navigate to Connectors & Tools in AI Studio
- Select the Microsoft SharePoint connector
- Select who has access by default (all users or specific teams)
- Select the connection type:
- Level: User level (each user authenticates their own account) or org level (shared connection to a single account)
- Managed by: WRITER-managed or self-managed (your own OAuth app)
- Select which tools to enable for your agents
- Enter your OAuth client ID and client secret (if using self-managed OAuth)
- Complete the OAuth authorization flow
Next steps
- Set up connectors: Learn how to configure and enable connectors in AI Studio
- Tool calling guide: Understand how AI agents use tools in conversations
- WRITER Agent guide: Learn how to use WRITER Agent with connected tools
- MCP gateway overview: Learn about Writer’s MCP gateway architecture