The Scenario
You're a digital goods seller setting up Quaderno for the first time. Your entire product catalog — 90 SKUs — is already in a Google Sheet from the previous billing system: column A is SKU, column B is product name, column C is unit price in USD, column D is the tax code. Before you can issue a single invoice in Quaderno, every product needs to exist in the system so it can be referenced by line item. You'd rather spend the afternoon configuring your first invoice template than creating products one at a time.
The bad version:
- Open Quaderno, click Products, click New, enter the SKU into the code field, type the product name, set the price, select the tax code from a dropdown (which requires knowing Quaderno's taxonomy for digital goods), click Save, copy the returned product ID, switch back to the sheet, paste it into column E
- Repeat 89 more times
- Discover partway through that your tax codes don't match Quaderno's expected values — some of your rows say "DIGITAL" but Quaderno wants "digital_goods_ebooks" — and now you have to go back and fix the ones you've already created
You have a catalog to load, not a taxonomy to learn.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet that reads your product data and creates the Quaderno products for you.
Create a Quaderno product for each row in this sheet — column A is SKU, B is name, C is unit price in USD, D is tax code — write the returned product ID to column E
What You Get
- One Quaderno product is created per row using the SKU, name, price, and tax code from that row
- The returned Quaderno product ID writes to column E as each product completes
- Products with unrecognized tax codes are flagged in column F rather than failing silently
- After the run, every SKU in the sheet maps to a Quaderno product ID in column E, ready for line item reference
What If the Data Is Not Quite Ready
The prices are in multiple currencies — some USD, some GBP
Create a Quaderno product for each row — SKU in A, name in B, price in C, currency in D, tax code in E — write the product ID to column F
The tax codes in my sheet don't match Quaderno's taxonomy
For each row in this sheet, map the tax code in column D to the closest Quaderno tax code (column D values are: DIGITAL, PHYSICAL, SERVICE), create the Quaderno product using SKU from A, name from B, price from C, and the mapped code — write the product ID to column E and the mapped tax code to column F
Some SKUs already exist in Quaderno and I don't want to create duplicates
For each row in this sheet, check if a Quaderno product already exists with the SKU in column A — if yes, write the existing product ID to column E and skip creation; if no, create the product using columns A through D and write the new ID to column E
Clean up tax codes, create all products, and flag any that need review in one pass
For each row: map the tax code in column D to a valid Quaderno code and update column D; then create the Quaderno product using SKU from A, name from B, price from C, and the corrected tax code — write the product ID to column E; if the mapping was ambiguous, write Needs Review to column F
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet where your product catalog lives, then ask it to push all 90 products into Quaderno before you start invoicing. Also see: bulk creating invoices from a sheet, and the hub overview of all Quaderno connection methods.