How to Add New Campaign Details from Mailchimp to Google Sheets Using Pabbly Connect

Learn how to automate the process of adding new campaign details from Mailchimp to Google Sheets using Pabbly Connect. Step-by-step guide included. Implement the precise methodologies leading organizations use to automate repetitive tasks, illustrated with practical examples designed for immediate application.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Mailchimp and Google Sheets Integration

To start adding new campaign details from Mailchimp to Google Sheets, you need to set up Pabbly Connect. This automation tool will help you connect both applications seamlessly. First, create a free account on Pabbly Connect if you haven’t done so already.

Once logged in, navigate to the dashboard and click on ‘Create Workflow’. Name your workflow (e.g., ‘Mailchimp to Google Sheets’) and click ‘Create’. This opens the workflow editor where you will configure the integration.

2. Connecting Mailchimp with Pabbly Connect

In this section, you will connect your Mailchimp account to Pabbly Connect. Start by selecting Mailchimp in the trigger window and choose the trigger event as ‘New Campaign’. This setup allows Pabbly Connect to listen for new campaigns sent from Mailchimp.

• Select Mailchimp in the trigger app.
• Choose ‘New Campaign’ as the trigger event.
• Copy the webhook URL provided by Pabbly Connect.

Now, head over to your Mailchimp account, navigate to the audience settings, and create a new webhook using the copied URL. Make sure to select options that allow updates when a change is made, specifically for campaign sending.

3. Creating a New Campaign in Mailchimp

To test the integration, create a new campaign in Mailchimp. Click on the ‘Create Campaign’ button and select a regular email campaign. Fill in the subject line and content as desired.

After setting up the campaign, send it to trigger the webhook. As soon as the campaign is sent, Pabbly Connect will receive the details of the campaign, including the date and time sent, subject line, status, and list ID.

4. Adding Campaign Details to Google Sheets Using Pabbly Connect

After receiving the campaign details in Pabbly Connect, the next step is to add this information to Google Sheets. In the action window, select Google Sheets and choose the action event as ‘Add New Row’.

• Connect your Google Sheets account to Pabbly Connect.
• Select the specific spreadsheet and sheet where you want to add the campaign details.
• Map the fields from Mailchimp response to the respective columns in Google Sheets.

Finally, click on ‘Save and Send Test Request’ to confirm that the data is being added correctly. You should see a new row in your Google Sheets with the campaign details.

5. Testing the Integration Workflow

To ensure that everything is working properly, create another test campaign in Mailchimp. Follow the same steps as before and send the campaign. Pabbly Connect should automatically capture the details and add them to your Google Sheets.

Check your Google Sheets to verify that a new row has been added with the latest campaign details. This confirms that your automation workflow is functioning correctly and efficiently.

Conclusion

In this tutorial, we learned how to automate the process of adding new campaign details from Mailchimp to Google Sheets using Pabbly Connect. This integration simplifies data management and saves time by automatically recording campaign information in real-time.