Thread by @_nitman

💜 Turn your GoogleSheets into a web scraping machine for SEO 💜

There is a lot that you can accomplish w/ GSheets. Let's start the new year with some super cool productivity hacks w/ the IMPORTXML function of it💡

#WebScraping #ProductivityHacks #GoogleSheets #SEO

It's a 🧵

1. Extract Title Tags

This IMPORTXML Formula extract the title tag from the URL that is on cell "A1"

2. Extract Meta Description

This IMPORTXML Formula extract the meta description tag from the URL that is on cell "A1"

3. Extract Heading 1 Tag

This IMPORTXML Formula extract the Heading 1 Tag from the URL that is on cell "A1"

4. Extract Canonical Tag

This IMPORTXML Formula extract the Canonical Link Element Tag from the URL that is on cell "A1"

5. Extract Schema Item Type

This IMPORTXML Formula extracts the Schema types used from the URL that is on cell "A1"

6. Use Case

These formulas are good for doing some basic web scraping on sheets while working on meta tags or on-page analysis

You can make a copy of this sheet to start using these formulas right away 👉 docs.google.com/spreadsheets/d…

Cheers & happy new year from team @botpresso 🎉