The Scenario
You're a Shopify merchant whose accountant processes a weekly order export every Monday. The export comes out of Shopify as an Excel workbook: 200 rows per week, with customer contact IDs in column A, sale amounts in column B, currencies in column C, and order dates in column D. For each row, a Quaderno transaction needs to be created so that the corresponding invoice generates automatically. Right now your accountant is doing this one row at a time.
Your accountant mentioned this to you in passing. What they actually said was: "I do this for about two hours every Monday. I've been doing it for eight months."
The bad version:
- Open Quaderno, click New Transaction, enter the contact ID, amount, currency, date, click save, note the returned transaction ID, switch to the workbook, paste into column E
- Repeat 199 more times
- Notice partway through that some contact IDs in column A refer to guest checkout orders where no Quaderno contact was ever created — those transactions fail silently and the corresponding invoices never generate
Two hours every Monday, times eight months, is not a workflow. It's a liability.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that reads your order export and creates Quaderno transactions in bulk.
For all 200 order rows in this Excel sheet, create Quaderno sale transactions (contact ID in A, amount in B, currency in C, date in D) and write the generated invoice number to column E
What You Get
- One Quaderno transaction is created per row using the contact ID, amount, currency, and date from that row
- The invoice that Quaderno auto-generates from each transaction is associated with the correct contact and date
- The generated invoice number writes to column E as each transaction completes
- Guest checkout rows where no Quaderno contact exists are flagged in column F rather than failing silently
What If the Data Is Not Quite Ready
Some rows are refunds, not sales — they should be credit transactions
For each row in this workbook, create a Quaderno sale transaction if column E says Sale, or a credit transaction if column E says Refund — use contact ID from A, amount from B, currency from C, date from D — write the transaction ID to column F
Guest checkout rows have an email in column F instead of a contact ID in column A — I need to create the contact first
For rows where column A is blank but column F has an email address, create a Quaderno contact for that email address and write the new contact ID to column A; then create the transaction for every row using contact ID from A, amount from B, currency from C, date from D, and write the transaction ID to column E
I need both the transaction ID and the generated invoice number written back
Create a Quaderno transaction for each row — contact ID in A, amount in B, currency in C, date in D — write the transaction ID to column E and the auto-generated invoice number to column F
Process all transactions, handle refunds separately, and compute weekly revenue in one pass
For each row: if column E says Sale, create a Quaderno sale transaction; if column E says Refund, create a credit transaction — use contact ID from A, amount from B, currency from C, date from D; write the transaction ID to column F; then compute total net revenue (sum of sale amounts minus sum of refund amounts) and write it to cell H1
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook where your weekly Shopify order export lands, then ask it to push every row into Quaderno as a transaction so the invoices generate automatically. Also see: bulk creating invoices from an Excel workbook, and the hub overview of all Quaderno connection methods.