Streamline SEO Audits: Export PageSpeed Data to CSV Easily

Transform your SEO performance analysis with this comprehensive n8n workflow that automatically processes up to 10 URLs through Google PageSpeed Insights API and generates detailed CSV reports for professional audits. Perfect for SEO professionals and agencies who need efficient, scalable page speed analysis.

What this workflow does

This intelligent automation streamlines the entire PageSpeed audit process through sophisticated URL processing and API integration. The workflow begins by parsing and normalizing your URL inputs, applying regex filtering to validate URLs, automatically appending HTTPS protocols, removing duplicates, and capping results at 10 URLs for optimal performance.

Before executing costly API calls, the system performs reachability checks using HTTP HEAD requests, isolating any URLs returning non-200 status codes and notifying you via chat of failed URLs. For reachable URLs, the workflow iterates through each one, sending HTTP GET requests to Google PageSpeed Insights API v5 using mobile strategy, with built-in 10-second delays to respect rate limits.

The extracted data includes comprehensive Core Web Vitals metrics: Largest Contentful Paint, First Contentful Paint, Cumulative Layout Shift, Speed Index, plus detailed resource analysis covering total page size, HTML/CSS/JavaScript file sizes, and optimization savings opportunities. Finally, the structured data compiles into CSV format and uploads to Uguu.se for temporary hosting with shareable download links.

Use cases

• SEO agencies conducting bulk client website audits
• Web developers analyzing multiple page performance metrics
• Digital marketing teams creating comprehensive site speed reports
• E-commerce managers monitoring product page performance
• Technical consultants delivering data-driven optimization recommendations

Technical details

Built using essential n8n nodes including IF conditions for flow control, Code nodes for data processing, Wait nodes for rate limiting, Aggregate nodes for data compilation, and Item Lists for URL management. The workflow integrates directly with Google PageSpeed Insights API v5 and utilizes Uguu.se for temporary file hosting, ensuring reliable data export and sharing capabilities.