Quick overview
This workflow runs manually or daily and reads a list of page URLs from Google Sheets, sends them to an Apify Actor that calls Google PageSpeed Insights, then writes Lighthouse scores, Core Web Vitals, and top fix recommendations back to a Results tab.
How it works
- Runs when you click Test workflow or on a daily schedule at 8:00.
- Reads page URLs from the Google Sheets tab named URLs.
- Cleans and deduplicates the URLs, caps the run to 50 entries, and packages them into a single list.
- Runs the Apify Actor hillcountrybots/bulk-pagespeed-checker to perform mobile PageSpeed Insights audits across performance, accessibility, best practices, and SEO.
- Flattens each audit result into a single row containing Lighthouse scores, lab metrics, field Core Web Vitals p75 values, and the top opportunity.
- Appends or updates rows in the Google Sheets Results tab using an auditKey of url plus strategy to avoid duplicates.
Setup
- Install the Apify community node @apify/n8n-nodes-apify and create an Apify API token credential in n8n.
- Create or copy a Google Sheets file with two tabs named URLs and Results, and ensure the URLs tab includes a url column (or URL/urls/link/page).
- Add a Google Sheets OAuth2 credential and replace the spreadsheet ID in both Google Sheets nodes (read and write).