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).
Best answer by nicksimardView original