About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

  • Home
  • Get Help
  • How Do I
  • Can Table (A) be checked for an existing email address before a zap adds a new record in Table (B) on Zoho CRM?
Best answer

Can Table (A) be checked for an existing email address before a zap adds a new record in Table (B) on Zoho CRM?

  • 17 April 2020
  • 3 replies
  • 319 views
K

Can I use Zapier in this way?

 

I want to have zapier update Zoho Leads (leads table) with new contact records from Outlook. But before it adds the record, I want it to check the Contacts Table (different from leads) to see if the associated email address already exists. If the email address does not already exist as part of a contact record, then it should go ahead and create the new Lead record on the Lead Table. But if the email address is found in Contacts, the Zap does not occur, and no new record is made.

There is a basic system in place like this, but it is creating too many duplicate records. (not duplicates in the same table, but duplicate of records in contacts in the leads table).

icon

Best answer by nicksimard 23 April 2020, 00:58

View original
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

nicksimard
Userlevel 7
Badge +11

Hi Rich,

I see that you’ve written to our Support team and they have responded with some directions and also some questions. Please continue the conversation there, since they’re able to dig into your Zaps :)

If it’s at all possible for you to update this thread once they’ve resolved that for you, it would be much appreciated! That way, anyone else who finds this thread will be able to benefit from the answer.

Thanks!

K

I wonder if you could point me in the direction of their response. I’ve not received an email about a response anywhere. Where can I find this response?

nicksimard
Userlevel 7
Badge +11

Hey Rich,

Not sure why you wouldn’t have received their reply! Here’s what’s they wrote:

 

Thanks for reaching out to us. I'll gladly help you out with this.

With what you're looking to do, I'd suggest adding a Filter step between the Find Module and Create Module steps in your Zap:

140410a7b00599ac2bd0b29bad97575d.png
(view larger)

With that Filter step, you can then tell that Zap to only continue if nothing is found in that previous Find Module step. This way, if something is found, that Filter step will stop it from moving on to the next step. But if nothing is found, it will then move onto that Create Module step.

I hope that helps, and please reach back out if you need any other help.

 

Does that help you out? 

Terms & Conditions