Google Sheets for SEO

Google Sheets - Formulas

XML for SEO
The IMPORTXML function allows you to quickly import content from websites using XML markup.

Some examples include:

Task	Formula
Obtain Title	=IMPORTXML("www.exampleurl.com", "//title")
Meta Keywords	=IMPORTXML("www.exampleurl.com", "//meta[@name='keywords']/@content")
Open Graph Image	=IMPORTXML("www.exampleurl.com", "//meta[@property='og:image']/@content")
Fetch H1 Tags	=IMPORTXML("www.exampleurl.com", "//h1")
Fetch External Links	=IMPORTXML("www.exampleurl.com", "//a[@href and not(starts-with(@href, '/'))]/@href")
Extract Structured Data (JSON-LD)	=IMPORTXML("www.exampleurl.com", "//script[@type='application/ld+json']")
Count Images	=IMPORTXML("www.exampleurl.com", "count(//img)")
Fetch Alt Attributes	=IMPORTXML("www.exampleurl.com", "//img/@alt")