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" sheet — 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:
- Open Klazify's company data endpoint documentation, figure out the right API call, realize you need a Bearer token you don't have yet, find the API key in a shared doc that is three links deep in Notion.
- Manually look up the first ten companies to check the response structure, discover that "employee_count" is a string range like "51-200" not an integer, and now you need to decide what your column header should say.
- Send a message to the data team asking if there's a script for this. Get a reply six hours later with a Python file that was written for a different CRM schema.
The Salesforce import window closes at 5 PM. The data team's script needs modifications you don't know how to make. This is not what you were hired to do.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. 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" sheet, 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" — matching Salesforce's standard picklist values.
- Column D: revenue bands where Klazify provides them — "< $1M," "$1M-$10M," etc.
- 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" sheet, 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 sheet has duplicate domains and you want to avoid redundant API calls
Identify duplicate values in column B of the "Accounts" sheet, 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" sheet 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" sheet, 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 sheet. 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.