GOOGLE SHEETS
Google Sheets is a powerful tool that can greatly simplify the analysis and tracking of our SEO campaigns through the use of native formulas, custom functions, and the installation of add-ons.
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") |