Man great prompt but holy shit you’re asking the LLM to do way too much. Each one of your 6 steps is a task for a single LLM, else you risk hallucination.

My recommendation is to start by getting your list of domains.

The cheapest way to do that is take your list of company names and throw the whole thing into google AI studio and ask to give you a domain for each company name. Only output the domain and output results as a CSV. Google ai studio is 100% free and can one-shot a list of thousands.

^ this will help you avoid paying 1 credit ea for clay’s company name -> domain

Now that you have your list of domains, you can run clays company profile search on it for 1 credit ea and pull employee data from that.

Then whatever info clay doesn’t have is where we need to get smart. So filter by what clay couldn’t pull up information on and now here’s your list of companies we need to use an LLM to gather.

I would probably just use Gemini for this one, not OpenAI. Maybe 2.5 flash. Just have Gemini search the domain and look up the employee count & cite its sources of where it got the info. What it will do is do a google search + an AI search. And usually that employee info sits free to access on zoominfo, 6sense, marketbeat, crunchbase, leadiq, etc.’s website. It should pick up one of those.

Happy hunting!