Track weekly keyword rankings with Google SERP, Serper API, 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 10 nodes and runs on a schedule (cron 0 0 * * MON) (plus 1 other trigger). Along the way it connects Google Sheets.
How it runs
Trigger: On a schedule (cron 0 0 * * MON) (plus 1 other trigger).
- Get Targeted Keywords (Google Sheets): uses Google Sheets
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Delay Between Keyword Queries (Wait): waits 10 seconds
- Keyword Searching on Google (HTTP Request): calls an HTTP API (POST)
- Merging Result (Merge): merges the data from its input branches
- Extracting Ranking & URL (Code): runs custom JavaScript code
- Formating output (Code): runs custom JavaScript code
- Update Rank and URLs (Google Sheet) (Google Sheets): update
Services it uses
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 (8)
- Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Google Sheets
n8n-nodes-base.googleSheets - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Merge
n8n-nodes-base.merge - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Manual Trigger
n8n-nodes-base.manualTrigger - Wait
n8n-nodes-base.wait
From the author
This template is designed for SEO specialists, content marketers, and digital growth teams who want to automate the process of tracking keyword rankings. Manually checking SERPs every week is time-consuming and prone to error. This workflow solves that by…