The Scenario
You are a billing manager at a B2B services firm. End of the month. 80 outstanding invoices sitting in a Google Sheet — customer email in column A, amount in column B, invoice description in column C.
Each one needs a Razorpay payment link so you can send clients a direct payment URL. You have done this before, manually, in the Razorpay dashboard. Last month it took two and a half hours and you still had three wrong amounts because you mis-read the sheet while copying.
The slow version:
- Log into the Razorpay dashboard
- Click "Create Payment Link" for each invoice
- Type the amount, paste the email, write the description
- Copy the short URL, switch back to Sheets, paste it in the right row
- Repeat eighty times
- Discover on link 73 that you have been creating links without expiry dates and clients are paying old invoices again
- Start calling clients to sort out the mess.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that reads the invoice rows and creates a Razorpay payment link per row, writing the URL back before moving to the next one.
Open the SheetXAI sidebar and type:
For each row in this sheet, create a Razorpay payment link using the customer email in column A, amount in column B (in rupees — convert to paise before sending), and description in column C. Set each link to expire in 14 days. Write the short payment link URL to column D. Log any error in column E.
SheetXAI reads all 80 rows, creates 80 Razorpay payment links with the right amounts, descriptions, and expiry dates, and writes each URL back to column D.
What You Get
A sheet with 80 payment link URLs in column D:
- One URL per row — each linked to the correct amount and client email
- Expiry set to 14 days — no link stays active indefinitely
- Column E — any error for rows that failed, so you can see exactly what needs manual attention
You can email the links immediately. Column A has the email, column D has the URL. Mail merge from the same sheet.
If you want the links to have a custom reference ID matching your internal invoice number, add it to the prompt. SheetXAI passes it through as the payment link reference.
What If the Data Is Not Quite Ready
Invoice sheets have edge cases. SheetXAI handles them inline.
When some amounts are in the wrong format
The sheet has amounts like "₹12,500.00" in some rows and plain numbers in others. The Razorpay API expects an integer in paise.
Normalize the amounts in column B — strip any currency symbols, commas, or decimal points — then convert to paise and create the Razorpay payment links. Write the URL to column D and any parse error to column E.
When some rows should get a different expiry date
Most invoices expire in 14 days, but column F has an explicit due date for a handful of high-value clients.
For each row, create a Razorpay payment link. If column F has a due date, use that as the expiry date. If column F is empty, default to 14 days from today. Write the link URL to column D.
When you want to send reminder payment links only for invoices that are overdue
You have an "Invoice Date" in column G. You only want to generate links for invoices older than 30 days with no payment yet.
Filter to rows where the date in column G is more than 30 days ago and column D is empty. For those rows only, create Razorpay payment links and write the URL to column D.
When you need the full pass — normalize amounts, set smart expiry, create links, and draft a follow-up email per client
The output of this spoke in one combined prompt.
For each row in this sheet: strip any currency symbols from column B and convert to paise. If column F has a due date, use it as the expiry; otherwise default to 14 days from today. Create a Razorpay payment link with the description in column C. Write the short URL to column D. Then in column E, draft a one-sentence follow-up email line I can copy into my email client, referencing the client name from column A and the amount from column B.
The pattern: the data cleanup, the API call, and the follow-up action all happen in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open your invoice sheet, then ask it to generate the payment links and write them back. The Razorpay integration is included in every SheetXAI plan. For related workflows, see how to bulk-create Razorpay invoices or the Razorpay in Google Sheets overview.