AcademyWorkflowsData and reporting

Read XML and Store Its Content in Google Sheets

Data or operations staff who receive XML exports from another system and need them in a spreadsheet.

  • Recommendedour rating
  • 5,083views on n8n
Open on n8n.io ↗

Paste it straight onto an n8n canvas with Ctrl+V or Cmd+V.

read-xml-file-and-store-content-in-google-sheets.json

Loading the file...

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

  1. 01Turn an XML product list into rows
  2. 02Create a new sheet for each XML import
  3. 03Split an XML file into one row per item

Connects

Google Sheets · HTTP Request

Questions about
Read XML and Store Its Content in Google Sheets.

What is Read XML and Store Its Content in Google Sheets used for?

Data or operations staff who receive XML exports from another system and need them in a spreadsheet. 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.

How do I import Read XML and Store Its Content in Google Sheets into n8n?

Copy the workflow JSON from this page and paste it onto the n8n canvas with Ctrl+V or Cmd+V. Then connect your credentials in each node.

Is Read XML and Store Its Content in Google Sheets safe to use?

It passed our automatic scan for credential theft, hidden instructions and risky install commands. Third party open source software. Sabemos AI does not maintain it. Check the code and permissions before you connect it to company data.