Creating an invoice in Xero from Excel using Watch Worksheet Rows

What are you trying to achieve?

Create invoices in Xero automatically when rows are added to an Excel table, where each invoice has mutiple line items. Each line item is one row in Excel.

Steps taken so far

I have been able to upload single line item invoices. The problem I encounter is that the Line Items option in the array aggregator when linked to Xero doesnt have fields for invoice date and due date, which are repeated for every line on each invoice invoices. I have no way of calling them in the create invoice module, unless you custom configure the array aggregator. However, when I do that, you need to create a custom line item array in the create invoice module, which is leading to the error message in he screenshot. The second screenshot shows the (attempt) at creating a custom array. Any help greatly appreciated.

Screenshots: scenario setup, module configuration, errors


Hey Robert,

that is not an array of items you have mapped there, that is just a string of text. I assume you need to map the array coming from the Array aggregator.