Building a Workflow for Job Position Contact Resolution in Companies

I am trying to build following workflow. How to do that? Goal: I want clay to resolve the best contact person for a given open job position inside a company. Data structure: - job table: contains job title and reference to company - company table: contains all companies - employee table: contains all employees with reference to company - result table: contains job x employees combination and analyses if person is a good fit Workflow: - Job title and company name go into the job table -> with this the workflow is started - With the company name, we enrich/resolve the company and save them into the company table. - An we create the reference from the company table in our job table. - If we resolved a company already in the past, we reference the exisiting entry for this company. - If the company was not yet in our company table, we resolve the employees and save them into the employee table. - The employee table has a reference to the company table. - Now having the enriched company and the employees, in the result table we create one entry for each job title and employee of this company. - If in future another job position is open for this company, we do not overwrite the existing entries but create new entry in the result table. - Then we check with an AI prompt, if the employees job title would make him a good contact person for our inital job title. - This column would just safe a boolean value of true or false. - If true, it should trigger a webhook.