A screenshot of the google spreadsheet with a list of keywords.

Create Your Own Google Pagespeed & Mobile Usability Tracking Google Sheet in 5 Steps

After #mobilegeddon it’s been harsh for us SEO guys to check each landing page’s mobile friendliness. So I’ve made a Google Sheet for getting Pagespeed and Mobile Usability Data. It includes a custom function that gets the URL on a cell and writes the scores from the Google Pagespeed API.