The Scenario
You are a compliance officer at a financial institution. The KYC review deadline is Friday. You have a Google Sheet with 400 passport series and numbers from customer intake forms submitted this month.
Regulation requires that each passport be checked against the FMS invalid document registry before an account is opened. Your team has been doing this manually — one paste at a time into the MVD website — and the process is taking three days per batch.
The bad version of this week:
- Open the FMS registry check website
- Type the series and number from row 1
- Read the result, go back to the sheet, type "Valid" or "Invalid" in column C
- Repeat 400 times
- Make a typo at row 183 and validate the wrong passport number
- Approve an application that should have been flagged.
The fast version is one prompt and the validation column is filled before your first meeting.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that reads the passport columns, calls DaData's FMS validation endpoint for every row, and writes a clear status back into the sheet.
Open the SheetXAI sidebar and type:
For each row in my sheet, use DaData to validate the passport using the series in column A and the number in column B. Write "Valid" into column C if the passport is valid according to the FMS registry, and "Invalid" if it is listed as invalid. Write "ERROR" in column C if DaData cannot process the record.
SheetXAI reads both columns, calls DaData's passport validation endpoint for each row, and writes the status back. All 400 rows, validated against the official FMS registry, in one pass.
What You Get
Column C filled with a validation status for every application:
- "Valid" — passport is in good standing in the FMS registry
- "Invalid" — passport is listed as invalid or revoked
- "ERROR" — the series/number combination could not be checked (format issue or API error)
Invalid rows are explicit and filterable. A single filter on column C shows you every application that needs to be escalated, and every row that had a format problem.
What If the Data Is Not Quite Ready
KYC intake data from manual forms is rarely consistent. SheetXAI handles the edge cases in the same prompt.
When passport series and numbers are in a single combined column
Some intake forms captured the series and number together as one string in column A, like "4512 123456."
For each row, parse column A to extract the 4-digit series and 6-digit number. Use DaData to validate the passport and write "Valid" or "Invalid" into column B. Write "PARSE ERROR" in column B if the format cannot be split correctly.
When you need to add the check date for the audit trail
Compliance requires that the date of each validation check is recorded alongside the result.
For each row, validate the passport using DaData (series in column A, number in column B) and write the validation status into column C. Write today's date into column D for every row that was processed successfully.
When some rows have already been validated in a prior run
A previous batch covered the first 200 rows. You only need to process the new ones.
Skip any row where column C already contains "Valid" or "Invalid." For all other rows, use DaData to validate the passport using columns A and B and write the result into column C.
When you need the validation report plus a summary for the compliance committee
You need the per-row statuses and a summary table showing pass/fail counts for the monthly compliance report.
Validate all 400 passports using DaData — series in column A, number in column B — and write "Valid," "Invalid," or "ERROR" into column C. Then write a summary table below: total validated, count of Valid results, count of Invalid results, count of ERRORS, and the percentage of applications cleared.
The pattern: the validation run and the compliance summary come from the same prompt. The committee gets the report without anyone manually counting rows.
Try It
Get the 7-day free trial of SheetXAI and open any KYC or intake sheet with Russian passport data, then ask it to run DaData validation on the series and number columns. The DaData integration is included in every SheetXAI plan. For related workflows, see how to enrich supplier INNs with registry data or the DaData in Google Sheets overview.