{"product_id":"seo-knowledge-graph-crawler-n8n-claude-postgres-slack","title":"SEO Knowledge Graph Crawler: n8n, Claude, Postgres \u0026 Slack","description":"\u003ch3\u003eBuild an SEO Knowledge Graph Automatically—From Sitemap to Postgres to Slack\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow crawls your website from \u003cstrong\u003esitemap.xml\u003c\/strong\u003e, extracts on-page content and links, uses \u003cstrong\u003eAnthropic Claude\u003c\/strong\u003e to identify keywords and entities, stores everything as an \u003cstrong\u003eSEO knowledge graph\u003c\/strong\u003e in \u003cstrong\u003ePostgres\u003c\/strong\u003e, and sends crawl health stats to \u003cstrong\u003eSlack\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStarts a crawl\u003c\/strong\u003e manually or on a weekly schedule using your configured \u003cem\u003eseed URL\u003c\/em\u003e, \u003cem\u003esitemap URL\u003c\/em\u003e, \u003cem\u003epage limit\u003c\/em\u003e, and \u003cem\u003eSlack channel\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches and processes sitemap.xml\u003c\/strong\u003e, parsing and deduplicating page URLs (optionally limiting to same-domain URLs), then batching requests up to the maximum page count.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCrawls each page\u003c\/strong\u003e and extracts: title, meta description, H1s, body text, and outbound links.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAnalyzes content with Anthropic Claude\u003c\/strong\u003e to return structured JSON containing primary\/secondary keywords, named entities, and topic categories.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePersists the SEO graph in Postgres\u003c\/strong\u003e by writing page nodes plus relationships into tables such as: \u003cem\u003eseo_pages\u003c\/em\u003e, \u003cem\u003eseo_keywords\u003c\/em\u003e, \u003cem\u003eseo_entities\u003c\/em\u003e, \u003cem\u003eseo_page_keywords\u003c\/em\u003e, \u003cem\u003eseo_page_entities\u003c\/em\u003e, and \u003cem\u003eseo_page_links\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSummarizes crawl “digital-twin” stats\u003c\/strong\u003e (pages, unique keywords, entities, internal links, orphan pages) and \u003cstrong\u003eposts the results to Slack\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS SEO operators tracking how pages, keywords, entities, and internal linking evolve over time.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building an SEO knowledge graph for dashboards and content strategy.\u003c\/li\u003e\n  \u003cli\u003eTeams monitoring crawl health by reviewing Slack updates after scheduled sitemap crawls.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\/Nodes:\u003c\/strong\u003e set, code, html, merge, slack, postgres.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI extraction:\u003c\/strong\u003e Anthropic Claude returns structured JSON for keywords, entities, and topic categories.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDatabase:\u003c\/strong\u003e requires creating Postgres tables and constraints for the SEO graph, including ON CONFLICT behavior used by the workflow queries.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003ePerfect if you’re looking for a practical \u003cstrong\u003eSEO knowledge graph crawler\u003c\/strong\u003e that turns sitemap data into a queryable structure in \u003cstrong\u003ePostgres\u003c\/strong\u003e and keeps stakeholders informed via \u003cstrong\u003eSlack\u003c\/strong\u003e.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46081419804851,"sku":"N8N-19873","price":35.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/U0-mbzEAifLf21Xk34yAY_qbBSMnMy.png?v=1790241030","url":"https:\/\/buyflowscripts.com\/products\/seo-knowledge-graph-crawler-n8n-claude-postgres-slack","provider":"N8N Commerce","version":"1.0","type":"link"}