Track Google Play keyword rankings weekly with Apify and Google Sheets
UnknownWhat this workflow does
This workflow has 7 nodes and runs on a schedule (every week at 08:00). Along the way it connects Google Sheets and Apify (community).
How it runs
Trigger: On a schedule (every week at 08:00).
- Set the keywords to track (Edit Fields (Set)): sets 5 fields: keywords, yourPackageName, appsPerKeyword…
- One search per keyword (Split Out): splits a list into separate items
- Search the Play Store (Apify): run actor and get dataset (actors)
- Keep rows that are real apps (Filter): keeps only the items that match a condition
- One row per ranked app (Code): runs custom JavaScript code
- Append rankings to sheet (Google Sheets): append
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 @apify/n8n-nodes-apify is verified or supports 3.0 (used in Search the Play Store).
Nodes used (7)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Split Out
n8n-nodes-base.splitOut - Apify
@apify/n8n-nodes-apify.apify - Filter
n8n-nodes-base.filter - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets
From the author
Quick overview No ASO tool subscription and no per-seat licence. Every week this searches the Play Store for your keywords and appends one row per ranked app to Google Sheets: position, app, developer, category, rating and download band, with your own app…