Track Google Local Pack Rankings in Google Sheets (n8n + Apify)

Track Google Local Pack rankings automatically in Google Sheets (n8n + Apify)

This n8n workflow checks your Google Local Pack positions every Monday morning and logs each local listing—complete with rank (position), rating, and address—directly into your Google Sheets tab.

What this workflow does

• Runs on a schedule: a scheduled trigger executes every Monday morning.
• Loads configuration: it uses a configured list of keywords, a target location, your business name, and optional Google country/domain settings.
• Queries Google Local Pack via Apify: for each keyword, it runs the Apify actor johnvc~google-local-api to fetch Google local pack results for your query and location.
• Skips empty results: if a keyword returns no local pack listings, that search is skipped.
• Expands listings into rows: each local pack business becomes a separate item.
• Formats spreadsheet columns: outputs include date, keyword, position, business name, category, rating, reviews, address and flags rows that match your business name.
• Appends to Google Sheets: it writes the formatted results into the selected spreadsheet document ID and sheet tab.

Use cases

• Local SEO teams monitoring weekly movement for multiple target keywords.
• SaaS operators wanting a simple Google Local Pack tracking dashboard in Sheets.
• Agencies comparing competitors by logging rank, rating, and address over time.

Technical details

• n8n workflow category: n8n automation workflow
• Nodes/blocks used: set, filter, split out, sticky note, Google Sheets, and Apify (apifyn8n-nodes-apify).
• Apify integration: uses your Apify API token as an n8n credential.
• Output: appended rows per listing (keyword × local pack businesses) in Google Sheets.

Setup reminder: update your keyword list, location, business name, and (optionally) googleDomain/country before activating the workflow.