The Scenario
Your sales director asked for the account list to be Salesforce-ready by end of day. You have 800 rows in the "Accounts" worksheet — company name in column A, domain in column B — and nothing else. Salesforce requires employee range, annual revenue band, and HQ country before the records can be properly routed and scored. Nobody told you this when you built the list.
The bad version:
- Find the Klazify API documentation, authenticate, run the company data call for the first domain, get back a JSON object, figure out which fields map to which columns.
- Export the domain column as a CSV, find a Python script online, adapt it for your column structure, run it, get an output file that doesn't import cleanly into your workbook because the encoding is wrong.
- Ask the data team for help. Get a reply at 4:30 PM saying they can look at it next week.
The Salesforce import window closes at 5 PM. Next week is not an option.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads column B, calls Klazify's company data endpoint for each domain, and writes the firmographic fields into the columns you specify — no API key hunting, no script modifications, no schema decisions.
For all rows in the "Accounts" worksheet, call Klazify's company data endpoint on the domain in column B and write employee range into column C, revenue band into column D, funding stage into column E, and HQ country into column F
What You Get
- Column C: employee ranges like "11-50," "51-200," or "1001-5000."
- Column D: revenue bands where Klazify provides them.
- Column E: funding stage — "Bootstrapped," "Series A," "Public," or blank if unknown.
- Column F: two-letter ISO country code for the company's headquarters.
- Rows where Klazify returns no company data get blanks, not errors, so your import file stays clean.
What If the Data Is Not Quite Ready
Some domains in column B have "www." or "http://" prefixes that break the API call
For each row in the "Accounts" worksheet, normalize the domain in column B by stripping "www.", "http://", and "https://" before calling Klazify, then write employee range, revenue, and HQ country into columns C through E
The workbook has duplicate domains and you want to avoid redundant API calls
Identify duplicate values in column B of the "Accounts" worksheet, call Klazify's company data endpoint only once per unique domain, and write employee range and HQ country into columns C and D for all matching rows
Some rows already have data in column C from a prior partial run
For all rows in the "Accounts" worksheet where column C is blank, call Klazify on the domain in column B and write employee range, revenue, and HQ country into columns C, D, and E
You need to route accounts by size immediately after enrichment
For all rows in the "Accounts" worksheet, call Klazify on column B to get employee range and write it into column C — then add "Enterprise" in column D for any row where column C contains "1001+" or "5001+" and "SMB" for all others
Employee range enrichment and routing classification in a single pass. The Salesforce import file is ready without a second step.
Try It
Get the 7-day free trial of SheetXAI and open your account workbook. Ask it to pull employee count, revenue, and HQ country for every domain in your list. See also: Map the Technology Stack for a Domain List and the Klazify integration overview.