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

# Mailchimp connector

> Connect Mammoth to Mailchimp with OAuth, query audience and campaign tables with SQL, and save the results as a dataset.

The Mailchimp connector imports email marketing data from your Mailchimp account into Mammoth as a dataset. Authenticate with OAuth—no API keys to manage.

## Before you start

You need:

- A Mailchimp account with access to the audiences and campaigns you want to import

## Step 1: Select the Mailchimp connector

1. In Mammoth, go to **Data Library** and click **+ New Dataset**
2. Select **Connectors**
3. Search for **Mailchimp**
4. Click the **Mailchimp** tile

## Step 2: Authenticate with Mailchimp

Click **New Connection** to start the OAuth flow.

![Mailchimp Log in and authorize page for Mammoth Analytics with Username, Password, Log In, and Continue with Google](https://docs.mammoth.io/api/v1/images/20260826_093545_mailchimp_login.png)

Mammoth sends you to Mailchimp's authorization page in the same browser tab. Sign in with your Mailchimp account and click **Allow** to authorize Mammoth. You're redirected back to Mammoth automatically.

## Step 3: Select Mailchimp data and query

Select the connection under **Existing Connections** to open the query builder. The **List of tables** panel shows the tables this connector exposes. Click a table to load a `SELECT *` query for it and its preview.

### Write a custom Mailchimp query

Edit the SQL in the **Enter SQL query** editor and click **Run**. Use the table and column names shown in the table list and the preview.

![Mailchimp Existing Connections list showing one connected account and the New Connection button](https://docs.mammoth.io/api/v1/images/20260826_093620_mailchimp_after_login.png)

See [Understanding data preview & query](https://docs.mammoth.io/learn/connectors/understanding-data-preview-query/) for a full guide.

## Step 4: Save the Mailchimp dataset

![Mailchimp New Dataset dialog with List of tables, SELECT query, preview, Save table as, and Save as dataset button](https://docs.mammoth.io/api/v1/images/20260826_093818_mailchimp_dataset_screen.png)

1. Enter a **dataset name** in the **Save table as** field (e.g., *"Mailchimp Subscribers"*)
2. Check the **Update Method** (the default is **Replace all data**). To change it, click the edit icon, pick an option, and click **Save changes**:
   - **Replace all data**—Replaces all existing data
   - **Add new data**—Adds new data based on a unique sequential column
   - **Replace with new data**—Replaces existing data with new data based on a unique sequential column
   For **Add new data** and **Replace with new data**, also choose a **Key column**—a numeric or date column with incrementing values, such as an ID or a date.
3. Click **Save as dataset**. When the dataset is saved, click **Done**

![Saved AuthorizedApps dataset panel with Open button, Update Method, Connection, and Query details](https://docs.mammoth.io/api/v1/images/20260826_093906_mailchimp_preview.png)

## Troubleshoot Mailchimp connections

### No audiences visible

- Confirm the authorized Mailchimp account has access to the audience

### Authorization fails

- Mammoth sends you to Mailchimp in the same browser tab and returns you to Mammoth afterwards. If you close the tab or deny access, start the connection again

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