The Scenario
You're the ops manager at a fintech startup that just onboarded 100 new wallet customers. Each one needs a unique virtual account number so they can fund their wallet via bank transfer. The customer data is already in an Excel workbook — name in column A, email in column B, BVN in column C. What's missing is the virtual account number in column D.
Your developer is on call this week and told you to just ask him when you're ready. You've been asking him every week for the past three weeks. The accounts still aren't generated.
The bad version:
- You submit a task to the dev. He generates them in batches via a script, but the script fails at row 67 because one BVN is formatted differently. He fixes it and reruns. Some accounts get created twice.
- You spend an afternoon cross-referencing the returned account numbers against the original workbook to make sure each customer only has one, then flag 11 duplicates for manual cleanup.
- By the time everything is sorted out, six customers have already contacted support asking why they can't fund their wallet.
Your job is onboarding operations. Debugging someone else's script output is not in that description, even if it ends up there every month.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads each customer row directly and calls the Flutterwave virtual account API for each one, writing the returned account number and bank name back into the workbook — no script dependencies, no batch reruns.
Generate bulk virtual account numbers for all 100 customers listed in this Excel sheet and write the account number and bank name for each one into columns D and E
What You Get
- Column D fills with the unique virtual account number for each customer row.
- Column E fills with the bank name associated with each virtual account.
- Rows where the API returns an error (invalid BVN, duplicate customer) get the error message in column D instead of an account number, so nothing is silently skipped.
- Successfully created accounts don't get duplicated — the write only happens once per row.
What If the Data Is Not Quite Ready
Some BVN values in column C are formatted with hyphens instead of plain digits
For each row in this workbook with a name in column A, email in column B, and BVN in column C, strip any hyphens or spaces from the BVN value, then create a Flutterwave virtual account and write the account number into column D and bank name into column E
Some rows already have account numbers in column D from a previous run — skip those
For each row in this workbook where column D is empty, use the customer name in column A, email in column B, and BVN in column C to create a Flutterwave virtual account, and write the returned account number into column D
You need to flag rows where the BVN is not exactly 11 digits before attempting any API calls
Check each row in this workbook: if the BVN in column C is not exactly 11 digits, write "invalid BVN" into column D and skip it. For all valid rows, create a Flutterwave virtual account using the name in column A, email in column B, and BVN in column C, and write the account number into column D and bank name into column E
Validate BVN format, skip duplicates already in column D, create accounts for the rest, and log any errors
Check each row: if column D already has an account number, skip it. If the BVN in column C is not exactly 11 digits, write "invalid BVN" into column D. Otherwise, create a Flutterwave virtual account using the name in column A, email in column B, and BVN in column C, write the account number into column D, the bank name into column E, and log any API errors into column F.
The whole validation-and-creation pass in one prompt. You get clean output without a second debugging round.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with a customer list that needs virtual account numbers, then ask it to generate and write back the Flutterwave account details for each row. You can also see how to generate bulk payment links from an Excel workbook or the full Flutterwave integration overview.