The Scenario
A handoff happened last month. The business development analyst who built your Russian prospect list left, and the list landed on your desk with 80 company names in column A, no addresses, no TINs, no verification that any of them are real legal entities rather than informal trade names.
Your manager wants to start outreach next week. The standing rule is that no company gets contacted without a verified address and TIN on file.
You have 80 rows to validate.
The bad version:
- Open Yandex Maps, search for the first company name, find the business card panel, copy the address — if the right company even shows up first
- Switch back to your sheet, paste the address into column B, look for the TIN — realize Yandex Maps does not prominently display TINs, switch to a business registry search instead
- Spend 12 minutes on the first company and realize you have 79 left and outreach starts Monday
Nobody hired you to do registry lookups. The list was supposed to be ready.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. Through the Yandex organization search integration, it can look up each company name and write the verified address and TIN directly into your sheet — one pass across all 80 rows.
For each company name in column A, search Yandex organizations and write the first result's official name, address, and TIN into columns B, C, and D. Start at row 2 and process all non-empty rows.
What You Get
- Column B: official registered company name as Yandex returns it
- Column C: street address from the Yandex organization record
- Column D: TIN where Yandex returns one
- Rows where no matching organization is found get "No result" in column B, so you know exactly which entries need manual follow-up
What If the Data Is Not Quite Ready
Company names are trade names, not legal entity names
A company operating as "AutoParts Plus" may be registered as "OOO AvtoPlyus" in the business registry. The search needs to be fuzzy enough to find it.
For each company name in column A, search Yandex organizations. If no exact match is found, return the closest match with a confidence score above 0.7. Write the matched legal name into column B, address into column C, TIN into column D, and confidence score into column E. Mark rows with no match above the threshold as "Low confidence — verify manually" in column E.
Filter results to a specific city before writing
Your prospect list is supposed to be Moscow-based companies only. Names that match organizations in other cities should be flagged.
For each company name in column A, search Yandex organizations. Write legal name, address, and TIN into columns B through D. In column E, write "Wrong city — check" for any result whose address does not contain "Москва" or "Moscow". Write "OK" for Moscow-based results.
Enrich only the rows where column E is blank
You ran a partial enrichment last week and 30 rows already have data. You only want to fill the gaps.
For each row in column A where columns B, C, and D are all empty, search Yandex organizations and write the official name, address, and TIN into columns B, C, and D. Leave rows that already have data in column B untouched.
Search, validate TIN format, flag mismatches, and sort results by confidence in one pass
Russian TINs follow a fixed format — 10 digits for legal entities, 12 for individuals. Any result returning something outside that format is suspect.
For each company name in column A, search Yandex organizations. Write official name into column B, address into column C, and TIN into column D. In column E, validate the TIN format: write "Valid TIN" if it is 10 digits, "Invalid format" if it is not. Sort the results so that rows with "Invalid format" appear first. Start at row 2.
You want the exceptions at the top of the list — that is where you spend your review time.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet with your Russian prospect list, then ask it to enrich every row with verified names and TINs and surface the ones that could not be confirmed. See also: bulk routing calculations and reverse-geocoding delivery stops.