Weekly PageSpeed monitoring in Google Sheets, with an alert that ignores one-off dips

Description and use

Automated weekly PageSpeed monitoring with Apify, Google Sheets, and Apps Script, sending alerts only after two consecutive low scores.

Need a schedule, a sheet that only grows, and an alert rule that does not fire on noise.

Weekly audits run automatically, data stored in a growing sheet, alerts only for sustained performance drops, and visual trend charts.

Select representative URLs per template
Configure Apify task with URLs, strategy, categories, includeAuditDetails=false
Schedule Apify run (e.g., cron 0 6 * * 1)
Use curl or cron to fetch dataset items
Append rows to Google Sheet history tab
Create pivot table and line chart with moving‑average trendline
Set up Apps Script with EMAIL, COL, LIMITS
Add time‑driven trigger for weeklyCheck
Script checks last two usable readings per page and sends email if both below threshold

Run on the same weekday and hour with the same input.

Alert when a page's two most recent usable readings are both below its threshold.

Keep includeAuditDetails off so rows stay flat; when an alert fires, re-run a flagged page once with it on to see its top opportunities.