Find low-competition keyword opportunities with DataForSEO

Description

🔍 Low competition keyword finder

What it does:
Discovers all keywords a domain ranks for and analyzes their difficulty, trends, and intent. Identifies opportunities based on actual ranking data rather than suggestions.

How it works:
Reads domain seeds from Google Sheets (with location/language settings)
Fetches all keywords the domain ranks for (Keywords For Site API)
Gets keyword difficulty scores for each keyword (Bulk Keyword Difficulty API)
Combines data with search trends, intent classification, and backlink metrics
Writes comprehensive results to keywords_opportunities sheet

Setup Requirements:
DataForSEO API credentials (Basic Auth)
Google Sheets with input columns: seed, location_name, language_name, limit
Output sheet: keywords_opportunities

Data Captured:
Keyword & Search Volume
Monthly/Quarterly/Yearly Trends
Keyword Difficulty (0-100)
Search Intent (main + foreign)
Average Backlinks
Last Updated Time
SE Type & Location/Language codes

Best For:
Competitor keyword analysis
Content gap identification
Monitoring domain keyword portfolio
Finding keywords you already rank for