The Scenario
Your ten best customers are churning out referrals and your growth marketer has a hunch there are hundreds of lookalike companies you haven't touched yet. She's dropped those ten customer domains into column A of an Excel workbook and handed it to you with the instruction: "Find me fifty more like each of these."
You know what she means. You have no idea how to do it without CompanyEnrich's similarity API.
The bad version:
- Open CompanyEnrich for the first domain, read through the "similar companies" panel, write down company names by hand, paste them into rows below in the workbook, tag which source domain they came from.
- Do this for all ten domains, tracking which new rows belong to which source across 500 total entries.
- Realize at domain seven that you forgot to capture employee count and go back to fill it in.
The list needs to go to the sales team by end of week and you've already spent three hours on ten rows. The cognitive load of manually maintaining source-domain tags across 500 rows is not a problem that resolves itself.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your data, understands the structure, and through its CompanyEnrich integration it can find similar companies for each domain and write the results into new rows — tagged and organized — in one prompt.
For each domain in column A, find up to 10 similar companies using CompanyEnrich and list each similar company's name, domain, industry, and employee count in new rows below, tagged with the source domain in column E.
What You Get
- New rows appended below each source domain group with company name, domain, industry, and employee count in columns A through D.
- Column E on each new row contains the source domain it was derived from, so the whole list stays traceable.
- Up to 100 total new rows (10 per source domain × 10 domains), organized by source group.
- Rows where CompanyEnrich returns fewer than 10 similar companies reflect the actual count returned.
What If the Data Is Not Quite Ready
You want a specific industry filter on the results
For each domain in column A, find similar companies using CompanyEnrich, but only include results where industry is "SaaS" or "Software", and write company name, domain, industry, and employee count into new rows below, tagged with the source domain in column E.
The results need to go into a separate worksheet rather than inline
For each domain in column A, find up to 10 similar companies using CompanyEnrich and write their name, domain, industry, employee count, and source domain into a new worksheet called "ICP Lookalikes", one row per similar company.
You want to deduplicate across all source domains
For each domain in column A, find up to 10 similar companies via CompanyEnrich, collect all results, remove any duplicates where the same company domain appears under more than one source, and write the deduplicated list into a new worksheet called "ICP Targets" with name, domain, industry, headcount, and the first source domain it matched.
Full kill-chain: filter, search, deduplicate, and score in one shot
For each domain in column A, find up to 10 similar companies via CompanyEnrich. Collect all results, remove duplicates by domain, keep only companies with 50–500 employees in the United States, then score each by writing "Tier 1" in column F if employee count is over 200 and industry is "SaaS", and "Tier 2" for all others. Output everything to a new worksheet called "Prioritized Lookalikes".
One prompt handles the similarity search, deduplication, geographic filter, and tiering together.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook with your top customer domains, then ask it to find similar companies via CompanyEnrich and populate a lookalike list you can hand directly to sales. You might also want to enrich those lookalikes with full firmographic data as a next step.