{"product_id":"seo-zombie-page-checker-ga4-gsc-postgres-slack","title":"SEO Zombie Page Checker: GA4 + GSC + Postgres + Slack","description":"\u003ch3\u003eFind SEO “zombie pages” across your site—automatically\u003c\/h3\u003e\n\u003cp\u003eThe \u003cstrong\u003eSEO Zombie Page Checker: GA4 + GSC + Postgres + Slack\u003c\/strong\u003e workflow crawls your website from its sitemap, enriches each URL with \u003cstrong\u003eGA4\u003c\/strong\u003e, \u003cstrong\u003eGoogle Search Console\u003c\/strong\u003e, and backlink signals, then scores pages as \u003cstrong\u003ehealthy\u003c\/strong\u003e, \u003cstrong\u003eat_risk\u003c\/strong\u003e, or \u003cstrong\u003ezombie\u003c\/strong\u003e. Results are stored in \u003cstrong\u003ePostgres\u003c\/strong\u003e and a summary report is sent to \u003cstrong\u003eSlack\u003c\/strong\u003e—with optional \u003cstrong\u003eAnthropic Claude\u003c\/strong\u003e rationales for at-risk pages.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns manually or on a weekly schedule\u003c\/strong\u003e, using your configured identifiers, thresholds, and reporting settings.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads and parses your sitemap\u003c\/strong\u003e, extracts and deduplicates URLs, optionally restricts crawling to the same domain, and respects a maximum page limit.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCrawls each URL\u003c\/strong\u003e to extract page elements and links, computes technical\/content flags (e.g., \u003cem\u003ethin content\u003c\/em\u003e, \u003cem\u003enoindex\u003c\/em\u003e, \u003cem\u003ecanonical mismatch\u003c\/em\u003e, word count), and stores crawl results plus internal link edges in \u003cstrong\u003ePostgres\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds an internal link graph\u003c\/strong\u003e in Postgres to calculate inbound internal link counts for every crawled page.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEnriches pages with performance and index signals\u003c\/strong\u003e by pulling:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cstrong\u003eGA4\u003c\/strong\u003e signals via the Analytics Data API\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eGSC\u003c\/strong\u003e signals via Search Analytics and URL Inspection\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eReferring-domain metrics\u003c\/strong\u003e from your backlink provider API\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eComputes a weighted 0–100 zombie score\u003c\/strong\u003e and assigns a status; optionally calls \u003cstrong\u003eAnthropic Claude\u003c\/strong\u003e for brief rationales on non-healthy pages, then upserts final records into Postgres.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends a roll-up summary to Slack\u003c\/strong\u003e (totals and top offenders).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eWeekly audits to identify pages losing organic visibility or underperforming despite being indexed.\u003c\/li\u003e\n  \u003cli\u003eDetecting thin\/noindex\/canonical issues that correlate with low engagement in GA4 and low performance in GSC.\u003c\/li\u003e\n  \u003cli\u003ePrioritizing SEO fixes by combining crawl diagnostics, internal links, GA4\/GSC data, and backlink context.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCore stack\/nodes:\u003c\/strong\u003e if, set, code, html, merge, Slack\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData storage:\u003c\/strong\u003e Postgres (crawl results, internal link edges, and final scoring records)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e GA4 (Analytics Data API), Google Search Console (Search Analytics + URL Inspection), backlink provider API, Slack\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOptional AI:\u003c\/strong\u003e Anthropic Claude rationales for \u003cem\u003eat_risk\u003c\/em\u003e\/\u003cem\u003ezombie\u003c\/em\u003e pages\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46146306670771,"sku":"N8N-20253","price":23.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/DM5nQGGeLmAVk10CJvoho_Ej7NsWE8.png?v=1790845882","url":"https:\/\/buyflowscripts.com\/products\/seo-zombie-page-checker-ga4-gsc-postgres-slack","provider":"N8N Commerce","version":"1.0","type":"link"}