Scrape Local Business Directories with Bright Data & OpenAI for Lead Generation

This workflow contains community nodes that are only compatible with the self-hosted version of n8n.

This workflow automatically scrapes local business directories (Yelp, Yellow Pages, Google Maps, etc.) to build a structured database of prospects. Stop copying listings by hand—get fresh leads delivered straight to Google Sheets.

Overview

Using Bright Data, the automation fetches business names, contact details, ratings, and categories for a given city or ZIP code. OpenAI cleans and normalizes the data, while duplicate detection ensures each business appears only once. The result is emailed as a CSV and stored in Sheets for easy filtering.

Tools Used

n8n** – Workflow orchestration Bright Data** – Handles large-scale directory scraping OpenAI** – Performs entity cleanup and deduplication Google Sheets** – Houses the resulting lead list Gmail** – Sends the CSV file to your inbox

How to Install

Import the Workflow: Load the .json into n8n. Configure Bright Data: Add your credentials. Set Up OpenAI: Enter your API key. Connect Google Sheets & Gmail: Authorize both integrations. Customize Locations & Categories: Adjust parameters in the Start node.

Use Cases

Local Lead Generation**: Build outreach lists for agencies or SaaS. Market Research**: Analyze density of businesses in a region. Franchise Expansion**: Identify potential partners within a territory. Startup Sales**: Discover SMBs that match your ICP.

Connect with Me

Website**: https://www.nofluff.online YouTube**: https://www.youtube.com/@YaronBeen/videos LinkedIn**: https://www.linkedin.com/in/yaronbeen/ Get Bright Data**: https://get.brightdata.com/1tndi4600b25 (Using this link supports my free workflows with a small commission)

#n8n #automation #webscraping #localbusiness #brightdata #leadgeneration #n8nworkflow #nocode #businessdirectories #openai