The Scenario
Six hundred people registered for last week's webinar. The registration form captured name, email, and company domain — nothing else. Sales wants to start working the list by tomorrow morning, but the domains are raw and there is no routing without enrichment. Your job is to turn 600 bare domains into qualified, segmented leads before the 9 AM sync.
The bad version:
- Call Klazify's categorization endpoint for row one, note the category and confidence. Switch to the company data endpoint for row one, note employee count and country. Make a third call for social links. Three API calls per domain, 1,800 total calls, no script.
- Try to find a script that chains all three endpoints — find one on GitHub written for a slightly different response schema that requires modifications you're not confident making.
- Run the first 50 rows through manually during the afternoon, decide the remaining 550 are "good enough" for tomorrow, and send sales a half-enriched list with a note saying "more coming."
Sending a half-enriched list to sales at a 9 AM sync is the kind of thing that comes up in your next 1:1. The leads need to be complete.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads each domain, calls Klazify's real-time categorization endpoint — which returns category, company data, social handles, and tech stack in a single call — and writes all the fields into the columns you specify. One prompt, one pass, 600 rows.
Use Klazify's real-time categorization on each domain in column A of the "Inbound Leads" sheet and write IAB category into column B, confidence score into column C, company name into column D, employee count into column E, LinkedIn URL into column F, and detected CMS into column G
What You Get
- Column B: IAB V3 content category for the domain.
- Column C: confidence score between 0 and 1 for the category classification.
- Column D: company name as Klazify returns it — cleaner than whatever was in the registration form.
- Column E: employee range like "51-200" or "201-500."
- Column F: LinkedIn company page URL.
- Column G: detected CMS platform.
- Blank cells where a field isn't available — no errors, no #REF! — so the sheet stays importable.
What If the Data Is Not Quite Ready
Some registrants signed up with personal email domains (gmail.com, outlook.com) — skip those
For all rows in the "Inbound Leads" sheet where column A does not contain "gmail.com," "outlook.com," "yahoo.com," or "hotmail.com," call Klazify's real-time categorization and write IAB category, employee count, LinkedIn URL, and detected CMS into columns B through E
You want to segment by company size immediately after enrichment
Use Klazify's real-time categorization on each domain in column A of the "Inbound Leads" sheet and write employee count into column E — then add "Enterprise" in column H for any row where column E contains "1001+" and "Mid-Market" for "201-1000" and "SMB" for everything smaller
Duplicate domains appear because multiple people from the same company registered — enrich once, fill all matching rows
Identify duplicate values in column A of the "Inbound Leads" sheet, call Klazify's real-time categorization once per unique domain, and write the enrichment results into columns B through G for every row sharing that domain
You need revenue band too, and you want a "HIGH PRIORITY" flag for companies with 200+ employees and a LinkedIn presence
Use Klazify on each unique domain in column A of the "Inbound Leads" sheet — write IAB category, confidence, company name, employee count, revenue band, and LinkedIn URL into columns B through G — then add "HIGH PRIORITY" in column H for any row where column E indicates 200+ employees and column G has a LinkedIn URL
Full enrichment with routing logic in a single instruction. Sales gets a segmented, prioritized lead sheet at 9 AM.
Try It
Get the 7-day free trial of SheetXAI and open your inbound lead sheet. Ask it to run full Klazify enrichment on every domain in the list and segment the output however your sales team needs it. See also: Enrich Company Firmographics From Domain Names and the Klazify integration overview.