Automated Yelp Data Collection with Bright Data and Google Sheets

This n8n workflow automates the process of scraping detailed business information from Yelp using Bright Data’s API, triggered by user-submitted URLs via a form. The workflow begins with a form where users enter a Yelp business URL, which then triggers a Bright Data scraping request for the specified page. The process involves monitoring the status of the scrape, waiting for the data to be ready, and then fetching the structured results. Finally, the extracted business data—such as name, website, phone number, rating, and address—is automatically stored in a dedicated Google Sheet for centralized analysis and record-keeping.

The key steps include:

– Receiving a user-submitted Yelp URL through a form trigger.

– Initiating a scrape request on Bright Data, passing the URL.

– Periodically checking the status of the scrape until it is completed.

– Once ready, retrieving the scraped data.

– Storing the data into a Google Sheets document.

This workflow is particularly useful for businesses or researchers who need to continually collect and monitor Yelp business data without manual effort, enabling scalable data extraction for market analysis or reputation management.