The Scenario
It's the last working day of the month. You run a small agency and your Google Sheet has 80 rows in the Billing tab — one per client project delivered this month. Column A holds the Quaderno contact ID, column B has the service description, column C has the amount in USD. You need all 80 invoices created in Quaderno before midnight, because your payment terms start the clock from issue date.
The bad version:
- Open Quaderno, click New Invoice, paste the contact ID from column A, type the description from column B, enter the amount from column C, set the currency, click save, copy the invoice number, switch back to the sheet, paste it into column D, move to row 2
- Repeat 79 more times, checking each time that you haven't mixed up the tab focus and pasted the wrong value into the wrong field
- Hit row 60 at 10 PM and realize you transposed two contact IDs three rows back, which means two clients just got invoices for each other's projects
You were hired to run client work, not to be a data relay between a spreadsheet and a billing platform. And month-end close is not the moment to find out you've been misattributing invoices.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet that reads your data and talks to Quaderno on your behalf. You describe the task; it handles the API calls.
Create a Quaderno invoice for each row in the Billing tab — column A is contact ID, column B is product description, column C is unit price in USD — write the returned invoice number to column D
What You Get
- Quaderno creates one invoice per row using the contact ID, description, and amount from that row
- The returned invoice number writes back to column D as each invoice completes
- Any row with a missing or malformed contact ID is flagged in column E with a short error note, leaving the rest unaffected
- You end up with a complete audit trail in the sheet — every row either has an invoice number or a clear reason why it doesn't
What If the Data Is Not Quite Ready
The currency column is mixed — some rows are USD, some are EUR
Create a Quaderno invoice for each row in the Billing tab — column A is contact ID, B is description, C is amount, D is currency code (USD or EUR) — write the invoice number to column E
Some contact IDs are missing and I need to look them up from a Clients tab first
For each row in Billing where column A is blank, look up the contact ID in the Clients tab using the company name in column F, then fill column A, then create the Quaderno invoice and write the invoice number to column D
I only want to invoice rows where the status in column E is "Approved"
Create Quaderno invoices only for rows in the Billing tab where column E says Approved — use contact ID in A, description in B, amount in C — write the invoice number to column D
Clean up, invoice, and flag anything that needs follow-up in one pass
For each row in Billing: if column E is Approved and column A has a valid contact ID, create a Quaderno invoice using B for description and C for amount, write the invoice number to D; if column E is not Approved or column A is blank, write Needs Review to column F
The pattern is to ask for the conditional logic and the action together. SheetXAI evaluates each row and acts accordingly rather than requiring you to pre-clean the sheet.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet where you track client billing, then ask it to push the approved rows to Quaderno. Also worth reading: how to pull a Quaderno invoice report into a sheet, and the hub overview of all Quaderno connection methods.