Download
Turn a list of seed keywords into an actionable SEO opportunity database — in minutes
If your team is still doing keyword research manually — copying and pasting ideas from different tools — you’re wasting time and missing opportunities.
This n8n workflow fully automates keyword research: it takes pending seed keywords from Airtable, queries DataForSEO Labs to retrieve hundreds of keyword variations (suggestions, related keywords, and ideas), normalizes all metrics, and stores everything in Airtable, ready to be prioritized and executed.
What does this workflow do?
1) Automatically processes pending seed keywords
The workflow reads all keywords marked as “Todo” in Airtable and updates their status to “In progress”, ensuring traceability and avoiding duplicate processing.
2) Fetches keyword data from DataForSEO (3 parallel sources)
For each seed keyword, the workflow queries DataForSEO Labs (Google) using three endpoints:
- Keyword Suggestions
- Related Keywords
- Keyword Ideas
All queries respect the configured language, location, and result limits.
3) Normalizes and enriches each keyword
Each result is standardized and enriched with consistent fields:
- Keyword
- Search volume
- CPC
- Competition & competition level
- Language / location
- Source (“function”: suggestions, related, ideas)
- Processing date
- Reference to the original seed keyword
This makes comparison, filtering, and prioritization extremely easy.
4) Saves results to Airtable using upsert logic
All keywords are stored in the “Keywords Research” table using an upsert strategy with a unique key based on:
keyword + seed keyword + source
This prevents duplicates and allows the workflow to be safely re-run at any time.
5) Marks the process as completed
Once all data is processed, the original seed keyword is updated to “Done”, keeping the pipeline clean and ready for the next batch.
Business benefits (ROI)
✅ Massive time savings
What usually takes hours of manual work is reduced to minutes, with no copy-paste and no human error.
✅ Better SEO opportunity coverage
By combining suggestions, related keywords, and ideas, you get a much richer keyword universe, ideal for:
- Topic clusters
- Long-tail keywords
- BOFU (transactional) content
- TOFU (informational) content
✅ Easy prioritization using real metrics
With volume, CPC, and competition centralized, you can build clear prioritization models such as:
- Quick wins (low competition + decent volume)
- Pillar content (high volume)
- Service and landing pages (high CPC)
✅ Repeatable and scalable process
Your team can run this workflow daily or weekly to continuously grow a structured keyword database with full visibility and control.
✅ Perfect for agencies and in-house teams
Ideal if you manage multiple websites, services, or content categories. Just add new seed keywords — the system does the rest.
Who is this workflow for?
- SEO and Marketing teams that need speed and consistency
- Agencies managing multiple clients
- Companies building a data-driven content engine
- Any business that wants to generate leads with SEO at scale
What do you need to implement it?
- n8n (cloud or self-hosted)
- A DataForSEO account
- An Airtable base with:
- A “Keywords” table (seed keywords + status)
- A “Keywords Research” table (results repository)
We can deliver this workflow fully implemented with:
- Error handling and retries
- Execution logs
- Scheduled runs (cron)
- Airtable dashboards for prioritization
Call to action
Want this workflow running in your business?
If you want to automate keyword research and turn it into a scalable SEO opportunity engine:
