How to Use Power Automate with Mailchimp for Email Marketing

Power Automate is a powerful workflow automation tool that integrates with various applications, including Mailchimp. By connecting Mailchimp with Power Automate, you can automate email campaigns, manage subscriber lists, and streamline marketing tasks without manual effort. This guide will walk you through the process step by step.

---

Step 1: Set Up Mailchimp and Power Automate

1.1 Create a Mailchimp Account

If you don’t have a Mailchimp account, sign up at Mailchimp. Ensure you have an API key, which will be required to integrate with Power Automate.

To generate an API key:

1. Log in to Mailchimp.
2. Click on your profile in the bottom left.
3. Navigate to Account & billing > Extras > API keys.
4. Click Create A Key and copy it for later use.

1.2 Access Power Automate

1. Go to Power Automate.
2. Sign in using your Microsoft account.
3. Click Create to start a new flow.

---

Step 2: Create an Automated Flow

2.1 Choose a Trigger

1. Click Create and select Automated cloud flow.
2. Name your flow (e.g., “New Subscriber to Mailchimp List”).
3. In the Choose your flow’s trigger search box, type Mailchimp.
4. Select a relevant trigger, such as When a new subscriber is added.

2.2 Connect Mailchimp to Power Automate

1. Click on the Mailchimp trigger.
2. Sign in using your Mailchimp API key.
3. Choose your audience list from the dropdown.

---

Step 3: Define Actions in Power Automate

3.1 Add Actions for Email Marketing

After the trigger, define actions based on your workflow needs. Here are a few examples:

Scenario 1: Send a Welcome Email to New Subscribers

1. Click + New step.
2. Search for Mailchimp and select Send an email.
3. Configure the email details:
   • To: Use dynamic content to select the subscriber’s email.
   • Subject: Welcome to our newsletter!
   • Body: Customize your email message.
4. Click Save and Test the flow.

Scenario 2: Add New Microsoft Excel Entries to Mailchimp

If you store leads in an Excel sheet and want to add them to Mailchimp automatically:

1. Click + New step.
2. Search for Excel Online (Business) and select List rows present in a table.
3. Choose your Excel file and table.
4. Click + New step > Search for Mailchimp > Select Add subscriber to list.
5. Map Excel columns to Mailchimp fields (e.g., Email Address).
6. Click Save and Test.

---

Step 4: Automate Email Campaigns

4.1 Trigger Email Campaigns via Power Automate

To send a campaign email when a condition is met (e.g., a new order in SharePoint or a CRM update):

1. Choose a trigger (e.g., When an item is created in SharePoint).
2. Add the Mailchimp – Send campaign action.
3. Select the campaign and confirm details.
4. Save and test the flow.

---

Step 5: Monitor and Manage Your Flow

1. Navigate to My Flows in Power Automate.
2. Click on the flow to check its run history.
3. If errors occur, troubleshoot them in the Run history tab.