The Scenario
You are a finance analyst at an Indian e-commerce company. The quarterly board call is in three days and your CFO needs the Q1 FY2025 revenue report. The data source is Razorpay — 2,500 payments from January through March, spread across UPI, cards, net banking, and wallets.
Your job is to get all of it into a Google Sheet: payment ID, amount, currency, status, payment method, and customer email. Then your CFO wants the totals by method, the average order value, and a flag on every failed payment.
The slow version:
- Log into the Razorpay dashboard
- Set the date filter, hit Export, wait for the CSV
- Open it in Sheets — paise amounts, no rupee column, columns in a different order than last quarter
- Add a rupee conversion column by hand
- Deduplicate rows from the export (the last page overlaps with the second-to-last)
- Build the method totals pivot table
- Add the failed payment flag formula
- The CFO calls to say the numbers don't match last month's report. You start over.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that reads from Razorpay directly, so you don't have to touch the dashboard or the CSV.
Open the SheetXAI sidebar and type:
Fetch all Razorpay payments from 1 January to 31 March 2025. Import payment ID, amount in rupees (convert from paise), currency, status, payment method, and customer email into this sheet. Sort by date ascending. Then add a column called "Flag" and write "Failed" for every row where status is not "captured."
SheetXAI authenticates against your Razorpay account, pulls all 2,500 payments across paginated results, handles the paise-to-rupees conversion, writes the rows into the sheet, and adds the flag column.
What You Get
A clean sheet with every Q1 payment:
- Payment ID, amount in rupees, currency, status, method, email — one row per payment
- "Flag" column — "Failed" for any status that isn't captured, blank otherwise
- All 2,500 rows — no pagination limits, no double-counting from overlapping CSV pages
The data lands ready to pivot. Add a pivot table on the method column and you have your payment method breakdown. Your CFO's question is answered from the same sheet, not a second report.
Want to add average order value by method? Ask SheetXAI in the same prompt. It adds the calculated column alongside the raw data.
What If the Data Is Not Quite Ready
Real payment data has edge cases. SheetXAI handles them inline.
When payments span multiple currencies
Your Razorpay account processes INR and USD for international customers. The amount column has mixed currencies and the rupee conversion only makes sense for INR rows.
Fetch all Q1 FY2025 Razorpay payments and import payment ID, amount, currency, status, and method. For INR rows, add a "Amount (INR)" column converting from paise. For USD rows, leave the amount in USD and write "USD" in a "Currency Note" column so they can be reviewed separately.
When you need only captured payments for revenue recognition
Failed and pending payments should not appear in the revenue figure. The CFO wants only captured ones.
Fetch all Razorpay payments from 1 January to 31 March 2025 where status is "captured." Import payment ID, amount in rupees, payment method, and customer email. Exclude any other status. Sort by amount descending.
When the method breakdown needs to match an existing summary tab
You have a Summary tab with rows for UPI, Card, Net Banking, and Wallet. You need the totals to populate those rows automatically.
Fetch all captured Q1 FY2025 Razorpay payments. Calculate total amount in rupees per payment method. Write the totals into the Summary tab: UPI total in cell B2, Card total in B3, Net Banking in B4, Wallet in B5.
When you need the raw pull plus the analysis in one shot
You have not touched the data yet. You want the import, the conversion, the method breakdown, and the failed-payment count all in one prompt.
Fetch all Razorpay payments from Q1 FY2025. Import them into the Raw tab with amount converted from paise to rupees. Then create a Summary tab showing: total captured revenue by payment method, total failed payments by method, and average order value across all captured payments. Flag any method where the failure rate exceeds 5%.
The pattern: instead of exporting, cleaning, and then analyzing in three separate steps, you ask for all three in one prompt. SheetXAI handles the conditional logic inline.
Try It
Get the 7-day free trial of SheetXAI and connect it to your Razorpay account, then ask it to pull your Q1 payments and flag the failed ones. The Razorpay integration is included in every SheetXAI plan. For related workflows, see how to pull the settlement recon report or the Razorpay in Google Sheets overview.