Read XML file and store content in Google Sheets

n8n template #1810

Summary

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: This workflow first downloads an example file using the HTTP Request node and reads this file using the XML node. It then runs the Item Lists node to split out the individual food items from the example file. 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. Once the spreadsheet is created (the workflow waits

How to set it up

Open template #1810 on n8n.io and click Use for free, or copy the template JSON and paste it onto an empty canvas in n8n.
Create a credential under Credentials → Add credential: Google Sheets. Then open each of those nodes and pick the credential.
Click Execute workflow and step through each node's output to confirm the data looks right.
Toggle the workflow to Active so its trigger runs on its own.

Hand off to your agent

Prompt

Help me set up the n8n workflow "Read XML file and store content in Google Sheets" (https://n8n.io/workflows/1810). It uses: Google Sheets, HTTP Request. Import the template JSON into my n8n instance, list every credential I need to create, and walk me through testing it.

Paste into Claude Code and it will do the rest.

Apps and nodes

Google Sheets HTTP Request

Questions

Yes. Tom published it free on n8n.io as a verified creator, and it has 5,083 views. It runs on n8n Cloud or a self-hosted n8n instance.

Google Sheets. The other 1 node are built into n8n.

Similar workflows

NameViews