Mailchimp > New Row in AirTable ONLY if Email Doesn't Exist?

Hi @Brandi - Thanks for asking this question. Where are you checking for the email address at? I know the popular option is to put an email address into Google Sheets but I’m thinking that Airtable maybe a good option too. If you do use Airtable, check out the Find Record action to find an existing record, and if it exists, use Filter by Zapier to allow the Zap to proceed if the record if there’s no match. Hope this helps!

Hey, @steph.n. Yes—my OP was specifically about Airtable, as that’s what we’re trying to do (when someone adds a person in our Airtable spreadsheet, we’d like them also added in Mailchimp; and, vice versa—when someone instead gets added to Mailchimp, we’d like them added to a new row in Airtable). But, we don’t want duplicates created. We are, however, on a free account, so adding in a multi-step zap where either our Mailchimp list or our Airtable list is first searched to see if the record already exists and then stops if it does (so that a duplicate isn’t created), isn’t possible for us. We’re a nonprofit, so trying to create some automations but can’t yet afford to get a paid account for that kind of functionality.

Got it. And, great to know, @Danvers. Thanks so much!

Hi Brandi,

If you make entering in Mailchimp always the first operation, it does a dedup check for you.  What is the scenario that would precipitate entering in AirTable and having the Zap push to Mailchimp?

I understand the non-profit part.  Truly I do.  $13.75 per month is 0.45c per task or 9c per hour.  

Hey @Davidh88! Basically, our fields in Airtable are FAR more robust than the form fields we have on each individual record in Mailchimp. It’s far easier—and, again, more robust—for us to be able to fill out a record in AirTable and then have that record push to Mailchimp. But the goal was really to make sure that anyone could enter anywhere and all records would be updated. This is especially helpful because, for instance, not everyone will have access to AirTable (as the records have more info that we don’t want some folks to see, but need to keep), but might have access to update our email list in Mailchimp.

Easy enough to just make sure the main point of contact at our org is always entering in one place first and then we don’t have to worry about it. In this case, that’s AirTable. But, as another example, our website funnels people who sign up for our newsletter straight to our list in Mailchimp. So, in that scenario, we’d want to make sure that entry was automatically, also then, added to AirTable. Of course, we could always switch that functionality on our site to first funnel to AirTable and, again, solve the issue if ALL entries were only ever first starting by entering in one place (like AT). 

But anyway, it would just be nice to know that someone could be entered anywhere and they’d be updated everywhere, also just saving us time from doing our own manual double entry.

The forms in AT are not good enough to display for customer to fill in.  It isn’t a form builder.  The forms are rustic and internal use only (unfortunately).

But you could make a single form in say TypeForm or JotForm et al. that customers and internal use.  That becomes to the single point of entry.  Form their it goes into AT and them out to Mailchimp.

You would need to do a “Find or Create” action in Airtable.  That would take care of dupes.

@Davidh88 Yeah, that’s unfortunately not what we’re going for—there’s far more internal info that we collect on people than what we’d ask them to provide. Thanks for all of your help, but I think we now know that we can’t do what we need without a paid account and the system we have already works for the time being. That being the case, I’ve already marked this as solved and I think we’re fine for now!