The Scenario
Your support inbox has been filling up with the same message for three days: "I was charged but my order isn't confirmed." You've collected 80 transaction references from customers in a Google Sheet — column A, one per row — and you need to know which ones actually succeeded in Paystack before you start issuing refunds or escalating to engineering.
The bad version:
- You open the Paystack dashboard, click into the search bar, paste the first reference, note the status and amount in your sheet, then click back and paste the next one.
- Forty references in, you lose your place because a Slack notification pulled your attention. You're not sure if row 41 was the one you just checked or the next one.
- Three references return a "transaction not found" error in the dashboard and you don't know if that means they never went through or if you misread the customer's email.
You have 80 rows to get through. At two minutes per reference, that's nearly three hours of tab-switching — and you still have 40 support tickets open after that.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the reference list in your sheet and runs every verification through Paystack's API in sequence, writing the result back alongside each reference — no dashboard switching, no manual note-taking.
For each transaction reference in column A, verify it with Paystack and write the returned status and amount into columns B and C.
What You Get
- Column B: verification status per reference (success, failed, abandoned, or not found)
- Column C: amount returned by Paystack for that reference (in the transaction's currency unit)
- Rows where Paystack returns no record get "not found" in column B and a blank in C
- Completion across all 80 rows in one run — no manual iteration
What If the Data Is Not Quite Ready
Some references have extra whitespace or inconsistent casing
Clean the transaction references in column A — trim whitespace and normalize to uppercase — then verify each one with Paystack and write status and amount into columns B and C.
You only want to flag the ones that failed or weren't found
Verify every transaction reference in column A against Paystack, write the status to column B and amount to column C, then highlight rows where status is 'failed' or 'not found' in red so I can triage them first.
You want to join the result against a customer email list in another tab
Verify each reference in column A via Paystack, write the status and amount to columns B and C, then look up the matching customer email from the 'Customers' tab using the reference and write it to column D.
Triage, verify, flag, and draft response notes in one shot
Verify all transaction references in column A against Paystack, write status and amount to B and C, mark 'REFUND ELIGIBLE' in column D for any successful payment over 5000 naira where the customer also appears in the 'Open Tickets' tab, and leave column D blank for all others.
The pattern: verification plus triage logic in one prompt means you come out with a sheet that tells you exactly what to do next — not just raw statuses you still have to interpret.
Try It
Open the Google Sheet where you track customer disputes or support cases, then Get the 7-day free trial of SheetXAI and ask it to verify your Paystack references in bulk. For related workflows, see how to export your full dispute history or pull a transaction history for reconciliation.