Automate real-time SEO keyword research with DataForSEO and Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 27 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets. It also calls api.dataforseo.com over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Set Sheet ID (Edit Fields (Set)): sets 1 field: id_sheet
- Get Main Keywords (Google Sheets): uses Google Sheets
- Get Related KWs (HTTP Request): calls api.dataforseo.com (POST)
- Get KW Suggestions (HTTP Request): calls api.dataforseo.com (POST)
- Get Autocomplete Suggestions (HTTP Request): calls api.dataforseo.com (POST)
- Get Content Ideas (HTTP Request): calls api.dataforseo.com (POST)
- Get SERPs (HTTP Request): calls an HTTP API (POST)
- Split Out: splits a list into separate items
- Split Out: splits a list into separate items
- Split Out: splits a list into separate items
…plus 16 more steps. See the full node list below.
Services it uses
HTTP calls to: api.dataforseo.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (6)
- Manual Trigger
n8n-nodes-base.manualTrigger - Google Sheets
n8n-nodes-base.googleSheets - Split Out
n8n-nodes-base.splitOut - HTTP Request
n8n-nodes-base.httpRequest - Filter
n8n-nodes-base.filter - Edit Fields (Set)
n8n-nodes-base.set
From the author
This n8n template automates real-time SEO keyword research, delivering comprehensive keyword insights, autocomplete suggestions, subtopics, SERP analysis, and more, straight into your Google Sheet. Use cases are many: This workflow is perfect for bloggers,…