Sitemap Page Extractor: Discover, Clean & Save URLs to Google Sheets

This workflow automates the discovery and extraction of all page URLs from a website's sitemap structure. Starting with a simple URL input via form, it generates and tests common sitemap paths like /sitemap.xml, /sitemap_index.xml, and /robots.txt. It identifies valid sitemaps by sending HTTP requests and filtering successful responses, then handles nested sitemaps by extracting and processing each sub-sitemap individually for complete coverage.

From valid sitemaps, it parses XML content to pull <loc> tags and additional HTML links, ensuring comprehensive URL collection. URLs containing 'sitemap' are filtered out to retain only content pages like products, services, or blogs. Finally, deduplicated clean URLs are appended to Google Sheets, ready for SEO audits, competitor analysis, or content inventory.

Benefits include massive time savings over manual crawling tools, high accuracy with nested sitemap support, and seamless Google Sheets integration for collaboration. Ideal use cases: SEO agencies tracking site health, marketers building content calendars from competitors' sitemaps, or developers maintaining URL inventories for migrations.