Google Sheets SEO
Extract Meta Description
=IMPORTXML($A1,"//meta[@name=’description’]/@content").
Extract Title
=IMPORTXML($A1,"//meta[@property='og:title']/@content")
=IMPORTXML($A1,"//title")
=IMPORTXML($A1,"//meta[@name=’description’]/@content").
=IMPORTXML($A1,"//meta[@property='og:title']/@content")
=IMPORTXML($A1,"//title")