Find SEO keyword opportunities with SE Ranking, AI search, and Google Sheets
UnknownUnknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.
Community nodes
These come from third-party npm packages. In n8n 3.0 unverified community packages are off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
@seranking/n8n-nodes-seranking(Get your domain overview, Auto-discover top competitors, Get keyword gaps, Get your lost keywords, Get similar keywords, Get related keywords, Get AI search leaderboard)
Nodes used (8)
- Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - Se Ranking
@seranking/n8n-nodes-seranking.seRanking - Code
n8n-nodes-base.code - Wait
n8n-nodes-base.wait - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Merge
n8n-nodes-base.merge - Google Sheets
n8n-nodes-base.googleSheets
What it does
!image.png(fileId:4237) Who is this for - SEO agencies doing competitor analysis for clients - Content teams planning content strategies - Marketing teams tracking competitive performance - SEO professionals measuring AI search visibility What this workflow does Automatically discover competitors, analyze keyword gaps, identify quick wins, and track your visibility across AI search engines (ChatGPT, Perplexity, Gemini, AI Overview). What you'll get - Domain performance baseline (keywords, traffic, traffic value) - Top 5 competitors discovered by keyword overlap - Keyword gap analysis with up to 500 filtered opportunities - Lost keywords you recently ranked for (quick wins) - Topic expansion from related keyword research - AI visibility metrics across 4 search engines - Priority-scored opportunities (HIGH/MEDIUM/LOW) - Actionable recommendations per keyword - Automated export to Google Sheets How it works 1. Fetches your domain's worldwide performance metrics 2. Discovers top 5 organic competitors automatically 3. Analyzes keyword gaps for each competitor 4. Identifies keywords you recently lost rankings for 5. Expands top opportunities into topic clusters 6. Tracks AI search visibility (ChatGPT, Perplexity, Gemini, AI Overview) 7. Scores and prioritizes all opportunities 8. Exports structured data to Google Sheets Requirements - SE Ranking account with API access (Get one here) - SE Ranking node v1.3.5+ installed (Install from npm) - Google Sheets account (optional) Setup 1. Install the SE Ranking community node v1.3.5+ 2. Add your SE Ranking API credentials 3. Update the Configuration node with: - Your domain and brand name - Target country code (us, uk, de, etc.) - Minimum search volume threshold - Maximum keyword difficulty - Known competitors for AI comparison (optional) 4. Connect Google Sheets credentials (optional) 5. Select or create a spreadsheet for export (optional) Customization - Adjust minvolume and maxdifficulty for more/fewer opportunities - Change source for different countries (us, uk, de, fr, etc.) - Modify competitorcount to analyze more or fewer competitors - Add knowncompetitors for AI Leaderboard comparison - Filter aiengines list to track specific AI platforms only