How to Add Mailchimp Subscribers from MS Excel Using Pabbly Connect

Learn how to automate adding Mailchimp subscribers whenever a new row is added in your MS Excel spreadsheet using Pabbly Connect. Follow this definitive guide to creating powerful automated workflows with straightforward, efficiency-focused solutions that save valuable time.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Integration

To start automating the addition of Mailchimp subscribers when a new row is added in your MS Excel spreadsheet, you first need to access Pabbly Connect. Go to your browser and visit the Pabbly Connect website. If you don’t have an account, click on ‘Sign Up Free’ to create one in just a few minutes. If you already have an account, simply sign in.

Once logged in, navigate to the dashboard and click on ‘Access Now’ under Pabbly Connect. Here, you can create a new workflow by clicking on ‘Create Workflow’ and naming it, for instance, ‘MS Excel to Mailchimp’. This workflow will facilitate the integration between your Excel and Mailchimp applications.

2. Setting Up the Trigger in Pabbly Connect

In this step, you will configure the trigger event in Pabbly Connect. Select Microsoft Excel as the application in the trigger window. Then, choose the trigger event as ‘New Row in Worksheet’. This event will activate whenever a new row is added to your specified Excel worksheet.

• Choose ‘Microsoft Excel’ from the app list.
• Select ‘New Row in Worksheet’ as the trigger event.
• Click on ‘Add New Connection’ and authorize your Microsoft Excel account.

After connecting your Excel account, select the workbook you want to monitor for new rows. In this case, it’s the workbook named ‘New Mailchimp Subscribers’. Then, choose the worksheet (e.g., ‘Sheet1’) where you will be adding leads. Finally, click on ‘Save and Send Test Request’ to test the connection and retrieve the first row of data.

3. Configuring the Action to Add Subscribers in Mailchimp

After setting up the trigger, the next step is to configure the action in Pabbly Connect. Search for Mailchimp in the action window and select it. Then, choose the action event as ‘Add New Member with Custom Fields’. This action will allow you to add the new lead as a subscriber in your Mailchimp account.

• Select ‘Mailchimp’ as the application for the action.
• Choose ‘Add New Member with Custom Fields’ as the action event.
• Connect your Mailchimp account by entering your API key and data center.

Once connected, select the audience list you want to add subscribers to. Map the fields from the Excel data to the corresponding fields in Mailchimp, such as email address, first name, last name, and mobile number. Finally, click on ‘Save and Send Test Request’ to confirm that the new subscriber is added successfully.

4. Verifying the Integration Between Excel and Mailchimp

To ensure that the integration is functioning correctly, check your Mailchimp account after completing the setup in Pabbly Connect. Go to the ‘All Contacts’ section in Mailchimp and verify that the new subscriber has been added based on the data from your Excel sheet.

After testing, you can continue adding new leads to your Excel spreadsheet. The automation will run at intervals (every eight hours), checking for new rows and adding them as subscribers in Mailchimp. This pooling technique ensures that your Mailchimp list stays updated with the latest leads without any manual effort.

5. Conclusion

In this tutorial, we have successfully set up an automation using Pabbly Connect to add Mailchimp subscribers whenever a new row is added in an MS Excel spreadsheet. By following the steps outlined, you can streamline your lead management process and ensure that your Mailchimp list is always current.

Utilizing Pabbly Connect for this integration not only saves time but also enhances your marketing efforts by ensuring that every new lead is promptly added to your mailing list. Keep adding leads to your Excel sheet and watch them automatically populate in Mailchimp!