Calculating individual page speed performance metrics can help you to understand how efficiently your site is running as a whole.
In this post from James McNulty you can learn how to use Google Sheets and Google Apps Script to automatically check your website page speeds. As well as including everything you need to set this up James also shows how the results can be visualized in Data Studio
Source: How to Automate Pagespeed Insights For Multiple URLs using Google Sheets – Moz
Member of Google Developers Experts Program for Google Workspace (Google Apps Script) and interested in supporting Google Workspace Devs.