This is a tool to automate performance tracking via Page Speed Insights (PSI) and visualize it with Data Studio. Find an example of the final result here.
- PSI API Key. If you need one, you can get one here.
- Google account (e.g. @gmail.com) to fork the Google Sheets tracker and the Data Studio dashboard.
Use your Google account to make a copy of this Google Sheets template and follow the instructions in the 'How to Use' tab: fill the URL information, give permissions by running an initial manual test and add a time trigger (the video below shows how to set a trigger to run a function on a daily basis).
Give it a few days and the 'Results' tab will automatically be populated with the results for each test.
Please, keep in mind that this file will be the main datasource for the dashboard, so I would recommend you to be the only owner and editor of this file. You can later share the dashboard with the rest of the team.
Once the data has populated the 'Results' tab for a few days, you can make a copy of this Data Studio template and link it to the Google Sheets tracker that you created. To do so, click on 'Create a new data source', select the Google Sheets connector, find your tracker and connect the 'Results' tab. See the video below (with similar steps).
Share the dashboard with the rest of the team and enjoy!
Thanks @pianomister for the help!
Thanks @charisTheo for the videos!