Home

Clay Announcements
Clay Support
Discuss Anything
Feedback & Requests
GTM Career Advice
Introduce Yourself
Member Spotlight
Share Content and Events
Share Full-time Jobs
Share Part Time Jobs
Share Tables, Tools, and Workflows

Community Guidelines

Explore Events
Learn Clay here
Clay Cup

Powered by Tightknit

Creating Conditional Formula for People Search to Enable Apollo Search | Clay

Creating Conditional Formula for People Search to Enable Apollo Search

·Oct 30, 2025 09:47 AM·

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

Loading attachments

3 comments

· Sorted by Oldest

Clay Support
APP
·
·
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]
Clay Support
APP
·
·
Is that what you were looking for?
Clay Support
APP
·
·
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?