In the last post I described how I eventually managed to import a Google XML sitemap file into Google sheets. In short, this:
=importxml("http://example.com/sitemap.xml","//*[local-name() = 'url']")
I’ve been building on that recently and thought I’d share a few ways I’ve been using it.
- Filtering the sitemap by path
- Filtering the sitemap by date
- Counting pages