Detect cannibalized keywords and competing pages with Google Search Console

Find Cannibalized Pages (Google Search Console)

This n8n template helps you detect page cannibalization in Google Search Console (GSC): situations where multiple pages on your site rank for the same query and more than one page gets clicks. Use it to spot competing URLs, consolidate content, improve internal linking, and protect your CTR/rankings.

---

Good to know - Data source: Google Search Console Search Analytics (Dimensions: query, page). - Scope: Defaults to last 12 months and up to 10,000 rows per run (adjustable). - Logic: Keeps only queries with >1 page and where the second page has clicks > 0 → higher confidence of true cannibalization. - Privacy: Template ships with a placeholder property (sc-domain:example.com) and a neutral credential name; replace both after import. - Cost: n8n nodes used here are free. GSC usage is also free (subject to Google limits).

---

How it works 1. Manual Start — run the workflow on demand. 2. Google Search Console — fetch last 12 months of query–page rows. 3. Summarize — group by query, building two arrays: - appendedpage[] → all pages seen for that query - appendedclicks[] → clicks for each page-query row (aligned with appendedpage) 4. Filter — pass only queries where: - countquery > 1 (more than one page involved), and - appendedclicks[1] > 0 (the second page also received clicks) 5. Output — list of cannibalized queries with the competing pages and their click counts.

Example output json { "query": "best running shoes", "appendedpage": [ "https://example.com/blog/best-running-shoes", "https://example.com/guide/running-shoes-2025" ], "appendedclicks": [124, 37], "countquery": 3 }

How to use 1. Import the JSON into n8n. 2. Open the Google Search Console node and: - Connect your Google Search Console OAuth2 credential. - Replace siteUrl with your property (sc-domain:your-domain.com). 3. Press Execute Workflow on Manual Start. 4. Review the output — focus on queries where the second page has meaningful clicks.