The Scenario
The partner at your fund wants a market map before the Thursday investment committee. You have 20 portfolio company domains in the "Seed Companies" worksheet and need to expand each into a list of competitors and category adjacencies — the kind of map that would normally take a junior analyst a full day of desk research. It is Wednesday morning.
The bad version:
- Open Crunchbase for the first portfolio company, find the "Similar companies" section, copy the names, Google their domains, paste them into a new worksheet.
- By company seven you realize the "similar companies" Crunchbase shows are based on investor overlap, not product category — that's not what you need.
- Call Klazify's API directly for one company, get back ten similar domains, and realize you haven't thought through how the output workbook should be structured before you've even processed company two.
The investment committee is in 30 hours. There are 20 seed companies. What you need is structured output, not a Google-and-paste afternoon.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the seed company domains, calls Klazify's similar companies endpoint for each, and writes the results into new rows in a destination worksheet — with a source reference column so you can trace which expansion came from which seed.
For each domain in column A of the "Seed Companies" worksheet, call Klazify's similar companies endpoint and write the top 5 similar company domains into columns B through F on the same row
What You Get
- Columns B through F: the top 5 similar company domains for each seed, ordered by Klazify's similarity score.
- Rows where Klazify returns fewer than 5 similar companies get partial fills — blanks rather than errors in the remaining columns.
- Each row in the "Seed Companies" worksheet stays anchored to the original portfolio company, so the source context is never lost.
- The full market map — 20 companies, up to 100 expansion domains — is assembled in one pass.
What If the Data Is Not Quite Ready
You want the similar companies as new rows in a separate worksheet with a source_domain reference column
For each domain in column A of the "Seed Companies" worksheet, call Klazify's similar companies endpoint and add the top 8 similar company domains as new rows in a "Similar Companies" worksheet with the source domain in column A and the similar domain in column B
Some seed company domains have changed since the list was built and now redirect to acquirer domains
For each domain in column A of the "Seed Companies" worksheet, verify the domain resolves before calling Klazify — skip any that return a redirect and note "VERIFY DOMAIN" in column B
You want to deduplicate the similar company results across all 20 seeds before final output
For each domain in column A of the "Seed Companies" worksheet, call Klazify and collect the top 5 similar company domains — then write all unique similar companies (deduplicated across seeds) into a new "Market Map" worksheet with a column tracking which seed company originally surfaced each
You need IAB category labels for each similar company alongside the domain, for the committee deck
For each domain in column A of the "Seed Companies" worksheet, call Klazify to get the top 5 similar companies, then for each similar company call Klazify's categorization endpoint and write the domain and IAB category label as paired columns in a "Similar Companies" worksheet
Two Klazify calls per seed company — similarity expansion followed by category tagging — in a single prompt chain. The committee gets both the market map and the category context without a second work session.
Try It
Get the 7-day free trial of SheetXAI and open your portfolio company workbook. Ask it to expand each seed domain into a list of similar companies and structure the output however the investment committee needs it. See also: Bulk Classify Domains by IAB Category and the Klazify integration overview.