How to Automate PageSpeed Insights for Multiple URLs using Google Sheets

One of the pain points in website performance optimization is inability to easily run page speed performance evaluations en masse. Tools like PageSpeed Insights or the Lighthouse Chrome plugin are not readily configured to gather insights for multiple URLs — and running individual reports for hundreds or thousands of pages isn’t exactly feasible or efficient.

So I made it feasible.