Simple Performance Tracking
Aug 2025Track performance metrics with Google Sheets, Page Speed Insights API, and a tiny bit of JavaScript
Skills & Software
Project Link
Check it out on Github.
Features
- Simple UI using Google Sheets
- Easy to set up
- Long-term Logging
Tech Stack
- Logging Backend: Javascript, Google Apps Script, Page Speed Insights API
Description
Having worked with many front-end frameworks, I have always seen how the bundle size can shoot up when adding packages and without proper tracking, it would be a hassle to prevent as you would be blind to it happening. We already had enterprise tools for navigation time, page load time and core web vitals, but nothing was giving us the production bundle size that the user actually felt.
So I decided to use my passion for using Google Sheets in everyday life and create a simple script that utilises the Page Speed Insights API to get the "Total Byte Weight" as a metric for the website's bundle size. This was effective as it gave us the ability to focus on reducing the total byte weight and measure the impact of all our changes in the front-end on the final download size of the user.
Feel free to contribute here on the Github and I'd love to hear how you used it to your professional benefit.