The Scenario
Your agency just decided to standardise on Elorus for invoicing. You have forty service offerings in a spreadsheet — name, unit price, tax rate, and description — that all need to be in the Elorus product catalogue before anyone can start issuing invoices. Someone suggested entering them manually. You opened Elorus, clicked "New Product," filled in the first three fields, and stopped.
The bad version:
- Click "New Product" in Elorus, type the service name, enter the unit price, select the tax rate from the dropdown, paste the description, click Save.
- Move back to the spreadsheet, find row two, repeat the sequence for the next service, this time noticing the description has a line break in it that Elorus's field doesn't accept.
- At row fifteen, realise you entered the wrong unit price for row eight and now have to find that product in Elorus to fix it, which costs another five minutes you weren't planning to spend.
Forty products at roughly four minutes each is two and a half hours of clicking through a form. The catalogue needs to be ready before the invoicing team can start Monday morning.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your service catalogue, interprets each row, and creates the corresponding Elorus product records through the built-in integration.
Create an Elorus product for each row in the "Services" tab — columns are name (A), description (B), unit price (C), and tax ID (D) — and write the new product ID to column E
What You Get
- One Elorus product record created per row in the Services tab.
- The Elorus-generated product ID written to column E of each row as the product is created, giving you a reference for future invoice line items.
- Rows that fail — invalid tax ID, price format issue — flagged in column F with the specific error so you can correct and re-run just those rows.
- The full catalogue available in Elorus immediately, no manual clicking required.
What If the Data Is Not Quite Ready
The unit prices are formatted with currency symbols
Your spreadsheet has "$150.00" in column C instead of a clean numeric value. Elorus expects a number.
For each row in the "Services" tab, strip the currency symbol and commas from column C to get a plain numeric value, then create the Elorus product using name (A), description (B), cleaned price (C), and tax ID (D), writing the product ID to column E
Some descriptions are too long for the Elorus field
A few of your service descriptions run over 500 characters, which causes a validation error.
For each row in the "Services" tab, if column B is over 500 characters trim it to the first 497 characters and add "..." — then create the Elorus product with the trimmed description and write the product ID to column E
The tax IDs are in a lookup table on a second tab
Your catalogue tab has a "Tax Category" label in column D but the actual Elorus tax IDs live in a "Tax Rates" tab with category names in column A and IDs in column B.
Join the "Services" tab (column D = tax category name) against the "Tax Rates" tab (column A = category name, column B = Elorus tax ID) to resolve the correct tax ID for each row, then create the Elorus product and write the product ID to column E
Clean up formatting, resolve tax IDs, skip duplicates, and create products in one shot
In the "Services" tab, strip currency symbols from column C, trim descriptions over 500 characters to 497 + "...", look up each tax category in column D against the "Tax Rates" tab, skip any rows where column E already has a product ID, create Elorus products for the remaining rows, and write each new product ID to column E — flag failures in column F
When the catalogue is clean before it hits Elorus, you don't spend Monday morning fixing import errors.
Try It
Get the 7-day free trial of SheetXAI and open the spreadsheet where your service catalogue lives, then ask it to push every row into the Elorus product library. You can also look at bulk creating invoices from a sheet or the hub overview for connecting Elorus to Google Sheets.