how do you guys create a conditional formula from this column "People Search" - my goal is if there's no people found on that, it will enable apollo search. The thing is the cell value doesn't have data in it
To create a conditional formula for your Apollo Search column, go to the Run Settings of your Apollo Search enrichment and click "Use AI". [1]
In the prompt box, type something like: "Only run if /People Search is empty OR /People Search contains 'Found 0 people'". Use "/" to reference your People Search column. [2]
Click Generate Formula and Clay will create the conditional logic automatically. This ensures Apollo Search only runs when the People Search column has no data or shows zero results.
For handling empty cells specifically, the conditional formula will check if the field is blank and trigger Apollo Search accordingly. [3] This saves credits by preventing Apollo Search from running when you already have people data. [4]
If you still need help setting up the conditional formula for your Apollo Search, I’m here to assist. Would you like to provide more details about what you’re trying to achieve or any specific issues you’re encountering?