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.

  • 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?

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).

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!

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?

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