Hi guys. Im new to n8n. I am doing a project to receive xml email invoices → read xml file → import into google sheet. The problem is when I receive invoices with 1 person buying many products, the google sheet is blank. For example i want same company but different product and price like this
After parsing your XML file, the result likely contains an array of items inside a single record (e.g. one invoice, multiple products).
If that array isn’t properly split into separate items, only the first item (or none) may be written to the sheet.
Use a “Split Out” node (Item Lists)
Add or check the Split Out node after converting XML to JSON.
Set it to “Split Out Items” on the array field that holds the products.
This will turn each product into a separate item that the Google Sheets node can process individually.
Make sure you’re splitting at the right level (for example, if it’s invoice.products.product[], you need to split at product[] i guess).
