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

说明与用途

使用 Apify、Google Sheets 和 Apps Script 的自动化每周 PageSpeed 监控，仅在连续两次低分后发送警报。

问题

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.

来源