Track Apple App Store keyword rankings with SerpApi 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 8 nodes and runs on a schedule (every day at 23:00) (plus 1 other trigger). Along the way it connects Google Sheets. It also calls serpapi.com over HTTP.
How it runs
Trigger: On a schedule (every day at 23:00) (plus 1 other trigger).
- Build queue from config (Code): runs custom JavaScript code
- Loop keywords (Loop Over Items (Split in Batches)): loops over the items in batches
- Wait: waits 1 seconds
- SerpApi Apple App Store (HTTP Request): calls serpapi.com
- Parse position row (Code): runs custom JavaScript code
- Append position (Google Sheets): append
Services it uses
HTTP calls to: serpapi.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 (7)
- Manual Trigger
n8n-nodes-base.manualTrigger - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Code
n8n-nodes-base.code - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Wait
n8n-nodes-base.wait - HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets
From the author
Quick overview This workflow runs daily (or manually) to check Apple App Store search rankings for a configured keyword list using SerpApi, then appends each keyword’s rank, result count, group, and date to a Google Sheets tab for ongoing ASO tracking. How it…