Monitor website performance with PageSpeed Insights and send alerts

Monitor website performance with PageSpeed Insights and save to Google Sheets with alerts This n8n template automatically monitors website performance using Google's PageSpeed Insights API, compiles detailed reports, and tracks performance trends over time in Google Sheets. Use cases: Agency client monitoring, competitor analysis, performance regression detection, SEO reporting, site migration monitoring, A/B testing performance impact, and maintaining performance SLAs. Who's it for - Digital agencies monitoring client websites - SEO professionals tracking site performance - DevOps teams maintaining performance SLAs - Business owners wanting automated site monitoring How it works - Automated Testing: Scheduled audits of multiple websites using PageSpeed Insights API - Core Web Vitals: Tracks LCP, FID, CLS, and overall performance scores - Historical Tracking: Maintains performance history for trend analysis - Alert System: Sends notifications when performance drops below thresholds - Detailed Reporting: Captures specific recommendations and optimization opportunities Two Workflow Paths 1. Scheduled Audit: Automatically tests all URLs from Google Sheet on schedule 2. On-Demand Testing: Webhook endpoint for immediate single-URL testing How to set up 1. Get a free PageSpeed Insights API key from Google Cloud Console 2. Create Google Sheet with columns: URL, Site Name, Category, Alert Threshold, LastProcessedDate and Device. 3. Set up Google Sheets API credentials 4. Configure notification preferences (Slack, email, etc.) 5. Set audit schedule (daily, weekly, or custom) 6. Define performance thresholds for alerts Requirements - Google PageSpeed Insights API key (free) - Google Sheets API access - n8n instance (cloud or self-hosted) - Optional: Slack/email for notifications Google Sheet Structure Input Sheet ("sites"): - URL, SiteName, Category, AlertThreshold, LastProcessedDate and Device. Results Sheet ("auditresults"): - Date, URL, SiteName, Device, PerformanceScore, LCP, FID, CLS, Recommendations, FullReportURL API Usage (On-Demand) POST to webhook: How to customize - Add custom performance thresholds per site - Include additional metrics (accessibility, SEO, best practices) - Connect to other dashboards (Data Studio, Grafana) - Add competitor benchmarking - Integrate with project management tools for issue tracking - Set up different notification channels based on severity - Sample Google Sheet Included