How to extract all URLs from a sitemap (and export them to CSV)

Pull every URL out of a website's XML sitemap, including nested sitemap indexes and .gz files, and save it as CSV. Python and Node scripts, pitfalls, and how to let an AI agent do it over MCP.