An Apps Script that polls Webpagetest weekly and puts the result into a Google Sheet. If metrics exceed your thresholds, you'll get an email. A great way to make sure your site doesn't slow down!
This is meant to be used in the Google Sheet at https://goo.gl/SgMfGc.
Here's how it works:
- You create a tab in the Google Sheet for each URL whose speed you want to track.
- Once a week, the tool runs Webpagetest on each of those URLs.
- The tool retrieves key performance metrics from those tests, placing those in a new row in each tab.
- If any metric exceeds thresholds you’ve set, it sends alerts to email addresses also stored in the trix.
That’s it!
-
Make your own copy of the Sheet.
-
Get an API key and configure this tool to use it.
- Get an API key from Webpagetest by filling out the simple form here.
- Go to the
Configtab. - Replace the API key in cell B1 with your own.
- Specify your URLs.
- In the “URL 1” tab, replace the URL in column B1 with the URL you want tested.
- If you want to test more URLs, copy the
URL 1tab. You can test as many as 10 URLs. Just make sure that the name of each tab starts with “URL”.
-
In the
Alertingtab, enter email addresses for people who should get alerts. -
Set up weekly tests:
- Under the “Tools” menu, select “Script Editor”. A new browser tab will open.
- In that new tab, go to the “Edit” menu and choose “Current project’s triggers”.
- In the popup window, click on “Add a new trigger”, and set it up as shown (weekly tests are recommended, but you can decide)
That’s it! Enjoy!
An Apps Script can now go through a verification process whereby Google ensures it's safe. Since you'll own this script, it won't be verified in this way. So, when you first run it, you'll probably see a scary warning that begins, "This app isn't verified."
You'll simply have to click on the "Advanced" link in that dialog box and tell Google you trust the script.