Read XML file and store content in Google Sheets
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: Item Lists (legacy). 1 breaking item(s) found. Static check, last run 2026-10-19.
What to replace before upgrading
| Removed in 3.0 | Replace with |
|---|---|
| Item Lists (legacy) Split out food items | Split Out, Aggregate, Sort, Limit, Remove Duplicates or Summarize (match the operation used) |
Nodes used (7)
- Manual Trigger
n8n-nodes-base.manualTrigger - HTTP Request
n8n-nodes-base.httpRequest - XML
n8n-nodes-base.xml - Google Sheets
n8n-nodes-base.googleSheets - Edit Fields (Set)
n8n-nodes-base.set - Item Lists
n8n-nodes-base.itemLists - Merge
n8n-nodes-base.merge
What it does
This workflow shows a low code approach to parsing an XML file and storing its contents in a Google Sheets spreadsheet. !image.png(fileId:681) To run the workflow: Make sure you are running n8n 0.197 or newer Have n8n authenticated with Google Sheets How it's done: 1. This workflow first downloads an example file using the HTTP Request node and reads this file using the XML node. !image.png(fileId:682) 2. It then runs the Item Lists node to split out the individual food items from the example file. 3. It then splits up the workflow into a separate branch creating a new spreadsheet file using the Google Sheets node. To read the column names we're using the Object.keys() method inside a Set node. 4. Once the spreadsheet is created (the workflow waits for this using the Merge node), the data is appended to the newly created sheet (again using the Google Sheets node).