Scrape Yelp Business Data with Gemini AI, Bright Data & Google Sheets

🔍 Yelp Business Finder: Scraping Local Businesses by Keyword, Category & Location Using Bright Data and Google Sheets

Description: Automate local business data collection from Yelp using AI-powered input validation, Bright Data scraping, and automatic Google Sheets integration. Perfect for market research, lead generation, and competitive analysis.

🛠️ How It Works

Form Submission: Users submit a simple form with country, location, and business category parameters.

AI Validation: Google Gemini AI validates and cleans input data, ensuring proper formatting and Yelp category alignment.

Data Scraping: Bright Data's Yelp dataset API scrapes business information based on the cleaned parameters.

Status Monitoring: The workflow monitors scraping progress and waits for data completion.

Data Export: Final business data is automatically appended to your Google Sheets for easy analysis.

📋 Setup Steps

⏱️ Estimated Setup Time: 10-15 minutes

Prerequisites

✅ Active n8n instance (cloud or self-hosted) ✅ Google account with Sheets access ✅ Bright Data account with Yelp scraping dataset ✅ Google Gemini API access

Configuration Steps

Import Workflow: Copy the provided JSON workflow In n8n: Go to Workflows → + Add workflow → Import from JSON Paste the JSON and click Import

Configure Google Sheets: Create a new Google Sheet or use an existing one Set up OAuth2 credentials in n8n Update the Google Sheets node with your document ID Configure column mappings for business data

Setup Bright Data: Add your Bright Data API credentials to n8n Replace BRIGHT_DATA_API_KEY with your actual API key Verify your Yelp dataset ID in the HTTP request nodes Test the connection

Configure Google Gemini: Add your Google Gemini API credentials Test the AI Agent connection Verify the model configuration

Test & Activate: Activate the workflow using the toggle switch Test with sample data: country="US", location="New York", category="restaurants" Verify data appears correctly in your Google Sheet

📊 Data Output

📍 Business Name
Official business name from Yelp

⭐ Overall Rating
Average customer rating (1-5 stars)

📝 Reviews Count
Total number of customer reviews

🏷️ Categories
Business categories and tags

🌐 Website URL
Official business website

📞 Phone Number
Contact phone number

📍 Address
Full business address

🔗 Yelp URL
Direct link to Yelp listing

🎯 Use Cases

🔍 Market Research
Analyze local business landscapes and competition

📈 Lead Generation
Build prospect lists for B2B outreach

🏪 Location Analysis
Research business density by area and category

📊 Competitive Intelligence
Monitor competitor ratings and customer feedback

⚠️ Important Notes: Ensure you comply with Yelp's terms of service and rate limits Bright Data usage may incur costs based on your plan AI validation helps improve data quality and reduce errors Monitor your Google Sheets for data accuracy

🔧 Troubleshooting

Common Issues: API Rate Limits:** Implement delays between requests if needed Invalid Categories:** AI agent helps standardize category names Empty Results:** Verify location spelling and category alignment Authentication Errors:** Check all API credentials and permissions

🚀 Ready to start scraping Yelp business data efficiently!