The Scenario
You are an accounts payable manager. Payment approval is on Thursday. You have a Google Sheet with 300 supplier INN codes collected from incoming invoices over the past quarter.
Finance policy requires verified counterparty data before any payment is released: legal name, registered address, and active/inactive status from the Russian tax registry. Your controller has blocked the last two payment batches because the supplier list was not verified.
The slow version of this week:
- Open the DaData web interface
- Paste each INN one at a time
- Copy the legal name, address, and status out of the response
- Paste them into the sheet manually
- Repeat 300 times
- Lose count at row 47, paste the wrong name into two rows, and have to start over.
The fast version is one prompt and the sheet is enriched before the morning standup.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that reads the INN column, calls DaData's party lookup for every row, and writes the registry data back without you touching the API.
Open the SheetXAI sidebar and type:
For each INN in column A of my sheet, use DaData to look up the company in the Russian tax registry and write the legal name into column B, the registered address into column C, and the active/inactive status into column D. If DaData returns no match for an INN, write "NOT FOUND" in column B and leave columns C and D blank.
SheetXAI reads the INN column, calls DaData for each row, and writes the enriched data back. All 300 rows, done in minutes.
What You Get
Columns B, C, and D populated with official registry data for every supplier:
- Column B — full legal entity name from the FTS registry
- Column C — registered legal address
- Column D — active or inactive status
"NOT FOUND" rows are explicit. Any INN that DaData cannot resolve is flagged immediately, so your review queue is clear and no unknown supplier slips through.
Want OGRN and registration date too? Ask SheetXAI to add them to columns E and F in the same prompt.
What If the Data Is Not Quite Ready
Supplier lists pulled from invoices are rarely clean. SheetXAI handles the edge cases in the same prompt.
When some INNs are formatted inconsistently
Some entries have leading zeros stripped, others have spaces, others have extra characters from OCR scanning.
Before looking up each entry in column A, normalize it: strip spaces and non-numeric characters, and pad to 10 digits with leading zeros if shorter. Then run the DaData party lookup and write results to columns B, C, and D.
When you need to flag inactive suppliers before payment
You want the enrichment, but you also want a column that explicitly marks any supplier whose status is inactive so the controller sees them immediately.
For each INN in column A, use DaData to fetch the legal name, address, and status and write them to columns B, C, and D. In column E, write "HOLD — INACTIVE" if the status is inactive, and "OK" if active. Leave column E blank for NOT FOUND rows.
When you only need to re-check a subset
A previous run already enriched 200 of the 300 rows. You added 100 new suppliers this week and only need to process the blank rows.
Only process rows where column B is empty. For those rows, run the DaData party lookup using the INN in column A and write results to columns B, C, and D. Leave rows that already have data in column B untouched.
When finance also needs OKVED2 classification per supplier
The compliance team needs the primary business activity code alongside the registry data for a new vendor categorization report.
For each INN in column A, use DaData to fetch the legal name into column B, the registered address into column C, the status into column D, the OGRN into column E, and the primary OKVED2 code and description into columns F and G. Mark "NOT FOUND" in column B for any INN that returns no result.
The pattern: the same prompt that does the enrichment can also do the conditional flagging and the extended field pull. You do not need separate runs for separate columns.
Try It
Get the 7-day free trial of SheetXAI and open any sheet with Russian company INNs, then ask it to enrich the rows with registry data from DaData. The DaData integration is included in every SheetXAI plan. For related workflows, see how to standardize company names using DaData's suggest API or the DaData in Google Sheets overview.