What it does
This n8n template downloads an example XML file, parses it and splits out the individual items. It then creates a new spreadsheet, takes the column names from the item keys and appends the data to a sheet. A Merge node makes sure the data is written only after the spreadsheet exists.
Use cases
- 01Turn an XML product list into rows
- 02Create a new sheet for each XML import
- 03Split an XML file into one row per item
Connects
Google Sheets · HTTP Request