A Google Spreadsheet Add-on, which reads urls from your spreadsheet, and automatically enriches them with lighthouse statistics.
Click here to see any open issues. Also, please help 2WA to support & develop this plugin further.
Schedulers and emailnotifications will allow this addon to run in the background:
The v1 (current) version also has a limit of 5 urls, this will be removed in the future.