The Scenario
You inherited the publisher whitelist from someone who left last quarter, and it's 1,500 rows of raw domains with no category labels attached. The campaign goes live Friday. You need every domain tagged with its IAB content category and a confidence score before the brand-safety team signs off — and right now the workbook has nothing in columns B or C.
The bad version:
- Export the domain column as a CSV, write a Python script to loop through and call Klazify, run it, discover the output is a separate file that doesn't match your workbook's column order.
- Try Power Query — find that there is no native Klazify connector, so you'd need to write a custom web function, and the documentation for that assumes knowledge you don't have.
- Open Klazify's API console and start pasting domains in manually, copying the IAB label and confidence score out of the JSON response and pasting into the right cells.
The brand-safety review happens Thursday. You are also supposed to finish the targeting brief by Thursday. Doing this by hand is a math problem: the hours don't exist.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads every domain in column A, calls Klazify's categorization endpoint for each one, and writes the results back — no script, no Power Query, no JSON parsing. You describe what you want; it does the work.
For every domain in column A of the "Publishers" worksheet, call Klazify and write the top IAB category label into column B and the confidence score into column C
What You Get
- Column B fills with IAB V3 category labels like "News and Politics > Politics" or "Shopping > Retail."
- Column C fills with confidence scores between 0 and 1 — you can sort descending to find the high-confidence classifications first.
- Domains that return a parked-page or no-content result get a label of "Uncategorized" so you can filter and review them separately.
- The run is idempotent — running it again on the same column won't double-write rows that already have values, if you ask it to skip filled cells.
What If the Data Is Not Quite Ready
The domains have trailing slashes and mixed protocols
For every domain in column A of the "Publishers" worksheet, strip any leading "http://", "https://", and trailing "/" before calling Klazify, then write the cleaned domain into column A, the IAB category into column B, and the confidence score into column C
Some domains in column A are actually full URLs, not bare domains
For every URL in column A, extract just the root domain — no path, no subdomain beyond "www" — then call Klazify on each extracted domain and write the IAB label into column B and confidence into column C
The whitelist has duplicates and you don't want to pay for the same API call twice
Remove duplicate domains from column A (keep first occurrence), then call Klazify for each unique domain and write the IAB category and confidence score into columns B and C
The brand-safety team needs sub-categories too, and you want a flag for anything below 0.8 confidence
For every domain in column A of the "Publishers" worksheet, call Klazify and write the top IAB category into column B, the first sub-category into column C, and the confidence score into column D — then add "REVIEW" in column E for any row where the confidence score in column D is below 0.8
One prompt does the enrichment, the sub-category extraction, and the review flag. The brand-safety team gets a workbook they can sort without any post-processing from you.
Try It
Get the 7-day free trial of SheetXAI and open your publisher domain list in Excel. Ask it to classify every domain by IAB category and flag anything with a confidence score below your threshold. See also: Enrich Company Firmographics From Domain Names and the Klazify integration overview.