Find and triage keyword cannibalization with Search Console, OpenAI, and Gmail
Ready for 3.0What this workflow does
This AI workflow has 28 nodes and runs on a schedule (every week at 08:00) (plus 1 other trigger). Along the way it connects OpenAI Chat Model and Gmail.
How it runs
Trigger: On a schedule (every week at 08:00) (plus 1 other trigger).
- Settings (Edit Fields (Set)): sets 6 fields: property, days, min_impressions…
- Ask Search Console (HTTP Request): calls an HTTP API (POST)
- Ask The Window Before (HTTP Request): calls an HTTP API (POST)
- Both Windows (Merge): merges the data from its input branches
- Group Every Query By Its Pages (Code): runs custom JavaScript code
- Drop The Operator Queries (Filter): keeps only the items that match a condition
- Drop The AI Mode Prompts (Filter): keeps only the items that match a condition
- Anything Left To Check? (If): checks a condition and branches into true / false
- List Every URL Once (Code): runs custom JavaScript code
- Facts And Candidates (Merge): merges the data from its input branches
…plus 14 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (14)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Merge
n8n-nodes-base.merge - Code
n8n-nodes-base.code - Filter
n8n-nodes-base.filter - If
n8n-nodes-base.if - Data table
n8n-nodes-base.dataTable - Switch
n8n-nodes-base.switch - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Gmail
n8n-nodes-base.gmail - No Operation, do nothing
n8n-nodes-base.noOp
From the author
Quick overview This workflow checks Google Search Console for queries where multiple site URLs appear, verifies whether the overlaps are real by fetching each URL’s redirect/canonical/hreflang signals, uses an OpenAI chat model to recommend which page should…