The Scenario
You are a treasury analyst. The payment batch goes to the bank at 4 PM. You have a Google Sheet with 150 counterparty BIC codes from incoming payment instructions received this week.
Before each batch, your bank requires that the SWIFT code, correspondent account, and bank city are filled in for every payment row. Right now those columns are blank. The bank's compliance team rejected the last batch because three SWIFT codes were wrong.
The slow version of this afternoon:
- Open the Central Bank of Russia's BIC directory website
- Search each BIC manually
- Copy the bank name, SWIFT, and correspondent account
- Paste them into the sheet
- Repeat 150 times while fielding calls from the CFO
- Miss a row at 3:47 PM and send an incomplete batch.
The fast version is one prompt and the enriched batch is ready with two hours to spare.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that reads the BIC column, calls DaData's bank lookup endpoint for every row, and writes the bank metadata back into the payment sheet.
Open the SheetXAI sidebar and type:
For each BIC code in column A of my sheet, use DaData to look up the bank and write the bank's full name into column B, the SWIFT code into column C, the correspondent account number into column D, and the city into column E. If DaData returns no result for a BIC, write "NOT FOUND" in column B and leave the rest blank.
SheetXAI reads column A, calls DaData for each BIC, and writes four columns of bank metadata back. All 150 rows, verified against the official registry, ready for the 4 PM batch.
What You Get
Four enriched columns next to every BIC in the sheet:
- Column B — official bank full name from the CBR registry
- Column C — SWIFT / BIC international code
- Column D — correspondent account number (korr. schet)
- Column E — city of the bank's registered branch
NOT FOUND rows are flagged explicitly. If a BIC is invalid or the bank has been liquidated, you see it immediately — not after the batch bounces.
Want the registration date or the bank's participation in the Mir payment system? Ask SheetXAI to pull those into columns F and G.
What If the Data Is Not Quite Ready
Payment instruction data pulled from emails and PDFs has formatting issues. SheetXAI handles them in the same prompt.
When BIC codes have extra spaces or formatting characters
Some rows have BICs with spaces, dashes, or leading zeros stripped from copy-paste out of a PDF.
Before looking up each BIC in column A, strip all spaces and non-numeric characters. If the result is fewer than 9 digits, pad with leading zeros. Then run the DaData bank lookup and write results to columns B through E.
When you need to flag banks that are no longer active
Some counterparties use BIC codes for banks that have had their license revoked. You need to catch those before the payment goes out.
For each BIC in column A, use DaData to look up the bank and write the name, SWIFT, correspondent account, and city into columns B through E. In column F, write "REVOKED — DO NOT PAY" if DaData shows the bank's license has been revoked. Otherwise write "OK."
When you have both BICs and IBANs in the same sheet and need different lookups
Some rows use Russian BIC, some have international IBAN from foreign counterparties. You need a different lookup path for each.
For rows where column A contains a 9-digit BIC, use DaData's bank lookup and write the bank name and SWIFT into columns C and D. For rows where column A contains an IBAN (starting with a 2-letter country code), write "INTERNATIONAL — MANUAL REVIEW" in column C and leave column D blank.
When the CFO wants a pre-batch audit summary alongside the enriched data
You need the enriched columns plus a summary table showing any flags, so the CFO can sign off without reading 150 rows.
Enrich all 150 BIC codes using DaData's bank lookup — name to column B, SWIFT to column C, correspondent account to column D, city to column E. Flag revoked banks in column F. Then write a summary below the table: total BICs processed, number of NOT FOUND results, number of revoked banks flagged, and total rows cleared for payment.
The pattern: the enrichment and the audit trail come from the same prompt. You walk into the CFO's office with a complete sheet, not a spreadsheet you are still building.
Try It
Get the 7-day free trial of SheetXAI and open any payment sheet with BIC codes, then ask it to enrich the rows with DaData bank metadata. The DaData integration is included in every SheetXAI plan. For related workflows, see how to validate Russian passport numbers or the DaData in Google Sheets overview.