SPA + API: API and SPA Configuration

Export User Data To MailChimp

In this article, you’ll learn how to export user data in Auth0 to a CSV file then import it into the MailChimp dashboard.

Define the API endpoints

Create a user data file

Start by navigating to the Extensions section of the Dashboard and open the User Import / Export Extension. On the extension page, select Export from the menu.

Next, set the Export Format to the required file format. MailChimp accepts file imports in CSV format so choose the Tab Separated Value file (*.csv) option.

User Import/Export Extension Format

At the top in the Fields section, provide a User Field and Column Name for each user attribute to include in the export. For MailChimp, an email field with the column name Email Address is required, so make sure to include it. For example:

User Field Column Name
email Email Address
created_at Created At
given_name First Name
family_name Last Name

User Import/Export Extension Fields

After adding the user fields, click on the Export Users button to start the export. Once the export is complete, download the CSV file to use in the following section.

Secure the Endpoints

Import a user data file

Log in to your MailChimp account and go to the Lists page. Select a list to import your Auth0 users into (or create a new list). On your MailChimp List page, click on Import Contacts from the Add Contacts menu.

MailChimp List: Import Contacts

On the next page, select the CSV or tab-delimited text file option to import contacts from.

MailChimp List Import Source

Next, upload the user data CSV file you exported from Auth0 in the previous section. MailChimp will interpret your user data on the following page.

MailChimp Import Column Match

Check that the column names and field types are correct, when you're ready to proceed click the Next button.

MailChimp Start Import

After reviewing your selections and setting the import category, click on the Import button to start the user import.

That's it! You successfully imported your Auth0 users into MailChimp.