SEO Keyword Opportunity Finder

SEO Keyword Opportunity Finder

Turn raw Search Console data into a prioritised content backlog automatically. This template pulls your site's search queries, identifies keywords sitting in positions 5–20 with strong impression volume (the classic "low-hanging fruit" zone), scores each for content opportunity with an LLM, and stores the best targets in a DataTable for editorial review.

What this workflow does

1. WeeklyAudit fires every Monday morning
2. FetchSearchQueries calls the Google Search Console Search Analytics API for the past 28 days, sorted by impressions
3. IterateQueries loops over each keyword row
4. ScoreOpportunity sends the query, position, and impressions to an LLM which returns a content opportunity score (1–10) and a suggested article angle
5. FilterOpportunities keeps only keywords scoring 7 or higher
6. MapKeywordRow reshapes the data into a clean record with search term, position, impressions, score, and suggested angle
7. SaveToBacklog inserts the row into a Heym DataTable for your content team
8. AuditSummary confirms the run is complete after all keywords are processed

Use cases

• Weekly SEO keyword triage without manual spreadsheet work
• Surface quick-win content topics based on real impression data
• Feed a content calendar or Kanban board automatically from live search data

Setup

1. Replace YOUR_SITE_URL in FetchSearchQueries with your verified GSC property URL (e.g. sc-domain:example.com).
2. Add a Google OAuth2 credential with the Search Console read scope to the FetchSearchQueries HTTP node.
3. Create a DataTable in Heym for keyword opportunities and paste its ID into SaveToBacklog.
4. Adjust the score threshold in FilterOpportunities (default: 7) to widen or narrow the backlog.