{"product_id":"optimize-core-web-vitals-with-pagespeed-api-google-sheets","title":"Optimize Core Web Vitals with PageSpeed API \u0026 Google Sheets","description":"\u003cp\u003eAutomate 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.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cp\u003eThis 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.\u003c\/p\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eSEO agencies:\u003c\/strong\u003e Generate automated performance reports for client websites with Core Web Vitals compliance tracking\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eSaaS operators:\u003c\/strong\u003e Monitor application performance across multiple domains and subdomains on scheduled intervals\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eE-commerce teams:\u003c\/strong\u003e Track product page performance and identify optimization opportunities that impact conversion rates\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eDevelopment teams:\u003c\/strong\u003e Validate performance improvements after deployments using historical trend analysis\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eDigital marketers:\u003c\/strong\u003e Ensure landing page performance meets Google's ranking criteria for paid campaigns\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cp\u003eBuilt 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.\u003c\/p\u003e\n\n\u003cp\u003ePerfect for automation engineers and n8n users seeking reliable, scalable website performance monitoring without manual intervention.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45527093608627,"sku":"N8N-15911","price":29.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Bzxf38ok_UmCNK6Fnlpmz_bc42025b53bb49cf877b4c5a97f96334.jpg?v=1779440513","url":"https:\/\/buyflowscripts.com\/products\/optimize-core-web-vitals-with-pagespeed-api-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}