The Scenario
You are an operations lead at an online store. Last month ended two days ago and your head of finance just sent a message: how many orders from last month are still unpaid?
You have 800 Razorpay orders from last month. Some are fully paid, some are partially paid, some are still in "created" status — meaning the customer initiated checkout but never completed payment.
Getting this answer from the Razorpay dashboard means clicking into each order or exporting a CSV and writing conditional formulas to identify the gaps.
The slow version:
- Log into Razorpay, navigate to Orders, filter by last month
- Export the CSV — 800 rows, 15 columns, none of them immediately usable
- Open in Sheets, identify the "status" column, add a filter
- Realize "status" for orders doesn't directly tell you if payment was captured — you need to cross-reference the payments
- Build a lookup formula between the orders sheet and the payments sheet
- Spend ninety minutes on a question that should take five.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that can pull Razorpay orders, identify unpaid ones, and flag them, without you touching the dashboard.
Open the SheetXAI sidebar and type:
Fetch all Razorpay orders from the last 30 days. Import order ID, amount in rupees (convert from paise), order status, receipt number, and creation date into this sheet. Then add a column called "Payment Status" — write "Unpaid" for orders with status "created," "Fully Paid" for orders with status "paid," and "Partially Paid" for orders where the amount paid is less than the order amount. Sort by Payment Status so "Unpaid" rows appear first.
SheetXAI pulls all 800 orders, writes the data into the sheet, evaluates payment status per row, and sorts the result.
What You Get
An orders sheet with every row evaluated:
- Order ID, amount, status, receipt, creation date — one row per order
- "Payment Status" column — "Unpaid," "Fully Paid," or "Partially Paid" for each row
- Unpaid rows at the top — sorted so your follow-up list is already in the right order
The head of finance gets a direct answer: X orders are unpaid, totalling ₹Y. You did not run a single formula.
If you want a summary count at the top of the sheet, ask SheetXAI to add it. It writes the totals into a header row without overwriting the data.
What If the Data Is Not Quite Ready
Order status data from Razorpay has nuances. SheetXAI handles them inline.
When you need to distinguish orders that are old enough to be abandoned
An order that is 5 days old and still "created" is different from one that was created 2 hours ago.
Fetch all Razorpay orders from the last 30 days. For orders with status "created," add a column called "Age (days)" showing how many days old the order is. Flag orders older than 3 days as "Abandoned" and newer ones as "Pending."
When you want the partial payments to show how much is outstanding
For partially paid orders, the outstanding amount is what matters for follow-up.
Fetch all Razorpay orders from the last 30 days. For orders with status "paid," write "Fully Paid" in column F. For orders where the amount captured is less than the order amount, calculate the outstanding balance (order amount minus captured amount) and write it in column F as "Outstanding: ₹[amount]."
When you need to filter to orders above a certain value
Small orders don't warrant individual follow-up. You want to focus on orders above ₹5,000.
Fetch all Razorpay orders from the last 30 days where the order amount is more than ₹5,000 (500,000 paise). Import order ID, amount in rupees, status, and receipt. Flag unpaid and partially paid orders in column E. Sort by amount descending.
When you need the full picture — pull orders, evaluate status, flag abandoned, and summarize
Fetch all Razorpay orders from the last 30 days. Import order ID, amount in rupees, status, receipt, and creation date. Add a "Payment Status" column: "Fully Paid," "Unpaid," or "Partially Paid." For unpaid orders older than 3 days, change the label to "Abandoned." Then write a summary starting in cell H1: total orders, total fully paid, total unpaid, total abandoned, total value of unpaid and abandoned orders combined.
The pattern: the data pull, the status logic, the age filter, and the summary all happen in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open a blank sheet, then ask it to pull your last 30 days of Razorpay orders and flag the unpaid ones. The Razorpay integration is included in every SheetXAI plan. For related workflows, see how to export payments for reconciliation or the Razorpay in Google Sheets overview.