Extract sitemap URLs to CSV using chat input, XML parsing and HTTP upload
Ready for 3.0What this workflow does
This AI workflow has 16 nodes and runs when a chat message arrives. It uses only n8n's built-in nodes. It also calls uguu.se over HTTP.
How it runs
Trigger: When a chat message arrives.
- Fetch Sitemap XML (HTTP Request): calls an HTTP API
- Check if URL is Accessible (If): checks a condition and branches into true / false
- Alert User: Invalid URL (Chat): uses Chat
- Parse XML to JSON Object (XML): converts between XML and JSON
- Check for Sitemap Index (If): checks a condition and branches into true / false
- Alert User: Index Not Supported (Chat): uses Chat
- Extract URLs Array (Split Out): splits a list into separate items
- Format URL Data (Edit Fields (Set)): sets 2 fields: loc, lastmod
- Summarize: summarizes / groups the items
- Convert Data to CSV (Convert to File): converts data to a file
…plus 5 more steps. See the full node list below.
HTTP calls to: uguu.se
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (10)
- Chat Trigger
@n8n/n8n-nodes-langchain.chatTrigger - HTTP Request
n8n-nodes-base.httpRequest - If
n8n-nodes-base.if - Chat
@n8n/n8n-nodes-langchain.chat - XML
n8n-nodes-base.xml - Split Out
n8n-nodes-base.splitOut - Edit Fields (Set)
n8n-nodes-base.set - Convert to File
n8n-nodes-base.convertToFile - Code
n8n-nodes-base.code - Summarize
n8n-nodes-base.summarize
From the author
SEO Sitemap Extractor: Convert XML to CSV via Chat Interface This workflow provides a streamlined, no-code solution to extract all nested URLs from any standard XML sitemap and instantly convert them into a structured CSV file. Built entirely within n8n's…