Community Contributed: XML to Google Sheets

Name: Community Contributed: XML to Google Sheets
Rating: 3.0 (1 reviews)
Author: Free N8N

Beginner

0 nodes connected

detail.loadingPreview

Free N8N Temples

17 views

0 downloads

Data Integrationautomationdata processinggoogle sheetsspreadsheetxml

This workflow downloads an XML file, parses its content, and writes the data to a Google Sheet.

🚀Ready to Deploy This Workflow?

⚡Deploy on Zeabur 🎁Get $200 Credit on DigitalOcean

About This Workflow

Overview

This workflow is designed to automate the process of taking data from an XML source and populating a Google Sheet with it. It's a useful template for anyone needing to bridge data between XML formats and spreadsheet applications. The workflow handles the download, parsing, and structured writing of the data.

Key Features

Downloads an XML file from a specified URL.
Parses the downloaded XML content into a structured format.
Splits out specific items from the parsed XML for further processing.
Creates a new Google Sheets spreadsheet.
Defines and writes a header row to the spreadsheet.
Appends the parsed data to the Google Sheets spreadsheet.

How To Use

Ensure you have a Google Sheets API credential set up in n8n.
Configure the Download XML File node with the correct URL of your XML data.
Adjust the Split out food items node (or rename it to be more descriptive) to target the correct XML element that contains the data you want to extract.
The Create new spreadsheet file node will create a new Google Sheet. You can customize the title or let it default to 'My XML Data'.
The workflow automatically handles writing the header and appending the data. Run the workflow manually by clicking the 'execute' button.

Apps Used

automation

data processing

google sheets

spreadsheet

xml

Workflow JSON

{
  "id": "b279075a-33c2-4f6c-b46e-d6bbd0ee5414",
  "name": "Community Contributed: XML to Google Sheets",
  "nodes": 0,
  "category": "Data Integration",
  "status": "active",
  "version": "1.0.0"
}

Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.