Optimize Core Web Vitals with PageSpeed API & Google Sheets

Automate comprehensive website performance auditing with this powerful n8n workflow that leverages Google's PageSpeed Insights API to analyze Core Web Vitals and Lighthouse metrics across multiple URLs, automatically generating detailed reports in Google Sheets with email notifications.

What this workflow does

This automation streamlines website performance monitoring by processing URL lists from CSV uploads or XML sitemaps. The workflow creates a new Google Sheets spreadsheet for each audit run, then systematically calls the Google PageSpeed Insights API to collect Lighthouse and Core Web Vitals (CrUX) data for each URL. It intelligently batches requests with throttling to respect API limits, captures both mobile and desktop performance metrics, and evaluates results against configurable thresholds. Failed requests are logged with detailed error messages, while successful audits populate comprehensive performance data including pass/fail status for Core Web Vitals. Upon completion, the workflow sends a Gmail summary with audit statistics and a direct link to the generated report.

Use cases

• SEO agencies: Generate automated performance reports for client websites with Core Web Vitals compliance tracking
• SaaS operators: Monitor application performance across multiple domains and subdomains on scheduled intervals
• E-commerce teams: Track product page performance and identify optimization opportunities that impact conversion rates
• Development teams: Validate performance improvements after deployments using historical trend analysis
• Digital marketers: Ensure landing page performance meets Google's ranking criteria for paid campaigns

Technical details

Built using essential n8n nodes including conditional logic (if), data transformation (set), XML parsing (xml), request throttling (wait), and communication integrations (gmail, split out). The workflow requires Google PageSpeed Insights API credentials, Google Sheets OAuth connection for spreadsheet creation, and Gmail OAuth for automated reporting. Supports both manual execution and scheduled runs, with configurable XML sitemap URLs and CSV upload capabilities through n8n forms.

Perfect for automation engineers and n8n users seeking reliable, scalable website performance monitoring without manual intervention.