Google Sheets Snippets to Scrape Website Information

Scrape the Website Title

=IMPORTXML(B6;"//title/text()")

Scrape the Headline H1

=IMPORTXML(B6;"//h1/text()")

Scrape the Meta-Description

=IMPORTXML(B6;"//meta[@name='description']/@content")

Scrape the Canonical-URL

=IMPORTXML(B6;"//link[@rel='canonical']/@href")

Scrape the Open Graph Title

=IMPORTXML(B6;"//meta[@property='og:title']/@content")

Scrape the Open Graph Description

=IMPORTXML(B6;"//meta[@property='og:description']/@content")

Scrape the Open Graph Image

=IMPORTXML(B6;"//meta[@property='og:image']/@content")

+1

Leave a Reply