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

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