Automated Yelp Business Finder: Scraping Local Business Data with AI Validation
detail.loadingPreview
Effortlessly discover local business intelligence. This n8n workflow automates scraping Yelp business data by keyword, category, and location, validates input using an AI agent, and securely saves comprehensive details directly into your Google Sheets.
About This Workflow
Unlock precise local business insights with this robust n8n workflow. Trigger the scraping process via a simple web form by defining your target country, business category, and location. Before initiating the scrape, an integrated AI agent intelligently validates your input, ensuring data quality and accuracy. The workflow then leverages Bright Data's powerful scraping capabilities to extract detailed information from Yelp, including business names, URLs, addresses, websites, categories, phone numbers, review counts, and overall ratings. After patiently awaiting the scraping results, all collected data is automatically organized and appended to your designated Google Sheet, creating a dynamic and searchable database for your marketing or sales efforts.
Key Features
- Form-Triggered Data Collection: Easily initiate scraping by submitting a simple web form with desired country, category, and location parameters.
- AI-Powered Input Validation: Ensures data quality and accuracy before scraping by validating user-provided inputs.
- Robust Web Scraping with Bright Data: Leverages Bright Data for reliable and scalable extraction of business details from Yelp.
- Automated Google Sheets Integration: Organizes and saves scraped business names, addresses, websites, phone numbers, ratings, and more directly into your Google Sheet.
- Comprehensive Business Data Capture: Collects essential information like URL, name, address, website, categories, phone number, reviews count, and overall rating.
How To Use
- Configure 'On Form Submission': Set up your form title and ensure the
country,category, andlocationfields are correctly defined as input parameters. - Set Up Bright Data Credentials: Provide your Bright Data API token in the 'Check Delivery Status of Snapshot ID' and 'Fetch Snapshot Results' nodes'
Authorizationheader. - Connect Google Sheets: Authenticate the 'Google Sheets - Save Business Data' node with your Google Sheets OAuth2 credentials. Specify your target
Document IDandSheet Namewhere the scraped data will be saved. Ensure the sheet has the corresponding header columns (url, name, address, website, etc.). - Review AI Agent (Optional, but recommended for validation): If the 'AI Agent - Validate Input' node is fully configured, ensure its prompt and model settings align with your desired input validation rules.
- Activate Workflow: Once all credentials and configurations are in place, activate the workflow to start scraping data automatically upon form submission.
Apps Used
Workflow JSON
{
"id": "55d7976f-be99-40e3-a332-8de0b5fdd493",
"name": "Automated Yelp Business Finder: Scraping Local Business Data with AI Validation",
"nodes": 21,
"category": "Marketing",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 55d7976f-be99...
About the Author
SaaS_Connector
Integration Guru
Connecting CRM, Notion, and Slack to automate your life.
Statistics
Related Workflows
Discover more workflows you might like
Automate LinkedIn Content Promotion for Your Ghost Blog with AI
Effortlessly promote your latest Ghost blog posts on LinkedIn. This workflow leverages AI to generate engaging, professional LinkedIn messages based on your article content and saves them, along with article metadata, directly to a Google Sheet.
AI-Powered On-Page SEO Audit & Report Automation
Instantly generate comprehensive on-page SEO technical and content audits for any website URL. This AI-powered workflow automates the entire process, from scraping the page to delivering a detailed report directly to your inbox, empowering you to optimize for better search rankings and user engagement.
AI-Powered Instagram Comment Automation
This n8n workflow intelligently automates responses to Instagram comments, leveraging advanced AI to engage with your audience. It filters out irrelevant content and personalizes replies, saving you time while boosting your social media presence.