The Scenario
You are a payments operations manager at an online marketplace. Your inbox has three messages from the acquiring bank: respond to the flagged chargebacks within 72 hours or face automatic escalation.
You have no idea how many active disputes are sitting in Razorpay right now, which ones are closest to their deadline, or who on the team should be handling them. The only way to find out is to log into the Razorpay dashboard and scroll through the disputes section one by one.
The slow version:
- Log into the Razorpay dashboard
- Navigate to Disputes
- Count the rows — 23 active disputes, spread across four pages
- Screenshot each page, paste into a shared doc
- Manually create a sheet with payment ID, amount, reason, status, and respond-by date per dispute
- Sort by respond-by date by hand
- Assign team members in the sheet, email each one
- Realize the respond-by dates are in a timezone that doesn't match your bank's deadline.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that can pull all active Razorpay disputes and build the triage sheet for you, sorted by urgency.
Open the SheetXAI sidebar and type:
List all Razorpay disputes and import payment ID, dispute ID, disputed amount in rupees (convert from paise), reason, status, and respond-by date into this sheet. Sort by respond-by date ascending so the most urgent disputes appear first. Add a column called "Days Until Deadline" showing how many days remain from today.
SheetXAI pulls every active dispute from your Razorpay account, writes the rows into the sheet, and adds the calculated urgency column.
What You Get
A dispute triage sheet ready to share with the team:
- Payment ID, dispute ID, amount, reason, status, respond-by date — one row per dispute
- "Days Until Deadline" column — calculated from today, so you see at a glance which ones are critical
- Sorted by respond-by date — the most urgent dispute is in row 2
You can assign team members immediately. Add a column for "Owner" and distribute the rows. No one has to log into the Razorpay dashboard to see the list.
If a dispute deadline has already passed, ask SheetXAI to flag it in a separate column. It adds the conditional check without a formula.
What If the Data Is Not Quite Ready
Dispute data has edge cases that matter for triage. SheetXAI handles them inline.
When the respond-by date is in UTC and your team works in IST
Razorpay stores timestamps in UTC. Your team thinks in IST (UTC+5:30).
Fetch all Razorpay disputes. Import payment ID, dispute ID, amount in rupees, reason, status, and respond-by date. Convert the respond-by date from UTC to IST before writing it to the sheet. Add a "Days Until Deadline (IST)" column.
When you want to group disputes by reason code for pattern analysis
You suspect one product category is generating most of the chargebacks.
Fetch all Razorpay disputes and import into this sheet. Add a summary section below the data showing: count of disputes by reason code, and total disputed amount by reason code. Sort the summary by total disputed amount descending.
When you only want disputes above a certain amount for senior review
Small disputes can be handled by junior staff. Disputes above ₹10,000 need a senior sign-off.
Fetch all active Razorpay disputes. Import all disputes into this sheet. Then add a column called "Priority" — write "High" for disputes with a disputed amount above ₹10,000, and "Standard" for the rest. Sort by Priority then by respond-by date.
When you want the full triage sheet — pull, sort, add deadline, flag overdue, and summarize
Fetch all Razorpay disputes. Import payment ID, dispute ID, amount in rupees, reason, status, and respond-by date. Sort by respond-by date ascending. Add a "Days Until Deadline" column. For any dispute where the respond-by date is in the past, write "OVERDUE" in a "Status Flag" column. Then write a summary in cell H1: total active disputes, total overdue, total disputed amount in rupees, and average days remaining for non-overdue disputes.
The pattern: the data pull, the urgency calculation, the overdue flag, and the summary all come out of one prompt.
Try It
Get the 7-day free trial of SheetXAI and open a blank sheet, then ask it to pull your active Razorpay disputes and build the triage view. The Razorpay integration is included in every SheetXAI plan. For related workflows, see how to cross-reference refunds against your logged requests or the Razorpay in Google Sheets overview.