💜 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 🎉
Share this Scrolly Tale with your friends.
A Scrolly Tale is a new way to read Twitter threads with a more visually immersive experience.
Discover more beautiful Scrolly Tales like this.