Clay Icon

Optimizing Table Enrichments: Running Columns Sequentially in Your Workflow

·
·

Hey team! I think I’m building my tables inefficient and too slow… I’m making each enrichment (column) run one at a time (so all rows in one column is finished) before I’m “running” the next enrichment. I’m manually “running” each column. I’m doing this way because I don’t know a way to make enrichments (columns) wait for another enrichment to run. I know that you can use formulas to only run when you have a record from other enrichments, but I don’t know how to build a formula where it knows when the enrichment have run and haven’t output a result, or when it has a error and so on. The problem that have occured before is that some enrichments won’t run unless an enrichment gets a result. Which makes that some enrichments won’t run. If I have an enrichment run auotomatically without the formula that makes it wait, it might run too early on some rows. So, is there a way to make an enrichment (column) only run after another enrichment have finished, regardless of the enrichment have output a result or not? A way that triggers only after a enrichment have made a run.

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    💤 You've caught us outside of our support hours (9am-9pm EST), but don't worry - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in the thread below so that we can help you as quickly as possible!

  • Avatar of Tanvi R.
    Tanvi R.
    ·
    ·

    Hi Peter, thanks for reaching out! You can create a boolean formula column to check if an enrichment has finished running, and then use this formula column in a conditional formula to only run a specific integration if the formula is true/the enrichment has finished running. Here's a tutorial on how to use AI Conditional formulas to set this up: https://www.clay.com/university/lesson/ai-formulas-conditional-runs-clay-101 Feel free to give this a try and send over a table link if you still need help/want us to take a look :)

  • 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 Peter W.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: