Clay Icon

Automating Column Triggers for Sequential Website Searches

·
·

Hello, is there any way to automatically trigger one column to run after another has finished running? I saw there are some waterfall functionalities for people search, but I’d like to do that for a website search based on company + country (example: first using Claygent, then using clearbit if Claygent didn’t find anything). Thanks !

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    👋 Hey there! Our support team has got your message - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in this thread so that we can help you as quickly as possible!

  • Avatar of Muhammad S.
    Muhammad S.
    ·
    ·

    yes, you can control that via run settings/conditions, click on edit column scroll at the bottom and there you should see run settings

  • Avatar of Camille P.
    Camille P.
    ·
    ·

    Thanks ! I already set run settings (e.g. run column B only if column A = Not found), but it doesn’t work because both columns run at the same time when my data is sent through webhook. So column A doesn’t have the time to be “not found” and column B runs anyways

  • Avatar of Daniel K.
    Daniel K.
    ·
    ·

    Hey Camille! Thanks for reaching out! 😊 One way to tackle this is by nudging Clayagent in the manual waterwall to generate an output (under "Define column outputs") that can serve as a condition to trigger or skip Column B. But I'd be more than happy to delve into your specific scenario and offer some pointers on how to navigate through it. Can you share your table with me? Btw, my mom booked a sightseeing tour with GetYourGuide 2 weeks ago and see loved it! Great product.

  • Avatar of Camille P.
    Camille P.
    ·
    ·

    Thanks Daniel ! Here is the table https://app.clay.com/workspaces/307531/tables/t_vtaTJQ4jJMSB/views/gv_qcC593H6GCyi - I want column “Find Domain from Company Name” only to run if Claygent (AI Web Researcher) = “Not found” and “Find Domain from Company Name (2)” to run only if “Find Domain from Company Name” doesn’t return results

  • Avatar of Bo (.
    Bo (.
    ·
    ·

    Hey Camille - Here's how: The issue was due to the prompt you added ! :) https://cln.sh/yc8pGGsQ

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Hi Camille P.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: