n8n Workflow: Find Weak Google Business Profiles & Review Issues

Find Google Business Profile weaknesses and review issues—automatically

This n8n workflow runs weekly to discover local businesses on Google Maps, score their Google Business Profile gaps against nearby peers, analyze low-rated reviews with OpenAI (GPT-5.6) to extract complaint themes, then logs prospects to Google Sheets and posts a ranked digest to Slack.

What this workflow does

• Runs on a schedule: Executes weekly and reads a city, categories, thresholds, and destination settings from the workflow configuration.
• Discovers businesses via Bright Data: Triggers Google Maps discovery searches (one per category) and polls snapshot progress until results are ready.
• Scores measurable profile gaps: Downloads discovered profiles and benchmarks each one against the “people also search” peer set to identify weaknesses.
• Avoids re-contacting prospects: Pulls previously logged businesses from Google Sheets and filters out any contacted within the last 90 days.
• Extracts review complaint themes: Uses OpenAI (GPT-5.6) to extract recurring complaint themes from reviews rated three stars and below.
• Ranks and reports results: Appends one prospect per row to the Prospects sheet and posts a formatted, ranked digest to a Slack channel.

Use cases

• SEO/SaaS operators identifying local competitors’ Google Business Profile gaps to prioritize outreach.
• Agencies building targeted lead lists by combining profile benchmarking with low-review complaint insights.
• Automation engineers maintaining a recurring local marketing pipeline from Google Maps discovery to actionable reporting in Slack.

Technical details

• Bright Data (HTTP Header Auth): Add your API key as Authorization: Bearer <key> for dataset requests.
• OpenAI: Ensure the GPT-5.6 model is available and configured in the workflow.
• Google Sheets: Create a spreadsheet with a sheet named “Prospects” and paste the URL into the workflow.
• Slack: Connect credentials to receive the ranked digest.
• n8n nodes/logic: if, set, code, no op, wait, slack (as used by the workflow logic).