The Scenario
You are a billing manager at a B2B services firm. End of the month. 80 outstanding invoices in an Excel workbook — customer email in column A, amount in column B, invoice description in column C.
Each one needs a Razorpay payment link. Last month you created them manually in the Razorpay dashboard. Two and a half hours. Three wrong amounts. Two clients who paid old invoices because the links had no expiry.
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 Excel, paste it in the right row
- Repeat eighty times across multiple browser tabs
- On link 73, realize you've been entering amounts in rupees when the API wanted paise. Start over.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook 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 workbook, 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 correct amounts and expiry dates, and writes each URL back to column D.
What You Get
A workbook with 80 payment link URLs in column D:
- One URL per row — 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
You can run a mail merge immediately. Column A has the email, column D has the URL.
What If the Data Is Not Quite Ready
When some amounts are formatted as "₹12,500.00"
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
Column F has an explicit due date for 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 only want links for overdue invoices
Column G has the invoice date. You only want 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 note per client
For each row in this workbook: strip 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 note referencing the client name from column A and the amount from column B.
The pattern: data cleanup, API calls, and follow-up copy all in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open your invoice workbook, 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 in Excel or the Razorpay in Excel overview.