Optimizing Job Table Workflows with Company Domain Lookups

I have a job table where a new entry is created by a job title and a company domain. Then I have a look up with the domain of the company to my company table where I check if I already enrich this company in past. If no entry is found, I trigger a write to table action where I enrich this new country. What the best way to run the look up column again in my job table and continue the workflow in my job table?

4 comments

Channeled
APP
·
·
To rerun the lookup column in your job table, you have several options: 1. Right-click on the lookup column and click "Play", then select "Run All Rows that haven't run or have errors" to update only new or failed entries. 2. For a complete refresh, right-click on the column, hover over "Run Column" and select "Force Run All Rows" to rerun every row in the column. You can always rerun the column linked to the company table to refresh the data and ensure you have the most up-to-date information. This will pull in any new enriched company data into your job table.
Sources: Enrich People (Waterfalls) [CRM Enrichment] - Clay University Run Options
Darius M.
·
·
but I want it hapennd automaticly
Channeled
APP
·
·
You can enable automatic updates for your lookup column in two ways: 1. Enable Auto-Update: • By default, new rows within your Clay table will automatically run the lookup when Auto-Update is enabled. 2. Use Conditional Runs: • If you want the lookup to run only under specific conditions, you can set up formulas that trigger the column when certain criteria are met. The lookup function will automatically process any new data coming into your table when Auto-Update is enabled, ensuring your workflow continues seamlessly. You can also set specific conditions using the "Only run if" option to control exactly when the AI runs the lookup.
Sources: Google Sheets integration overview | Documentation | Clay University Write to Other Table | Documentation | Clay University
Channeled
APP
·
·