Monitor Core Web Vitals at scale with PageSpeed API and Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 23 nodes and runs on a schedule (every week) (plus 2 other triggers). Along the way it connects Google Sheets and Gmail. It also calls googleapis.com over HTTP.
How it runs
Trigger: On a schedule (every week) (plus 2 other triggers).
- Config (Edit Fields (Set)): sets 7 fields: api_key, xml_sitemap_url, lighthouse_category…
- Pick default spreadsheet to save the report (Google Sheets): create
- Add column headers to new sheet (HTTP Request): calls an HTTP API (PUT)
- Create audit metadata (Edit Fields (Set)): sets 1 field: audit_meta
- Process CSV file if uploaded, otherwise fetch the XML sitemap (If): checks a condition and branches into true / false
- Extract data from file (Extract from File): extracts data from a file
- Fetch the XML sitemap (HTTP Request): calls an HTTP API
- Extract URLs from file (Split Out): splits a list into separate items
- Convert to JSON (XML): converts between XML and JSON
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
…plus 10 more steps. See the full node list below.
Services it uses
HTTP calls to: googleapis.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (13)
- HTTP Request
n8n-nodes-base.httpRequest - XML
n8n-nodes-base.xml - Split Out
n8n-nodes-base.splitOut - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - n8n Form Trigger
n8n-nodes-base.formTrigger - Manual Trigger
n8n-nodes-base.manualTrigger - Google Sheets
n8n-nodes-base.googleSheets - Edit Fields (Set)
n8n-nodes-base.set - If
n8n-nodes-base.if - Extract from File
n8n-nodes-base.extractFromFile - Wait
n8n-nodes-base.wait - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Gmail
n8n-nodes-base.gmail
From the author
Quick overview This workflow audits a list of URLs from a CSV upload or an XML sitemap using the Google PageSpeed Insights API, writes Lighthouse and Core Web Vitals metrics into a new Google Sheets report, and emails a completion summary via Gmail. How it…