Yelp Business Data Scraper with Bright Data & Google Sheets
detail.loadingPreview
This n8n workflow automates the scraping of Yelp business information from a provided URL using Bright Data and centralizes the collected data in a Google Sheet. It offers a seamless solution for gathering structured business details for various analytical and operational needs.
About This Workflow
Effortlessly collect detailed business information from Yelp with this robust n8n workflow. Simply provide a Yelp business URL via a convenient form trigger, and the workflow leverages Bright Data's powerful scraping capabilities to extract key details. It intelligently monitors the scraping process, waits for completion, and then fetches the structured data. Finally, all retrieved information is neatly organized and stored in a designated Google Sheet, creating a centralized, accessible database for your business intelligence, lead generation, or market research efforts.
Key Features
- User-Friendly Trigger: Initiate data collection by simply submitting a Yelp URL through a customizable form.
- Automated Web Scraping: Seamlessly integrate with Bright Data to scrape comprehensive business details from Yelp pages.
- Intelligent Status Monitoring: Automatically checks the scraping job's progress with built-in retry logic until data is ready.
- Centralized Data Storage: Automatically push all scraped business data into a Google Sheet for easy access and analysis.
- Structured Data Output: Ensures that collected information like business name, ratings, and more are stored in a clear, organized format.
How To Use
- Form Trigger: No specific configuration needed for the form, just note the input field is labeled "URL".
- Bright Data API Key: Replace
BRIGHT_DATA_API_KEYplaceholders in both the "Trigger Bright Data Scrape" and "Monitor Snapshot Status" nodes with your actual Bright Data API key. - Bright Data Dataset ID: In the "Trigger Bright Data Scrape" node, ensure the
dataset_idquery parameter (e.g.,gd_lgugwl0519h1p14rwk) matches your desired Bright Data dataset ID. - Google Sheets Integration: Authenticate the "Store to Google Sheet" node with your Google account. Specify the exact
Spreadsheet IDandSheet Namewhere you want to store the data. Adjust theColumnssettings to map the data fields (likename,overall_rating) received from Bright Data to your desired Google Sheet columns.
Apps Used
Workflow JSON
{
"id": "6c9e3f41-e963-414d-8f2b-a12b15bac4a2",
"name": "Yelp Business Data Scraper with Bright Data & Google Sheets",
"nodes": 11,
"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: 6c9e3f41-e963...
About the Author
Crypto_Watcher
Web3 Developer
Automated trading bots and blockchain monitoring workflows.
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.
WhatsApp AI Assistant: LLaMA 4 & Google Search for Real-Time Insights
Instantly deploy a smart AI assistant on WhatsApp, powered by Groq's lightning-fast LLaMA 4 model. This workflow enables real-time conversations, remembers context, and provides up-to-date answers by integrating live Google Search results.
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.