Scrape Yelp to Google Sheets via AI & Bright Data

# Scrape Yelp data by category and location to Google Sheets with AI-validated inputs

This workflow automates the collection of structured business data from Yelp using specified location and category parameters. It´s ideal for market research, lead generation, and competitive analysis — eliminating manual search and copy-paste workflows.

## Who it´s for
- Marketers gathering competitor data in specific regions
- Market researchers analyzing local business trends
- Freelancers offering lead sourcing services
- Startups building databases for cold outreach

## What the automation does
- Triggered by a form submission with country, location, and business category
- Uses a Google Gemini-powered AI agent to validate and clean input data
- Sends structured query to Bright Data’s Yelp dataset scraper
- Polls for job completion status
- Extracts business details (name, rating, website, phone, etc.) and appends them to Google Sheets

## What´s included
- Ready-to-use n8n workflow with LangChain and Google Gemini integration
- Logic for handling form submissions via HTTP webhook
- Integrations with Yelp (via Bright Data), Google Sheets, and Google Gemini API
- Basic text guide for setup and adaptation

## Requirements for setup
- n8n account with external API access
- Google Gemini API key
- Bright Data account and API key
- Google account with Google Sheets access

## Benefits and outcomes
- Saves time on manual data collection
- Delivers accurate, structured business profiles
- Enables regular monitoring of new businesses in target areas
- Simplifies lead list creation for outreach campaigns
- Improves data quality through AI-powered input validation

## 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 chat