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

Automate Pagespeed Insights For Multiple Urls Using Google Sheets!

By Author: Manal
Total Articles: 5
Comment this article

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: 15Word Count: 419See All articles From Author

Add Comment

Computers Articles

1. Laptop Screen Repair Or Replacement In Andheri East
Author: shahidseo

2. How The Document Management System Is Going To Increase Your Business Productivity
Author: Satish Yadav

3. How To Re-add Missing Dock Icons On Macbook?
Author: Aida Martin

4. Safepots:automate Your Backup.
Author: safepots

5. Get Access To The Cash App Phone Number To Remove Technical Woes
Author: logansah

6. How To Record Clips On The Xbox One?
Author: Aida Martin

7. How To Fix Iphone Cannot Verify Identity Issue
Author: marco

8. How To Fix Microphone Not Working Error On Windows 10
Author: marco

9. How To Install Dlc On Steam: The Complete Guide
Author: jaxson harry

10. How To Fix No Device Detected In Corsair Utility Engine
Author: marco

11. How Challenges Can Thwart Devops Implementation And How To Overcome Them
Author: Oliver Moore

12. Top 3 Reasons To Use Multi Tenant Ip Pbx Solution
Author: sandip Patel

13. Voip Softswitch Solution And Its Benefits
Author: sandip Patel

14. How To Choose The Best Class 4 Softswitch Solution?
Author: sandip Patel

15. Buy Computer Rack To Save Floor Space Of Your Office
Author: rack finity

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