The Scenario
You are the head of operations at a subscription box company. You have 35 products in a Google Sheet — name in column A, description in column B, unit price in paise in column C.
Every month, your billing team creates recurring invoices in Razorpay. Right now they have to manually search for the product name in the Razorpay item catalog to get the item ID before adding it to an invoice. Searching 35 products, one at a time, every invoice cycle.
The root cause: the item catalog in Razorpay was never built from the sheet. The two systems are out of sync and your billing team pays for it every month.
The slow version:
- Log into the Razorpay dashboard, go to Items
- Click "Create Item" for each product
- Type the name, description, and unit amount
- Copy the item ID, paste it back into the sheet
- Repeat 35 times
- Realize on item 28 that you've been entering amounts in rupees, not paise. Start over.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that can create all 35 Razorpay items from the sheet and write each item ID back, without you opening the Razorpay dashboard.
Open the SheetXAI sidebar and type:
For each product in this sheet, create a Razorpay item using the name in column A, description in column B, and unit price in paise in column C. Write the resulting item ID to column D. Log any error in column E.
SheetXAI creates all 35 items in Razorpay and writes each item ID back to column D. Your billing team now has the IDs they need, in the same sheet, next to the product names they already know.
What You Get
A fully linked product sheet:
- Column D — the Razorpay item ID for every product
- Column E — any error for rows that failed, blank if it succeeded
- Ready for invoice creation — billing team references column D instead of searching the dashboard
The monthly invoice cycle is now a lookup, not a search. Column A is what your team knows, column D is what Razorpay needs. The sheet bridges the two.
If a product already exists as an item in Razorpay, ask SheetXAI to fetch the existing item ID by name instead of creating a duplicate. It handles the check inline.
What If the Data Is Not Quite Ready
Product sheets have formatting issues. SheetXAI handles them in the same prompt.
When unit prices are in rupees, not paise
Column C has values like 499.00 (rupees) instead of 49900 (paise).
Before creating the Razorpay items, multiply all values in column C by 100 to convert from rupees to paise. Then create the items using the name in column A, description in column B, and converted unit price. Write the item ID to column D.
When some products have the same name as existing Razorpay items
You want to avoid duplicates without checking manually.
For each row, search Razorpay items by the name in column A. If an item with that name already exists, write the existing item ID to column D and write "Existing — not created" to column E. If no matching item is found, create a new one and write the new item ID to column D.
When descriptions need to be generated from the product name and price
Some rows in column B are empty. You want a short description generated automatically.
For each row where column B is empty, generate a one-sentence description based on the product name in column A and the unit price in column C. Write the generated description to column B. Then create the Razorpay item using the name, description, and unit price. Write the item ID to column D.
When you want the full catalog build — normalize prices, generate missing descriptions, create items, and log IDs
Multiply all values in column C by 100 to convert from rupees to paise. For rows where column B is empty, write a one-sentence product description based on column A and the converted price. Then create a Razorpay item for each row using name, description, and unit price in paise. Write the item ID to column D and any errors to column E.
The pattern: the data normalization, the description generation, and the API calls all happen in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open your product sheet, then ask it to create the Razorpay items and write the IDs 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.