Find SEO keyword opportunities with SE Ranking, AI search, and Google Sheets

Description

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
Fetches your domain's worldwide performance metrics
Discovers top 5 organic competitors automatically
Analyzes keyword gaps for each competitor
Identifies keywords you recently lost rankings for
Expands top opportunities into topic clusters
Tracks AI search visibility (ChatGPT, Perplexity, Gemini, AI Overview)
Scores and prioritizes all opportunities
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
Install the SE Ranking community node v1.3.5+
Add your SE Ranking API credentials
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)
Connect Google Sheets credentials (optional)
Select or create a spreadsheet for export (optional)

Customization
Adjust min_volume and max_difficulty for more/fewer opportunities
Change source for different countries (us, uk, de, fr, etc.)
Modify competitor_count to analyze more or fewer competitors
Add known_competitors for AI Leaderboard comparison
Filter ai_engines list to track specific AI platforms only