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

Описание и применение

Автоматизированный еженедельный мониторинг PageSpeed с использованием Apify, Google Sheets и Apps Script, который отправляет уведомления только при двух последовательных низких оценках.

Задача

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.

Источник