Track URL-level keyword rankings in Google Sheets with DataForSEO
UnknownUnknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.
What this workflow does
This workflow has 15 nodes and runs on a schedule (every 2 weeks at 09:00). Along the way it connects Google Sheets and Dataforseo (community).
How it runs
Trigger: On a schedule (every 2 weeks at 09:00).
- Get keywords and URLs (Google Sheets): uses Google Sheets
- Filter: keeps only the items that match a condition
- Loop over items (each keyword) (Loop Over Items (Split in Batches)): loops over the items in batches
- Normalize URL (Code): runs custom JavaScript code
- Create sheet (Google Sheets): create
- Is a new sheet created? (If): checks a condition and branches into true / false
- Prepare column data for GS (Edit Fields (Set)): sets or maps fields
- Merge: merges the data from its input branches
- Append row in sheet (Google Sheets): append
- Get live google organic SERP regular (Data For Seo Serp Api): uses Data For Seo Serp Api
…plus 4 more steps. See the full node list below.
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 n8n-nodes-dataforseo is verified or supports 3.0 (used in Get live google organic SERP regular).
Nodes used (9)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Data For Seo Serp Api
n8n-nodes-dataforseo.dataForSeoSerpApi - Merge
n8n-nodes-base.merge - Code
n8n-nodes-base.code - Edit Fields (Set)
n8n-nodes-base.set - Filter
n8n-nodes-base.filter - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - If
n8n-nodes-base.if
From the author
This workflow automatically monitors how specific URLs rank for their target keywords in Google search results and stores your full ranking history in Google Sheets. On each scheduled run, the workflow reads a list of URLs and related keywords from your input…