The Scenario
It's the last working day of the month. You have a Google Sheet with 25 completed project rows — each with a client ID, issue date, currency, line item description, and amount — and every one of those rows needs to become an Elorus invoice before tomorrow morning so the billing run goes out on time.
The bad version:
- Open Elorus, click "New Invoice," select the client from the dropdown, type the issue date, add the line item description, enter the amount, save, copy the invoice ID, paste it back into column F of your sheet, move to row two.
- Repeat that sequence twenty-four more times, tabbing between the browser and the spreadsheet each time, hoping you don't mix up which client gets which amount.
- At row eighteen, realise you pasted the wrong invoice ID into column F for row twelve, go back to Elorus to find the right one, fix the sheet, and lose ten minutes you didn't have.
The month-end billing run is not the place to discover a data entry error at row twelve. Your accountant is waiting for the invoice IDs. The clients are expecting their invoices tonight.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your billing table, understands the column structure, and talks to Elorus on your behalf. You don't export, you don't tab between windows, you just describe what you need.
Create an Elorus invoice for each row in the "Billing" tab — columns are client_id (A), issue_date (B), currency (C), line item description (D), and amount (E) — and write the returned invoice ID to column F
What You Get
- One Elorus invoice created per row in the Billing tab, using the exact client, date, currency, and line item data from each row.
- The Elorus-generated invoice ID written back to column F of the same row as each invoice is created.
- Any rows that fail validation — missing client ID, unsupported currency code — flagged in column G with the error message so you can fix and re-run just those rows.
- No partial-run ambiguity: you can see at a glance which rows succeeded and which need attention.
What If the Data Is Not Quite Ready
The currency codes are in a format Elorus doesn't recognise
Your sheet has "USD" but some rows have "US Dollar" or "dollars" written out. Elorus expects ISO currency codes.
For each row in the "Billing" tab where column C contains a full currency name instead of a 3-letter code, normalise it to the ISO code, then create the Elorus invoice and write the invoice ID to column F
Some rows are missing the client ID
The client_id column is empty for four rows where the client was added late and the ID hasn't been filled in yet.
Skip any rows in the "Billing" tab where column A is blank, write "MISSING CLIENT ID" to column F for those rows, and create Elorus invoices for all other rows with valid client IDs
The line items live in a separate tab
Your billing table has one row per project but the actual line item detail — description, quantity, unit price — lives in a "Line Items" tab keyed by project ID.
Join the "Billing" tab (column A = project_id) with the "Line Items" tab (column A = project_id) to assemble the full line item detail for each project, then create an Elorus invoice per project with all matching line items, writing the invoice ID to column F of the "Billing" tab
Clean up currency formats, check for duplicates, and create invoices in one shot
In the "Billing" tab, first normalise any full currency names in column C to ISO codes, then check column F for any rows that already have an invoice ID and skip them, then create Elorus invoices for the remaining rows and write each invoice ID to column F — flag any rows that fail with the error reason in column G
The rule of thumb: describe the cleanup and the action in the same prompt, and SheetXAI handles both in sequence.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet where you stage your monthly billing data, then ask it to convert the rows into Elorus invoices and write the IDs back. You can also look at exporting your existing Elorus invoices into a sheet or the hub overview for connecting Elorus to Google Sheets.