How To extract URLs of Sitemap in Google Sheets | Bulk URL Extractor | SEO HACK WITH GOOGLE Sheet

How To extract URLs of Sitemap in Google Sheets?

How to simply get all the URLs of your sitemaps in a Google sheet without any help of a tool.

It's the best SEO hack with Google Sheet you have ever seen.

Now you can extract all the URLs in the sitemap using Google sheet with just a formula.

But How? 🤔🤔

1) Open Google sheets
2) Go-To Tools
3) Go To Script Editor
4) Add A script mentioned below

5) Run The Script
7) In another tab use the formula =getsitemap(cell number)

It will automatically extract all the URLs of the sitemap.

If you find this helpful then kindly share and do like and comment.

Do subscribe to my youtube channel!

#searchengineoptimization #seotechniques #seo #seotipsandtricks #seotips #seotips2021
#searchengineoptimizationseo #searchengineoptimizationtips #seotricks #seotricks2021 #seowithexcel #searchengineoptimisationexpert #searchengineoptimisation

[sachinseo]

Script - SEO HACK WITH GOOGLE DOC (1)
How to simply get all the URLs of your sitemaps in an excel sheet without any help of a tool.

Now you can extract all the URLs in the sitemap using Google doc.

But How? 🤔🤔

1) Open Google Doc
2) Go To Tools
3) Go To Script Editor
4) Add A script mentioned below

function getSitemap(url) {
var results=[];
if(!url)return;
var sitemap=UrlFetchApp.fetch(url, {muteHttpExceptions:true, method:"GET", followRedirects:true});
var document = var docHead=document.splice(0, 1);

for(var i=0;i<document.length;i++) results.push(document[i].split("</loc>")[0].split("<loc>")[1].replace(/&amp;/g, "&"));

return results;
}

5) Run The Script
6) Now go back to the sheet and put sitemap url in one tab. eg abc.com/sitemap.xml
7) In another tab use the formula =getsitemap(cell number)

It will automatically extract all the URLs of the sitemap.

If you find this helpful then kindly share and do like and comment.

[carsclubmotors]

script is not running getting erro can you please help me to fix it