Skip to main content

How to import contacts from Mailchimp CRM?

Learn how to import your contacts from Mailchimp CRM into Google Sheets to send a mail merge with Gmail from your spreadsheet.

Awesome Table Connectors allows you to import Mailchimp data, including your contacts.

Prerequisites

  • You have a Mailchimp account.

  • You have installed and launched Awesome Table Connectors.

  1. In the Awesome Table add-on Home screen, click Create new request.

    launch-emptyhomescreen

    The list of available connectors is displayed.

  2. Open the Mailchimp connector.

    01-awesome-table-connector-click-mailchimp

  3. On the Connect to Mailchimp screen, click Sign in with Mailchimp.

    02-connect-to-mailchimp-click-sign-in-to-mailchimp

  4. Log in to Mailchimp with your account.

    mailchimp-sign-in

  5. Click Allow to accept the authorizations.

    03-mailchimp-signin-click-allow-access

    You are now logged in with the Mailchimp connector.

  6. Open the Select data drop-down and select the audience for which you want to export contacts.

    export-mailchimp-select

  7. (Optional) Use the Preview & Select columns feature to choose the columns you need, edit their names, and configure a sort order.

    1. Click Preview & Select columns.

      A new window opens.

    2. Make the changes you want.

    3. Click Save changes.

  8. Click Run to start your request.

    If you are running a request for the first time, the Permission needed pop-up window opens.

    1. Click Sign in with Google.

    2. Select the Google account you want to use with Awesome Table.

    3. Click Allow to grant Awesome Table the required permissions.

That's it! You have imported your contacts from Mailchimp into your Google spreadsheet. You are now ready to use YAMM to email your contact list!

result-mailchimp-zendesk