I have a Zapier automation that searches for people in my Salesforce database. It looks through both contacts and leads to see if someone exists. When the person isn’t found in either place, I need the zap to keep running so I can add them as a new lead.
Right now my workflow just stops working whenever the contact search comes back empty. I really need it to continue to the next steps when there are no matches. What’s the best way to handle empty search results in Zapier so the automation doesn’t break? Are there specific steps or filters I should use to catch when nothing is found?
This is super common with Zapier-Salesforce setups. I fixed it by switching to paths instead of relying on search results directly. Run your search step, then create two paths - one for found records, another for empty results. Put your lead creation in the empty results path. Another trick that’s worked well: add a formatter step after the search to check if the results field has data. Gives you way more control than filters alone, especially with complex Salesforce queries that return partial matches.
This happens because Zapier treats empty search results as failures by default. I’ve hit this exact problem several times.
Go to your Salesforce search action and find the advanced settings. Turn on “Should this step be considered a success when nothing is found?” This stops the zap from dying when no records match.
Once that’s enabled, use conditional logic in the next steps to check if the search actually returned data. I usually throw in a code step to see if the search results array is empty, then branch from there. Way more reliable than filters, especially since Salesforce response formats can be weird sometimes.
ya, just put a filter step after your search in zapier. set it to go on even if no results are found. that way, it’ll keep working and let ya add the new lead. it’s been great for me!