Clay Icon
Join the Community
02 Support

Help Needed with Conditional Formula for Apollo Lookup Results

Avatar of Ross R.Ross R.
·
·

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.

3 comments

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    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.

  • Avatar of Bo (.
    Bo (.
    ·
    ·

    Hey! To handle this, you can use a condition like: !!{{Find people at company by job title}} This checks whether the result exists or not. Let me know if you have more questions