Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

I’m looking to have a system in which when a new Google Calendar event is created (that has attendees) it will automatically add those attendees to my newsletter.

 

Currently here is my workflow on Zapier

Trigger - Google Calendar

Type: New Event Matching Search

Search Term: “and” 

 

Action - Revue

Attendee Email Address → Email Address Field

 

Normally this would be effective except there is is one main problem: The “attendee email address” field includes MY OWN EMAIL TOO. For example:
 

Attendee Email: MYEMAIL@gmail.com, TARGETEMAIL@gmail.com,

 

Therefore, when it goes through zapier it mentions that the “subscriber already exists” which makes sense because my “MYEMAIL@gmail.com” is already included in my newsletter list.

 

The ideal situation would be that the Action would IGNORE existing emails that are already on my newsletter list and just input ones that AREN’T. Except the problem is that it goes through every email in the attendee list and if ONE of them is already on my newsletter subscribers it completely halts the entire zap.

 

Is there any solutions / work arounds o this problem - allowing zap to bypass existing email subs to focus on non-email subs to input them into the list?

Hi @mattespoz 

You should be able to use formatter > text > replace function to cut out your email address from the email list. Use the formatter before the revue action. 

Thanks for your reply @robschmidt ! That works brilliantly IF there are only 2 emails at play. Yet if there are 3+ attendees it doesn’t function.

 

For Example:

Attendee A - Me (already sub to my newsletter)

=> Solution: your method

Attendee B - You (already sub to my newsletter)

=> This is where problem occurs

Attendee C - Bob (isn’t already sub to my newsletter)

 

With Zapier, it will halt the ENTIRE production, just because ONE person is already in my newsletter. Therefore, in the scenario above, Bob doesn’t get added to my newsletter as it says: “subscriber already exists” in reference to YOUR email.

 

Let me know if there is a fix this above! I’ve also sent you a private message, I’d be willing to pay you for your time to fix this issue :)

Terms & Conditions