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 this workflow does
This workflow has 9 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets. It also calls w3schools.com over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Download XML File (HTTP Request): calls w3schools.com
- Parse XML content (XML): converts between XML and JSON
- Split out food items (Item Lists): reshapes item lists (legacy Item Lists node)
- Create new spreadsheet file (Google Sheets): work with spreadsheet
- Wait for spreadsheet creation (Merge): merges the data from its input branches
- Define header row (Edit Fields (Set)): sets or maps fields
- Write data to sheet (Google Sheets): append
- Write header row (Google Sheets): update
Services it uses
HTTP calls to: w3schools.com
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- Item Lists (legacy) in Split out food items: replace with Split Out, Aggregate, Sort, Limit, Remove Duplicates or Summarize (match the operation used).
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| 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
From the author
This workflow shows a low code approach to parsing an XML file and storing its contents in a Google Sheets spreadsheet. 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…