Python SEO + Google Sheets 🤣

Alright try not to laugh too hard lolololol but this is the first thing I've built from scratch for myself after learning how to get started with Python from David!

Here's a breakdown of the spreadsheet image:

Column A - Insert the URLs you want to scrape

Column B - Measures page load speed, then adds a color scale

Column C - Meta description scraped from the site

Column E - Total page word count

Of course I'm always looking at my competitors rankings as an SEO, but I've found this is a great way to audit your own content aswell.

On the bottom:

I used an extension to take the values of the cells above, then tried writing some prompts to a "jumping off point" for some content ideas - still not in love with using different models inside Google Sheets though - what should I use instead?

Let me know if this is interesting to you and I'd be happy to make a simple guide!

5 comments