The Scenario
You are a procurement manager at a company with Kazakhstan operations. The legal team needs the vendor list by end of week for contract review. You have a Google Sheet with 80 KZ supplier BINs collected from purchase orders and emails over the past quarter.
Legal requires the official company name, director name, registered address, and active/inactive status for every supplier before contracts can be reviewed. Without this data, the review stalls and the contracts do not get signed before the quarter closes.
The slow version of this week:
- Open the Kazakhstan business registry site
- Search each BIN one at a time
- Copy the company details from the response
- Paste them into the sheet
- Repeat 80 times across two days
- Deliver the list Thursday afternoon, too late for the legal team's Wednesday review slot.
The fast version is one prompt and the enriched list is ready the same morning.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that reads the BIN column, calls DaData's Kazakhstan party lookup for every row, and writes the company details back into the sheet.
Open the SheetXAI sidebar and type:
For each Kazakhstan BIN in column A of my sheet, use DaData to fetch the company details and write the legal company name into column B, the director name into column C, the registered city into column D, and the active/inactive status into column E. If DaData returns no result, write "NOT FOUND" in column B.
SheetXAI reads the BIN column, calls DaData's KZ company lookup for each row, and writes four columns of enriched data back. All 80 suppliers, verified against the official Kazakhstani registry, before lunch.
What You Get
Four enriched columns for every KZ supplier in your sheet:
- Column B — official legal company name from the Kazakhstani registry
- Column C — director or signatory name on record
- Column D — registered city
- Column E — active or inactive status
NOT FOUND rows are explicit. If a BIN cannot be resolved, it is flagged immediately so the procurement team can chase the supplier for the correct number before the legal review.
What If the Data Is Not Quite Ready
Supplier BINs collected from emails and purchase orders have inconsistencies. SheetXAI handles them in the same prompt.
When BINs have formatting characters from copy-paste
Some BINs have spaces or dashes from email formatting.
Before running the DaData lookup, strip all non-numeric characters from each entry in column A. Then fetch the KZ company details and write legal name, director, city, and status into columns B through E.
When you also need the business activity code for procurement categorization
The new supplier database requires a primary business activity code alongside the company details.
For each BIN in column A, use DaData to fetch the legal name into column B, the director into column C, the city into column D, the status into column E, and the primary KZ business activity code into column F.
When you want to flag inactive suppliers before they reach legal review
You need the enrichment, but you also want a review flag so inactive suppliers do not get sent to legal as if they were active.
Enrich all BINs using DaData — name to column B, director to column C, city to column D, status to column E. In column F, write "FLAG — INACTIVE" if the status is inactive and "OK" if active. Leave column F blank for NOT FOUND rows.
When you need the enrichment plus a vendor summary for the procurement director
Legal needs the per-row details and the procurement director wants a one-page summary of the vendor landscape before the review.
Enrich all 80 KZ supplier BINs using DaData — name to column B, director to column C, city to column D, status to column E. Flag inactive suppliers in column F. Then write a summary below: total suppliers processed, number active, number inactive, number NOT FOUND, and the top three cities by supplier count.
The pattern: the enrichment and the summary report come from the same prompt. The procurement director and the legal team both get what they need in one run.
Try It
Get the 7-day free trial of SheetXAI and open any sheet with Kazakhstan supplier BINs, then ask it to enrich the rows with official registry data using DaData. The DaData integration is included in every SheetXAI plan. For related workflows, see how to enrich Russian supplier INNs or the DaData in Google Sheets overview.