Back to Templates

Research content keywords with SE Ranking and export to Google Sheets

Created by

Created by: Eugene Melnychenko || eugene-m
Eugene Melnychenko

Last update

Last update 4 days ago

Categories

Share

image.png

Who is this for

  • Content creators looking for topic ideas
  • SEO specialists doing keyword research
  • Marketing teams planning content calendars

What this workflow does

Discover keyword opportunities from 4 different sources (longtail, questions, similar, related) and export analyzed results to Google Sheets.

What you'll get

  • Longtail, question, similar, and related keyword variations
  • Opportunity scores based on volume, difficulty, and CPC
  • Search intent classification (informational, commercial, transactional, navigational)
  • Content type suggestions (how-to guide, listicle, comparison, etc.)
  • Trend analysis with historical search volume data
  • Estimated monthly traffic potential
  • Priority ranking (HIGH/MEDIUM/LOW)
  • SERP features analysis
  • All results automatically exported to Google Sheets

How it works

  1. Fetches 4 types of keywords from SE Ranking (longtail, questions, similar, related)
  2. Merges and deduplicates all results
  3. Analyzes each keyword with custom scoring algorithm
  4. Calculates opportunity scores (volume 40%, difficulty 40%, CPC 20%)
  5. Detects search intent and suggests content types
  6. Exports enriched data to Google Sheets with 17 columns

Requirements

Setup steps

  1. Install the SE Ranking community node
  2. Add your SE Ranking API credentials
  3. Connect your Google Sheets account
  4. Update the seed keyword in all 4 SE Ranking nodes (default: "digital marketing")
  5. Select or create a Google Sheet for export

Customization

  • Adjust volumeFrom and difficultyTo filters in SE Ranking nodes for different opportunity ranges
  • Change limit parameter to fetch more/fewer keywords per source (max 1000)
  • Modify opportunity score formula in the Code node (currently: volume 40%, difficulty 40%, CPC 20%)
  • Update content type detection patterns to match your industry
  • Change source parameter for different countries (us, uk, de, fr, etc.)