123ArticleOnline Logo
Welcome to 123ArticleOnline.com!
ALL >> Computers >> View Article

Automate Pagespeed Insights For Multiple Urls Using Google Sheets!

Profile Picture
By Author: Manal
Total Articles: 4
Comment this article
Facebook ShareTwitter ShareGoogle+ ShareTwitter Share

Calculating individual page-speed performance metrics can help you understand how efficiently your site works as a whole. Since Google uses the speed of a site as one of the signals for page ranking, it is important that this insight view be at the page level.

However, one of the pain points in website performance optimization is the lack of the ability to easily perform page-speed performance assessments. There are many great tools like PageSpeed Insights or the Lighthouse Chrome plug-in that can help you learn more about the performance of a single page, but these tools are not easily configured to help you gather information for multiple URLs and publish hundreds of reports.

When we found a way to gather the performance criteria sideways, we got a solution that worked. While this method solves first problem, the installation process is quite complicated and requires you to have access to a server.

Two months after publishing this method, Google released version 5 of the PageSpeed Insights API. The V5 now uses Lighthouse as the analysis engine and also includes field data provided by the Chrome User Experience Report. In short, this version of the API now easily provides all of the data provided in Chrome Lighthouse controls.

Introduction to Automated PageSpeed Insights Report:

With this tool, we can quickly identify key performance metrics for multiple URLs in just a few clicks. All you need is a copy of this Google Sheet, a free Google API key, and a list of URLs from which you want to retrieve data - but let's take a quick tour first.

How to use this tool?

The Google Sheet consists of the three following tabs:
• Settings
• Results
• Log


On this tab, you'll be asked to provide a unique Google API key for the page to work.

Getting a Google API Key:

Visit the Google API Credentials page. Select API key from the Create credentials ’drop-down list’.

Now you should see a prompt giving you a unique API key:

Then, copy and paste this API key into the section on the “Settings” tab of the Automatic Page Speed Insights spreadsheet. Now that you have an API key, you are ready to use the tool.

Set the report schedule:

On the Settings tab, you can schedule the day and time for reports to run every week. This will be set to the local time set by your Google account. As you can see, this setting also reports that it will run for the next three hours. This is a workaround for the limitations set by both Google Apps Scripts and the Google PageSpeed API.

Total Views: 62Word Count: 419See All articles From Author

Add Comment

Computers Articles

1. Forensic Guide To Whatsapp Data Acquisition
Author: Olga Koksharova

2. How To Extract Telegram Secret Chats From The Iphone
Author: Vladimir Katalov

3. Best External Hard Drives For 2020
Author: Lenoxtons20

4. A Photo Manager And Digital Asset Manager For Creative Photography
Author: Jamie Atkins

5. Why Is Dark The Most Iconic Piece Of Art In Sci-fi Genre?
Author: Abigail Smith

6. Tips And Tricks To Grow Your Instagram Using Pinterest
Author: Abigail Smith

7. Things You Can Follow To Be More Secure Online
Author: Abigail Smith

8. Acronis Universal Restore Ensures Bare-metal Restore Of Dissimilar Hardware
Author: Maria Kurganova

9. Seamless V2p Backup And Restore
Author: Maria Kurganova

10. Top 10 Must-watch Netflix Originals
Author: John Smith

11. Top 3 Itil Emerging Trends To Watch Out For In 2020
Author: Novel Vista

12. #experttalk - Siam? Target Model, Who Comes First - Service Integrator?, Service Provider? Or In Par
Author: Novel Vista

13. Best Mini Laptops For 2020
Author: Lenoxtons20

14. Best Background Erasing Apps For Android & Ios
Author: John Smith

15. Improve Your Drafting With A Multi-purpose Cad Platform
Author: Nick Giles

Login To Account
Login Email:
Forgot Password?
New User?
Sign Up Newsletter
Email Address: