Research content keywords with SE Ranking and export to Google Sheets
UnknownWhat this workflow does
This workflow has 8 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets and Seranking (community).
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Get longtail keywords (Se Ranking): get longtail (keyword research)
- Get question keywords (Se Ranking): get questions (keyword research)
- Get similar keywords (Se Ranking): get similar (keyword research)
- Get related keywords (Se Ranking): get related (keyword research)
- Merge: merges the data from its input branches
- Analyze & Score Keywords for Content (Code): runs custom JavaScript code
- Export to Google Sheets (Google Sheets): append or update
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that @seranking/n8n-nodes-seranking is verified or supports 3.0 (used in Get longtail keywords, Get question keywords, Get similar keywords).
Nodes used (5)
- Manual Trigger
n8n-nodes-base.manualTrigger - Se Ranking
@seranking/n8n-nodes-seranking.seRanking - Merge
n8n-nodes-base.merge - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets
From the author
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,…