{"product_id":"weekly-seo-technical-audit-in-n8n-pagespeed-search-console-to-sheets","title":"Weekly SEO Technical Audit in n8n: PageSpeed \u0026 Search Console to Sheets","description":"\u003ch3\u003eWeekly SEO Technical Audit in n8n—PageSpeed \u0026amp; Search Console to Google Sheets\u003c\/h3\u003e\n\u003cp\u003eRun a weekly SEO technical check that pulls your site URLs, verifies HTTP status, measures Google PageSpeed Insights performance, and confirms Google Search Console indexing—then logs everything into a Google Sheets audit sheet automatically.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow can run manually or on a weekly schedule. It performs a technical audit loop for every URL found in your sitemap and appends the results to a Google Sheets technical audit log.\u003c\/p\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCollect URLs from your sitemaps:\u003c\/strong\u003e Fetches \u003ccode\u003epage-sitemap.xml\u003c\/code\u003e and \u003ccode\u003epost-sitemap.xml\u003c\/code\u003e from your configured base site URL (no trailing slash) and parses the XML to extract all page URLs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCheck HTTP status:\u003c\/strong\u003e For each URL, requests the page to capture the HTTP status code.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMeasure performance with PageSpeed Insights:\u003c\/strong\u003e Calls the Google PageSpeed Insights API to retrieve a performance score for each URL.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eVerify indexing with Search Console:\u003c\/strong\u003e Uses the Google Search Console URL Inspection API to retrieve the indexing\/coverage state for each URL.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLog results to Sheets:\u003c\/strong\u003e Combines the HTTP status, PageSpeed score, indexing result, and the check date into a single row per URL and appends it to your selected Google Sheets worksheet.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eTrack technical SEO health over time for a SaaS marketing site or blog.\u003c\/li\u003e\n  \u003cli\u003eIdentify URLs with poor PageSpeed Insights scores or non-indexed states quickly.\u003c\/li\u003e\n  \u003cli\u003eMaintain an audit trail for SEO monitoring and reporting to stakeholders using Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eCatch HTTP errors and indexing issues after site changes or deployments.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduling:\u003c\/strong\u003e Manual trigger or weekly schedule.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes\/logic:\u003c\/strong\u003e \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003exml\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003emerge\u003c\/code\u003e, \u003ccode\u003esticky note\u003c\/code\u003e, \u003ccode\u003ehttp request\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAPIs:\u003c\/strong\u003e Google PageSpeed Insights API and Google Search Console URL Inspection API.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets:\u003c\/strong\u003e Append step to a worksheet with columns \u003ccode\u003eURL\u003c\/code\u003e, \u003ccode\u003eHTTP Status\u003c\/code\u003e, \u003ccode\u003ePageSpeed Score\u003c\/code\u003e, \u003ccode\u003eIndexed\u003c\/code\u003e, and \u003ccode\u003eDate Checked\u003c\/code\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eIdeal for n8n users, automation engineers, and SaaS operators who need a practical SEO technical audit workflow built around PageSpeed and Search Console data.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45756674932915,"sku":"N8N-17752","price":33.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/N87l5EKfZCwHO9f2W-czb_mosC9cTI.png?v=1785747806","url":"https:\/\/buyflowscripts.com\/products\/weekly-seo-technical-audit-in-n8n-pagespeed-search-console-to-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}