n8n Local Pack Ranking Map: Bright Data + GPT, Slack & Gmail

Track your Google Local Pack visibility every week—then send the ranked map to Slack and Gmail

This n8n workflow automatically maps your Google Local Pack presence across a geo grid using Bright Data SERP requests, summarizes coverage with GPT, stores weekly metrics in an n8n Data Table, and sends a report via Slack and Gmail every Monday morning.

What this workflow does

• Scheduled monitoring: Runs every Monday morning on a defined schedule.
• Grid-based SERP checking: Takes your business name, keyword, center coordinates, grid size, and reporting destinations, then generates a square geo grid around the center point.
• Geo-targeted searches: Builds a Google search URL for each coordinate using a uule location parameter.
• Bright Data SERP extraction: Queries Google one point at a time via the Bright Data SERP API, extracting Local Pack entries, whether your business appears, and which competitors rank above you.
• Coverage & rank analytics: Aggregates all grid points into coverage and average-rank metrics, and stops the run if Google does not resolve a location for any point.
• Week-over-week comparison: Looks up the most recent prior results for the same business+keyword from an n8n Data Table.
• Reporting outputs: Stores current week metrics back into the Data Table, tallies competitors that outrank you most often, draws an ASCII grid map, and uses OpenAI (GPT-5.6) to generate a concise two-sentence owner summary.
• Instant delivery: Posts the report to the configured Slack channel and emails the same report via Gmail (Slack + HTML email versions).

Use cases

• Local SEO teams monitoring Local Pack performance by neighborhood, not just a single location.
• Agency operators tracking competitor visibility across a grid and sharing weekly results with clients.
• Operators running recurring brand+keyword checks and maintaining historical trend data.

Technical details

• n8n nodes/tools: set, code, gmail, slack, data table, sticky note.
• Bright Data integration: Uses a Bright Data SERP zone with an HTTP Header Auth credential in n8n.
• AI summarization: Uses OpenAI (GPT-5.6) to write a two-sentence plain-language owner summary.