Google Sheets SEO

Extract Meta Description

=IMPORTXML($A1,"//meta[@name=’description’]/@content").

Extract Title

=IMPORTXML($A1,"//meta[@property='og:title']/@content")

=IMPORTXML($A1,"//title")