Optimizing Job Posting Enrichment and HubSpot Integration Process
I would love some help with my use case - I am finding job openings at companies, then enriching those companies, and making an OpenAI call to determine if the company is a potential target. Then I want to push these companies to hubspot creating a custom event with the job posting details. I would love this to happen automatically. The issue I am running into is that many companies have many job postings, for 1000 job postings its only around 250 unique companies on average. This means I am enriching and calling OpenAI 4x more than I need to, wasting credits. I initially de-duped based on company domain, but I would love to create a custom event for each job posting, but if I dedupe on domains it will only create one job posting and discard the rest. I am thinking I need to use two tables here, but I cant quite figure it out. Any help would be hugely appreciated! Thanks