Setting Conditions for Sequential Find People in Clay

Hi, I have a table where I run Find People clay native option. For the companies where I can´t find contacts in steps 1(domain) and 2 (linkedin) I want to run another option Find People - from Pubrio in increase the found rate How can I set a condition that "find people 3" only runs if find people 1+2 don´t find results?

16 comments

Clay
APP
·
·
You can set up conditional runs to only run your third Find People enrichment when the first two don't return results. Here's how: 1. Add your third Find People enrichment (Pubrio) 2. Click on "Run Settings" then "Conditional Run" 3. Use the AI to generate a formula that only runs if both your previous Find People columns are blank This ensures you're not wasting credits running the third enrichment when you already have contacts from the first two steps.
Sources: AI Formulas + Conditional Runs [Automated Outbound] - Clay University AI Formulas + Conditional Runs [Clay 101] - Clay University
Patrícia S.
·
·
https://app.clay.com/workspaces/310064/workbooks/wb_0t09ct6FZ8cXJF4v6Wd/tables/t_0t09myiw4XtCRBwPxGN/views/gv_0t09myicJpfwh8Cvi7z
Patrícia S.
·
·
My problem is that the Find People output is always updated and it´s always the same. I don´t know how to use this in Conditional Run
Patrícia S.
·
·
Because the output can´t be placed on one table
Clay
APP
·
·
Hi Patrícia - happy to help here.
If you want Find People 3 (Pubrio) to only run when Find People 1 (domain) and Find People 2 (LinkedIn) don’t find anything, there are a couple of ways to do that, even if the outputs aren’t in the same column.
One option is to add conditional logic directly to the Pubrio column. You can do this by going into the column settings → Run Settings → Only run if..., then choose “Custom formula” and paste in: LBKSAND(ISBLANK({Find People 1}), ISBLANK({Find People 2}))LBKSThat’ll make sure Pubrio only runs when both of the other two columns are empty. Clay can reference other columns like this, so it works even if all three are separate. Another cleaner option is to use a waterfall column. You’d create a new column (like “Find People Combined”) and set it to try Find People 1 first, then 2, then 3 (Pubrio). It’ll automatically stop at the first one that returns a result, which avoids unnecessary runs. Either approach should get you the right results. Let me know if that makes sense or if you need any help setting this up.
Patrícia S.
·
·
I tried 2 options but I can´t make any of them work
Clay
APP
·
·
Could you explain where you inputted the formula so I can take a closer look?
Patrícia S.
·
·
Hasnain R.
·
·
Hey Patrícia S.! Here’s how to do it: Add a Find People (Pubrio) step. In settings, go to Run Conditions. Set it to: Run only if column from Find People 1 AND Find People 2 is empty This way it only runs if the first two didn’t return results.
Patrícia S.
·
·
I tried like this and the output looks the same:
Patrícia S.
·
·
And even that the FInd People 1 found 2 people, Find People (Pubrio) runned
Patrícia S.
·
·
I´m still waiting for an answer, why are you closing?
Aditi S.
·
·
Hi Patrícia - we had sent this response previously: "Patrícia - thanks for your patience here as I looked into it. I believe the reason why it's not working is that the rows where you may want to run things again are not actually empty, but may just say "Run condition not met" or there is a missing input. __ Could you confirm that you'd like the Pubrio column to only run when you cannot see "People Search Updated" in both those first columns? This will help me understand what we can do next" But perhaps you didn't see it and as a result our auto-close set it. Apologies for this - do you mind responding to the above ^
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.
Patrícia S.
·
·
yes, I send this video: https://www.loom.com/share/1c9b32344c4a40999fa00ba4bc594dd2?sid=e4b4b8d6-1728-4698-aec7-588b873694f2
Patrícia S.
·
·
Hope I can explain this time in a way that you can understand.