Recap of IMPORTXML bits SEOs should love:
Fetch the title:
=IMPORTXML(A2, "//title")
Get the meta description:
=IMPORTXML(A2, "//meta[@name='description']/@content")
Get the H1 :
text
=IMPORTXML(A2, "//h1")
Get the Open Graph Title:
=IMPORTXML(A2, "//meta[@property='og:title']/@content")
9 days ago