You can use scheduled columns to automatically re-run your lookup column, but the minimum frequency is hourly (Enterprise only) - not every 5 minutes.
To set this up:
1. Click the ⛭ icon on the top right of your table
2. Under Run the table, select On a schedule
3. Choose hourly frequency (requires Enterprise plan)
4. Select Only selected columns and choose your lookup column
Unfortunately, our scheduling doesn't support 5-minute intervals or conditional stopping when data is found - it runs at fixed intervals.
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in Clay Support.