Templates / Track Google Play keyword rankings weekly with Apify and Google Sheets

Track Google Play keyword rankings weekly with Apify and Google Sheets

Unknown

by JohnVC ✓ · 3 views · created 2026-08-07 · Market Research

Unknown. 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 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).

  1. Set the keywords to track (Edit Fields (Set)): sets 5 fields: keywords, yourPackageName, appsPerKeyword…
  2. One search per keyword (Split Out): splits a list into separate items
  3. Search the Play Store (Apify): run actor and get dataset (actors)
  4. Keep rows that are real apps (Filter): keeps only the items that match a condition
  5. One row per ranked app (Code): runs custom JavaScript code
  6. Append rankings to sheet (Google Sheets): append

Services it uses

Google SheetsApify (community)

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)

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…

Excerpt from JohnVC's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.