Using a Google Sheet as an Update Server!

Here’s a quick video to show you something I thought was really neat. I used a Google Sheet as kind of a DIY update server for an application I built, so that users wouldn’t overload my own server by checking for updates to software I made.… Continue reading...


Video: The SEO’s Guide to Kicking Ass with API

This is the recording of a webinar I did with SEMrush showing how to import APIs and web data into Google Sheets and manipulate that data to build tools and do pretty cool shit. Free SEMrush API Key: SEMrush gave me a free SEMrush API trial to give away for the webinar. … Continue reading...


How to Make a Simple Website Ripper with Google Sheets

Ripping a website’s source code is the starting point for many, many SEO tasks. Whether you’re verifying updates, checking for open graph, checking for schema markup, or trying to figure out which pages are missing that oh-so-important CSS file, if you’re in the SEO field – at some point, you’re going to be digging through source code.… Continue reading...