In just 5 min ⏱️ put Google Sheets and Appscript to work with the PageSpeed Insights API to gather lighthouse data for multiple urls in bulk for your web site!
Google's Page Experience Update has made site speed a crucial ranking factor, and now with this Google Sheet you can analyze Lighthouse page speed of about 20 URLS with in just a few clicks.
In this video, I'll walk you through the process of setting up your own automated tool, which fetches data directly from Google's PageSpeed API and neatly organizes it in a Google Sheet. 📊
You'll learn how to request an API key, set up your Google Sheet, and implement the Apps Script and extract a list of url's from a web site's robots.txt or sitemap.xml files to pull in your site's speed data effortlessly.
Chapters:
_________________________________________________
0:00 Introduction: PageSpeed Insights in Bulk
0:05 Using Appscript and Google Sheets for PageSpeed Insights
0:19 Why is Page Speed Important?
1:04 Step 1: Get the Google Sheet & Apps Script
2:03 Step 2: Request your Google PageSpeed Insights API Key
2:25 Step 3: Get a list of URLs for Bulk Testing
4:00 Step 4: Run the PageSpeed Insights API Google Sheet Apps Script
4:04 Limitations
4:18 Limitation 1: Speed
4:33 Limitation 2: Number of URLs Tested (Execution Time Limit)
5:20 Workaround for Limitation 2
5:48 Limitation 3: Apps Script Modifications
6:33 Limitation 4: User Experience Data (Can be fixed)
7:00 Limitation 5: Link to Lighthouse Audit Results
7:34 A Better Way to Run PageSpeed Insights in Bulk?
Sources Cited in the Video:
__________________________________________________
Link to My PageSpeed Insights Tutorial Video:
• PageSpeed Insights Tut...
Google’s Roll Out Timeline for User Experience Ranking update:
bit.ly/GoogleUXUpdate
24% More Traffic when Optimizing Core Web Vitals
bit.ly/WebVitalsScience
Link to Request your Google PageSpeed Insights API key:
bit.ly/PageSpeedAPIkey
Lemon Hive's Web Page / Instructions
bit.ly/LemonHiveBulk
Link to My Enhanced Version of the Google Sheet and Apps Script
bit.ly/MyPageSpeedGoogleSheet