I created my first, non trivial, ZAP connecting Google Spreadsheets with Mailchimp. So far I’m extremely (positively) impressed by this tool. My congratulations to the Zapier team for developing such a powerful yet simple-to-use tool. As a technical person I can be critical of online tools, but for Zapier I really have (and want) to give credit to the tool and to the excellent team that created it.
Here my question.
I have a list of attributes on my spreadsheet (they come from my eCommerce platform) and I want to update the matching Mailchimp subscribers profile with those attributes in order to use them (with merge tags) to customize the email communications. I added a couple of filter to skip lines from the spreadsheet without a proper email, and to include only subscribers in the next batch of order deliveries. Magically everything works and the attributes move from the spreadsheet to Mailchimp!
I only have a couple of questions:
- When my ZAP tries to update a user that is unsubscribed on Mailchimp, I’m getting an error (Mailchimp ran into an error: Member In Compliance State - email@example.com is in a compliance state due to unsubscribe, bounce, or compliance review and cannot be subscribed.). I tried to add a filter to skip unsubscribers but due to my limited knowledge of Zapier I was not able to create such a filter. Any suggestion?
Thank you for any suggestion or recommendation,
Best answer by DanversView original