Templates / Extract sitemap URLs to CSV using chat input, XML parsing and HTTP upload

Extract sitemap URLs to CSV using chat input, XML parsing and HTTP upload

Ready for 3.0

by Siddharth Gupta ✓ · 72 views · created 2026-05-02 · Market Research, AI Chatbot

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What 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.

  1. Fetch Sitemap XML (HTTP Request): calls an HTTP API
  2. Check if URL is Accessible (If): checks a condition and branches into true / false
  3. Alert User: Invalid URL (Chat): uses Chat
  4. Parse XML to JSON Object (XML): converts between XML and JSON
  5. Check for Sitemap Index (If): checks a condition and branches into true / false
  6. Alert User: Index Not Supported (Chat): uses Chat
  7. Extract URLs Array (Split Out): splits a list into separate items
  8. Format URL Data (Edit Fields (Set)): sets 2 fields: loc, lastmod
  9. Summarize: summarizes / groups the items
  10. 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)

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…

Excerpt from Siddharth Gupta's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.