Automating Pagespeed Insights Using Google Sheets [Updated Template]

min read



In September, Moz published my guide: “How to Automate Pagespeed Insights For Multiple URLs using Google Sheets”. I got a lot of really excellent questions and feedback on the post, and have continued making tweaks and improvements to the tool, which I thought I’d share here today.

I recommend reading the Moz blog post first to give you a good understanding of what to expect from this tool. Then once you’re done, read on below to hear more about the additions I have made based on the feedback I received.

Performance Score and Mobile Results

A large majority of the community requested some additional functionality that was not part of the original Google Sheet, namely the PageSpeed Insights Performance score generated for each page, and the ability to run the tool for mobile results (the tool pulls insights for desktop URLs by default).

I’m always happy to hear about ways to make the things I build even better, and so I am happy to announce that I have added these great suggestions to an updated version of the template.

Download the Updated Google Sheet

You can grab an updated copy of the Google Sheet that now includes the Performance Score and the ability to run your URLs through PageSpeed Insights for mobile or desktop results.

Desktop and Mobile Insights

On this updated template, the Settings tab now has the option to choose between Desktop or Mobile. You will want to make sure that this is defined before running the tool. At this time you can only choose one strategy type, but if you’d like to have insights for both, simply make two copies.

Keep Us Updated

Let me know what else you’d like to see added to this tool, or if you find yourself digging into the Google App Script, and modifying it yourself.