Daily PageSpeed Tracking: API + Sheets + Gmail n8n Workflow

Daily PageSpeed Monitoring Made Simple (API + Google Sheets + Gmail in n8n)

This n8n workflow checks your website’s Google PageSpeed Insights performance every day, logs key metrics to Google Sheets, and automatically sends a Gmail report or an alert when scores fall below your thresholds.

What this workflow does

• Runs daily at 9:00 AM on a schedule.
• Calls the Google PageSpeed Insights API to fetch mobile performance results.
• Calls the same API again to fetch desktop performance results.
• Extracts and combines scores plus key metrics—LCP and CLS—into a single report payload.
• Appends or updates the day’s metrics in a Google Sheets spreadsheet to maintain a historical log.
• Evaluates thresholds and sends email:
  • Success email if mobile score > 70 and desktop score > 90
  • Low performance alert via Gmail if scores do not meet those limits

Use cases

• Track Core Web Vitals trends (LCP, CLS) for a SaaS marketing site or product pages.
• Proactively alert engineering/ops teams when PageSpeed drops after deployments or content changes.
• Maintain an auditable, day-by-day performance history in Google Sheets for reporting and regression review.

Technical details

• Google PageSpeed Insights API: mobile + desktop fetch
• Google Sheets: OAuth2-based append/update for historical tracking
• Gmail: OAuth2-based email reports/alerts
• n8n nodes used: if, set, code, html, no op, gmail

Setup requirements

• Google PageSpeed Insights API Key
• Google Sheets OAuth2 credentials (set spreadsheet/document ID and sheet tab as needed)
• Gmail OAuth2 credentials (ensure email sending to the configured recipient)
• Adjust schedule time and thresholds if you don’t use the defaults (mobile > 70, desktop > 90)