I need Zapier to create a single Xero invoice with multiple separate line items (not combined into one description).
Data comes from one Google Sheets row with up to 3 products in separate columns.
In the Xero “Create Sales Invoice” action, I only see fields for one line item (Description, Qty, Unit Price), and when I try to map multiple products, Zapier either:
-
merges them into a single line, or
-
forces multiple invoices instead of multiple lines.
Question:
What is the correct way in Zapier to create 2–3 separate invoice rows on a single Xero invoice?
-
Is there a hidden way to expose Line Item 2 / 3 fields?
-
Or does Xero require line items to be passed as a structured array?
-
Has anyone successfully done this without concatenating descriptions or creating multiple invoices?
I’m looking for the Zapier-native, reliable method to get distinct invoice rows in Xero.
