{"product_id":"daily-pagespeed-tracking-api-sheets-gmail-n8n-workflow","title":"Daily PageSpeed Tracking: API + Sheets + Gmail n8n Workflow","description":"\u003ch3\u003eDaily PageSpeed Monitoring Made Simple (API + Google Sheets + Gmail in n8n)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow checks your website’s \u003cstrong\u003eGoogle PageSpeed Insights\u003c\/strong\u003e performance every day, logs key metrics to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and automatically sends a \u003cstrong\u003eGmail\u003c\/strong\u003e report or an alert when scores fall below your thresholds.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily at 9:00 AM\u003c\/strong\u003e on a schedule.\u003c\/li\u003e\n  \u003cli\u003eCalls the \u003cstrong\u003eGoogle PageSpeed Insights API\u003c\/strong\u003e to fetch \u003cstrong\u003emobile\u003c\/strong\u003e performance results.\u003c\/li\u003e\n  \u003cli\u003eCalls the same API again to fetch \u003cstrong\u003edesktop\u003c\/strong\u003e performance results.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts and combines\u003c\/strong\u003e scores plus key metrics—\u003cstrong\u003eLCP\u003c\/strong\u003e and \u003cstrong\u003eCLS\u003c\/strong\u003e—into a single report payload.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends or updates\u003c\/strong\u003e the day’s metrics in a \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e spreadsheet to maintain a historical log.\u003c\/li\u003e\n  \u003cli\u003eEvaluates thresholds and sends email:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cstrong\u003eSuccess email\u003c\/strong\u003e if \u003cem\u003emobile score \u0026gt; 70\u003c\/em\u003e and \u003cem\u003edesktop score \u0026gt; 90\u003c\/em\u003e\n\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eLow performance alert\u003c\/strong\u003e via \u003cstrong\u003eGmail\u003c\/strong\u003e if scores do not meet those limits\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eTrack Core Web Vitals trends (\u003cstrong\u003eLCP\u003c\/strong\u003e, \u003cstrong\u003eCLS\u003c\/strong\u003e) for a SaaS marketing site or product pages.\u003c\/li\u003e\n  \u003cli\u003eProactively alert engineering\/ops teams when PageSpeed drops after deployments or content changes.\u003c\/li\u003e\n  \u003cli\u003eMaintain an auditable, day-by-day performance history in Google Sheets for reporting and regression review.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle PageSpeed Insights API\u003c\/strong\u003e: mobile + desktop fetch\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: OAuth2-based append\/update for historical tracking\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e: OAuth2-based email reports\/alerts\u003c\/li\u003e\n  \u003cli\u003en8n nodes used: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003ehtml\u003c\/strong\u003e, \u003cstrong\u003eno op\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup requirements\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eGoogle PageSpeed Insights API Key\u003c\/li\u003e\n  \u003cli\u003eGoogle Sheets OAuth2 credentials (set spreadsheet\/document ID and sheet tab as needed)\u003c\/li\u003e\n  \u003cli\u003eGmail OAuth2 credentials (ensure email sending to the configured recipient)\u003c\/li\u003e\n  \u003cli\u003eAdjust schedule time and thresholds if you don’t use the defaults (mobile \u0026gt; 70, desktop \u0026gt; 90)\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45741405077683,"sku":"N8N-17619","price":56.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/fAI73K51X2nUje1hRfIAp_mX1DC0vi.png?v=1785315738","url":"https:\/\/buyflowscripts.com\/products\/daily-pagespeed-tracking-api-sheets-gmail-n8n-workflow","provider":"N8N Commerce","version":"1.0","type":"link"}