Track Google local pack rankings in Google Sheets with Apify
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 8 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 your keywords and location (Edit Fields (Set)): sets 5 fields: keywords, location, yourBusinessName…
- One search per keyword (Split Out): splits a list into separate items
- Search the Google local pack (Apify): run actor and get dataset (actors)
- Keep searches that returned a pack (Filter): keeps only the items that match a condition
- One row per listing (Split Out): splits a list into separate items
- Pick fields for the sheet (Edit Fields (Set)): sets 9 fields: Date, Keyword, Position…
- 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 Google local pack).
Nodes used (6)
- 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 - Google Sheets
n8n-nodes-base.googleSheets
From the author
Quick overview No rank tracker subscription and no SERP API key. This template checks where your business ranks in Google's local results for the keywords you choose, every week, and appends one row per listing to Google Sheets: position, business, category,…