Describe the problem/error/question
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
But my workflow have result like this
This is my workflow
Help me please !! Thanks you so much !
Information on your n8n setup
- **n8n version:1.92.2
- **Database (default: SQLite):none
- n8n EXECUTIONS_PROCESS setting (default: own, main):
- **Running n8n via (Docker, npm, n8n cloud, desktop app):docker
- **Operating system:windows64
Hello @plj09876 welcome in the community!
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).
Lmk! Cheers
