Research content keywords with SE Ranking and export to Google Sheets
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, comme
At a glance
Research content keywords with SE Ranking and export to Google Sheets is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Google Sheets. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- Google Sheets
- Modules
- 8
- Price
- Free
- Version
- v1.0

About this workflow
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 - SE Ranking account with API access (Get one here) - SE Ranking community node installed (Install from npm) - Google Sheets account 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.)
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
Bulk generate images from Google Sheets with Leonardo.AI and store in Google Drive
Get RSS feed updates in a single email summarizing all posts that contain a specific keyword
Create UseINBOX contacts from new Google Sheets spreadsheet rows
Create Google Sheets for new Memberful orders completed
Track Amazon competitor with BrowserAct
Create LionDesk contacts from Google Sheets rows
Create AI shorts with HeyGen, Creatomate, Replicate, Gemini and OpenAI
Ai agent integration with eBay Buy Marketing API
Reviews
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
- JSON blueprint — instant download
- Setup guide PDF included
- 5 downloads · valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you