{"product_id":"fix-keyword-cannibalization-search-console-openai-gmail","title":"Fix Keyword Cannibalization: Search Console + OpenAI + Gmail","description":"\u003ch3\u003eFix keyword cannibalization with an automated Google Search Console audit—then get a weekly action email\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow detects when multiple URLs compete for the same Google query (keyword cannibalization), confirms whether the overlap is real using redirect\/canonical\/hreflang signals, asks OpenAI to recommend the best page to own the query, and emails you a weekly Gmail digest of what to fix.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eRuns weekly (Mondays) or on-demand\u003c\/b\u003e — ideal after a site migration.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003ePulls Search Console data\u003c\/b\u003e — queries the Google Search Console Search Analytics API for two 28-day windows, grouped by query and page.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eFinds candidate overlaps\u003c\/b\u003e — looks for queries where multiple site URLs appear, and filters out irrelevant operator queries (e.g., \u003ci\u003esite:\u003c\/i\u003e) and long zero-click AI Mode prompts.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eVerifies overlap reality per URL\u003c\/b\u003e — fetches each distinct URL once (without following redirects) to extract HTTP status, Location header, canonical URL, and hreflang alternates.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eClassifies the reason\u003c\/b\u003e — identifies redirect, canonical duplicate, hreflang\/locale alternate, or a true overlap, and suppresses pairs already reported unless impressions have grown significantly.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eUses OpenAI to recommend actions\u003c\/b\u003e — sends only real, reportable overlaps to an OpenAI-compatible chat model to decide which URL should keep ownership and what to do with the other.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eBuilds history + sends a digest\u003c\/b\u003e — upserts results into an n8n Data Table and emails a ruled-out summary plus an actionable shortlist via Gmail.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAfter migrations: quickly spot new cannibalization patterns caused by URL changes.\u003c\/li\u003e\n  \u003cli\u003eSEO triage: prioritize which duplicate or conflicting pages need canonical\/redirect\/locale cleanup.\u003c\/li\u003e\n  \u003cli\u003eSaaS operator workflows: get weekly, inbox-ready reporting without manual Search Console exporting.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eIntegrations:\u003c\/b\u003e Google Search Console (Search Analytics API), OpenAI-compatible chat model, Gmail\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003en8n nodes\/logic:\u003c\/b\u003e if, set, code, no op, merge (plus scheduling and Data Table upserts)\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cb\u003eKeyword cannibalization\u003c\/b\u003e isn’t just a report—it’s actionable. Automate detection, verification, prioritization, and a weekly email workflow in n8n.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45931127439539,"sku":"N8N-18952","price":57.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/NsL-FH3bm39Mpjy45FaCc_adM51e3w.png?v=1788254327","url":"https:\/\/buyflowscripts.com\/products\/fix-keyword-cannibalization-search-console-openai-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}