facelordgists
2/28/2017 - 12:45 AM

Get favicon href url in a Google Sheet via importXML and xpath

Get favicon href url in a Google Sheet via importXML and xpath

xpath

/html/head/link[@rel='shortcut icon' or @rel='Shortcut Icon' or @rel='icon'][1]/@href

show the favicon as an image in a google sheet

=image(ImportXML("http://www.smilesbygriffin.com", "/html/head/link[@rel='shortcut icon' or @rel='Shortcut Icon' or @rel='icon'][1]/@href"))