Question

How do I list all subscribers who opened a Mailchimp email in a Google Sheet without duplicates?

  • 18 November 2023
  • 3 replies
  • 67 views

Hello!  I’d like to automatically list any subscriber that opened an email sent by MailChimp on a Google Sheet that my team can reference. The Mailchimp trigger “Email Opened in MailChimp” is almost what I need, but it requires me to manually select the campaign each time.

My attempt at a possible solution was to create an entirely new zap with a Webhook that is scheduled to periodically (2) GET all known campaign ids and add them to their own row in Google Sheets. The ids come as one line item with whitespace and commas.  So I run them through a (3) formatting step and the data output appears to be correct.

After that, this is where I’m stuck.  If I use the (4) “Lookup Spreadsheet Row” to check data against existing row information with the “Create a new row if the row doesn’t exist yet” using the output information from the formatting step, it seemingly forgets all of the formatting and spits it out as it was before the formatting.

However, if I enter that same information onto the (5) Create Multiple Spreadsheet Rows in Google Sheets step, the formatting is entered correctly.  But, this action isn’t checking for duplicates and updating only new information.

I’m pretty new to Zapier and honestly at a loss for what more I can do.  There’s also a good chance I am overcomplicating the process.  Please let me know If there’s an easier way to accomplish what I’ve mentioned.

I’m happy to provide any additional information

 

Thanks in advanced!


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Userlevel 7
Badge +14

Hi @Frazier 

Good question.

Try using the Looping app: https://zapier.com/apps/looping/help

Userlevel 1

I have the same situation. I want to use the Email Opened event from MailChimp, but I want it to be for any campaign. I had the same idea to lookup Campaigns and store them in a table. But then what? The trigger still needs to reference one Campaign. You almost want to create a new Zap for each campaign automatically and configure the trigger with the Campaign Name, but 1) that would create a bunch of Zaps, 2) I don’t think that is possible. 

 

If you create the table listing Campaign Names, and then loop through, there still isn’t a way to get email opens for all campaigns… any ideas?

Userlevel 7
Badge +14

Hi @spencerogden 

You may have to look into using Mailchimp Webhooks: https://mailchimp.com/help/about-webhooks/

Zap trigger: Webhook - Catch Hook