Lead scraping from Google Maps & Yellow Pages with AI…

This automation workflow collects potential leads from Google Maps and Yellow Pages, cleans and validates their contact data, applies AI-based qualification using OpenAI, and routes qualified leads to HubSpot and Google Sheets. Slack notifications keep sales teams informed. Designed for agencies and businesses aiming to scale lead generation without manual effort.

## Who it´s for
- Marketing agencies generating leads for clients
- B2B companies searching for regional partners
- Sales professionals automating cold outreach
- Business owners scaling lead acquisition without manual labor
- SaaS startups needing fast contact database creation

## What the automation does
- Manually triggered with a search query (e.g., "auto repair in Berlin")
- Scrapes company data from Google Maps and Yellow Pages via HTTP API
- Cleans and normalizes contact information
- Validates email addresses for deliverability
- Uses OpenAI to assess lead relevance and qualification
- Sends qualified leads to HubSpot as new contacts or deals
- Logs all scraped leads in Google Sheets
- Exports analytics (total, valid, qualified) to a dedicated sheet
- Notifies sales team in Slack upon new qualified leads

## What´s included
- Ready-to-use n8n workflow
- Trigger and data processing logic
- Integrations with Google Maps, Yellow Pages, Slack, HubSpot, and Google Sheets
- Basic text guide for setup and adaptation

## Requirements for setup
- n8n instance with workflow editing access
- API keys or account access: Google Maps, HubSpot, Slack, Google Sheets
- OpenAI API key for AI qualification
- Basic familiarity with n8n and REST APIs

## Benefits and outcomes
- Fully automated lead collection and filtering
- Reduces cold prospecting time to minutes
- Improves lead quality through AI scoring
- Centralized data storage in CRM and Google Sheets
- Real-time Slack alerts for immediate follow-up
- Reusable across niches and regions
- Enables scalable lead generation without hiring

## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via Telegram: @gleb923.