# Build an SEO knowledge graph digital twin with Claude, Postgres, and Slack

> Quick overview This workflow crawls a website from its sitemap, extracts on-page content and links, uses Anthropic Claude to identify keywords and entities, stores everything as an SEO knowledge graph in Postgres, then posts crawl health stats to a Slack channel. How it works 1. Triggers manually or on a weekly schedule to start a crawl using the configured seed URL, sitemap URL, page limit, and Slack channel. 2. Fetches sitemap.xml, parses and deduplicates page URLs (optionally same-domain only), and batches them for processing up to the max page count. 3. For each page URL, downloads the HTML and extracts the title, meta description, H1s, body text, and outbound links. 4. Sends the page content to Anthropic Claude to return structured JSON for primary/secondary keywords, named entities, and topic categories. 5. Writes the page node plus keyword, entity, and link relationships into Postgres tables (seopages, seokeywords, seoentities, seopagekeywords, seopageentities, seopagelinks). 6.

- **Domain**: `n8n-workflow-19873.n8n.io`
- **Provider**: n8n.io (https://n8n.io)
- **Kind**: workflow
- **Live-responds (last probe)**: None
- **Signed card**: False
- **Streaming**: False
- **Quality score**: 40%

## URLs
- Agent card: https://n8n.io/workflows/19873
- Page (HTML): https://agenstry.com/agents/n8n-workflow-19873.n8n.io
- Documentation: https://n8n.io/workflows/19873