Insert, directly on google docs spriteshit, all indexed pages on google.com for a url

November 16th, 2015

Code form <!–¬†https://www.mathewporter.co.uk/list-a-domains-indexed-pages-in-google-docs/ –>

 

add on first cell :

 

=importXml(“https://www.google.com/search?q=site:www.yourdomainnamehere.com&num=100&start=1”; “//cite”)

 

add in the cell from 101

=importXml(“https://www.google.com/search?q=site:www.yourdomainnamehere.com&num=100&start=100”; “//cite”)

Change “..&start=100” with the number from where starts to extract.