SEO Zombie Page Checker: GA4 + GSC + Postgres + Slack

Find SEO “zombie pages” across your site—automatically

The SEO Zombie Page Checker: GA4 + GSC + Postgres + Slack workflow crawls your website from its sitemap, enriches each URL with GA4, Google Search Console, and backlink signals, then scores pages as healthy, at_risk, or zombie. Results are stored in Postgres and a summary report is sent to Slack—with optional Anthropic Claude rationales for at-risk pages.

What this workflow does

• Runs manually or on a weekly schedule, using your configured identifiers, thresholds, and reporting settings.
• Loads and parses your sitemap, extracts and deduplicates URLs, optionally restricts crawling to the same domain, and respects a maximum page limit.
• Crawls each URL to extract page elements and links, computes technical/content flags (e.g., thin content, noindex, canonical mismatch, word count), and stores crawl results plus internal link edges in Postgres.
• Builds an internal link graph in Postgres to calculate inbound internal link counts for every crawled page.
• Enriches pages with performance and index signals by pulling:
  • GA4 signals via the Analytics Data API
  • GSC signals via Search Analytics and URL Inspection
  • Referring-domain metrics from your backlink provider API
• Computes a weighted 0–100 zombie score and assigns a status; optionally calls Anthropic Claude for brief rationales on non-healthy pages, then upserts final records into Postgres.
• Sends a roll-up summary to Slack (totals and top offenders).

Use cases

• Weekly audits to identify pages losing organic visibility or underperforming despite being indexed.
• Detecting thin/noindex/canonical issues that correlate with low engagement in GA4 and low performance in GSC.
• Prioritizing SEO fixes by combining crawl diagnostics, internal links, GA4/GSC data, and backlink context.

Technical details

• Core stack/nodes: if, set, code, html, merge, Slack
• Data storage: Postgres (crawl results, internal link edges, and final scoring records)
• Integrations: GA4 (Analytics Data API), Google Search Console (Search Analytics + URL Inspection), backlink provider API, Slack
• Optional AI: Anthropic Claude rationales for at_risk/zombie pages