Help Needed with Conditional Formula for Apollo Lookup Results

Ross R. · 2025-04-30T01:49:15.081811+00:00

Hey I’m trying to fun a conditional formula if nothing is found in an Apollo lookup or Null. Null is easy but no matter which part of the (empty) results I reference it doesn’t run. Any help appreciated.

To create a conditional formula for an Apollo lookup in Clay, you can use AI formulas. Here's how: 1. Go to the "Run Settings" of your Apollo enrichment column. 2. Click on the "Use AI" button under "Conditional Run." 3. Use plain language to describe your condition, such as "Only run if Apollo lookup returns no results or is null." The AI will generate a formula for you. To ensure it runs correctly: 1. Test for empty fields: IF(ISBLANK({{apollo_result}})) THEN "Run" ELSE "Don't Run" 2. Handle unexpected formats: IF(OR(ISBLANK({{apollo_result}}), {{apollo_result}} == "")) THEN "Run" ELSE "Don't Run" Remember to use the preview feature to verify your formula before applying it. If you need further assistance, please request human help by clicking "Talk to a person" in this chat.

Sources: AI Formulas + Conditional Runs [Clay 101] - Clay University Conditional statements | Documentation | Clay University

3 comments