# MailChimp CRM

Source: https://yamm.com/help/usage/crm-integrations/mailchimp-crm/

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

[Awesome Table Connectors](https://awesome-table.com/connectors/help/about) allows you to import Mailchimp data, including your contacts.

**Prerequisites**

- You have a Mailchimp account.

- You have [installed](https://awesome-table.com/connectors/help/get-started/install) and [launched](https://awesome-table.com/connectors/help/get-started/launch) Awesome Table Connectors.

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

   ![Launch empty home screen](https://yamm.com/help/images/docs/usage/crm-integrations/mailchimp-crm/how-to-import-contacts-from-mailchimp-crm-1.png)

   The list of available connectors is displayed.

2. Open the **Mailchimp** connector.

   ![Awesome table connector click Mailchimp](https://yamm.com/help/images/docs/usage/crm-integrations/mailchimp-crm/how-to-import-contacts-from-mailchimp-crm-2.png)

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

   ![Connect to Mailchimp click sign in to Mailchimp](https://yamm.com/help/images/docs/usage/crm-integrations/mailchimp-crm/how-to-import-contacts-from-mailchimp-crm-3.png)

4. Log in to Mailchimp with your account.

   ![Mailchimp sign in](https://yamm.com/help/images/docs/usage/crm-integrations/mailchimp-crm/how-to-import-contacts-from-mailchimp-crm-4.png)

5. Click **Allow** to accept the authorizations.

   ![Mailchimp sign in click allow access](https://yamm.com/help/images/docs/usage/crm-integrations/mailchimp-crm/how-to-import-contacts-from-mailchimp-crm-5.png)

   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](https://yamm.com/help/images/docs/usage/crm-integrations/mailchimp-crm/how-to-import-contacts-from-mailchimp-crm-6.png)

7. (Optional) Use the [Preview & Select columns](https://awesome-table.com/connectors/help/preview-select-columns/how-to) 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](https://yamm.com/help/images/docs/usage/crm-integrations/mailchimp-crm/how-to-import-contacts-from-mailchimp-crm-7.png)
