> AI agents: this is one page from Mammoth Analytics documentation. The index of all pages as Markdown is https://docs.mammoth.io/llms.txt. Append `.md` to any docs URL, or send `Accept: text/markdown`, to get Markdown.

# SharePoint connector

> Connect Mammoth to SharePoint Online with Azure app credentials, browse a document library, and import a file as a dataset.

The SharePoint connector imports files from **Microsoft SharePoint Online** document libraries into Mammoth as datasets. Authentication uses Azure app credentials (Tenant ID, Client ID, Client Secret)—this is an app-level connection, not tied to an individual user account.

## Before you start

You need to register an **Azure Active Directory app** with Microsoft Graph access to the target SharePoint site. This is a one-time setup done by a Microsoft 365 admin.

### Register the Azure AD app

1. Go to [Azure Portal](https://portal.azure.com) → **Azure Active Directory → App registrations**
2. Click **New registration**—name it (e.g., `Mammoth SharePoint`) and click **Register**
3. Copy the **Application (client) ID**—this is your **Client ID**
4. Copy the **Directory (tenant) ID**—this is your **Tenant ID**
5. Go to **Certificates & secrets → New client secret**, add a description, set an expiry, and click **Add**
6. Copy the secret **Value** immediately (it won't be shown again)—this is your **Client Secret**
7. Go to **API permissions → Add a permission → Microsoft Graph → Application permissions**
8. Add `Sites.Read.All` (or `Sites.Selected` for tighter scope)
9. Click **Grant admin consent**

## Step 1: Select the SharePoint connector

1. In Mammoth, go to **Data Library** and click **+ New Dataset**
2. Select **Connectors**
3. Search for **SharePoint** or find it in the **Cloud Storage** category
4. Click the **SharePoint** tile

## Step 2: Create a connection

Click **New Connection** to open the credential form.

| Field | Description | Example |
| --- | --- | --- |
| **Server URL** | Your SharePoint site URL | `https://mycompany.sharepoint.com/sites/Analytics` |
| **Tenant ID** | Azure AD Directory (tenant) ID | `xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx` |
| **Client ID** | Azure AD Application (client) ID | `yyyyyyyy-yyyy-yyyy-yyyy-yyyyyyyyyyyy` |
| **Client Secret** | The app secret value you created |—|

All four fields are required. Click **Connect** once they're filled in—there's no OAuth sign-in step, since the connector authenticates directly with the app credentials above. If validation fails, the error message appears at the bottom of the form.

## Step 3: Select your SharePoint file

After connecting, select the connection under **Existing Connections**, then browse the SharePoint document library file tree to find your file.

### Supported SharePoint file formats

`.txt` · `.csv` · `.tsv` · `.psv` · `.xls` · `.xlsx` · `.xml` · `.zip` · `.bz2` · `.gz` · `.tar` · `.7z`

## Step 4: Create the SharePoint dataset

Click **Create new dataset**. Mammoth does not ask you to choose an update method for this connector.

To keep the dataset in sync as the source file changes, set up a **Dataset Refresh** automation.

## Troubleshoot SharePoint connections

### Authentication fails

- Check all four values (Server URL, Tenant ID, Client ID, Client Secret) are copied correctly—GUIDs are case-insensitive but must be complete
- Confirm admin consent has been granted for the API permissions

### Client secret expired

- Client secrets expire based on the duration you set during creation—generate a new secret in Azure Portal and update the connection in Mammoth

### Permission denied accessing files

- Confirm `Sites.Read.All` (or `Sites.Selected` with the correct site) has been granted with admin consent

---
Source: https://docs.mammoth.io/learn/connectors/sharepoint-connector.md · Updated: 2026-10-13