Trustpilot Review Scraper using Bright Data and Google Sheets Sync - n8n Workflow

Marketing Analysts needing competitive sentiment data.
SEO Professionals monitoring brand reputation.
Data teams requiring structured web data without manual intervention.
Users looking for advanced, reliable long-running n8n templates.

This comprehensive n8n workflow is designed to handle the complexities of asynchronous web scraping tasks. Manually extracting thousands of reviews is time-consuming and unreliable, especially from dynamic websites. This n8n template solves this by integrating with Bright Data, a robust data collection platform. The core value lies in the long-running automation: the workflow initiates the scrape, manages the delay using a sophisticated polling loop involving the Wait n8n node, and only proceeds once the data is finalized. This ensures that every run of the n8n workflow reliably extracts and synchronizes detailed review attributes (rating, content, reviewer name, etc.) directly into a clean Google Sheet, providing continuous monitoring capabilities. This implementation showcases an effective use of the HTTP Request n8n node for API interaction and flow control using the IF n8n node.

The execution of this robust n8n workflow begins with the Form Trigger n8n node, which acts as the initial n8n trigger, capturing the Trustpilot URL provided by the user. Step one involves the first HTTP Request n8n node (POST to Bright Data), which sends the URL and custom output field requirements to Bright Data's API, initiating the scraping job and returning a unique snapshotid. The subsequent GET - snapshot status HTTP Request n8n node checks the progress using this ID. The IF snapshotid not ready than wait n8n node checks if the scrape status is 'ready'. If not, the n8n workflow utilizes the Wait1mins n8n node to pause for 60 seconds before looping back to re-check the status—a vital technique for managing long-running processes within an n8n workflow. Once 'ready', a second If n8n node ensures records were returned. Finally, the GET - snapshot download n8n node fetches the complete JSON payload of reviews. The powerful Google Sheets (Append) n8n node then seamlessly takes this large dataset and appends all the structured review data into the target Google Sheet, completing the full automation cycle of this advanced n8n template.

1. Import the n8n Workflow: Copy the provided JSON and import it directly into your n8n instance.


2. Bright Data Setup: You must have a Bright Data account and an active Trustpilot dataset configured. Obtain your Bright Data API key.


3. Credentials Setup:

1. Sheet Configuration: Ensure the sheet ID and name (Trustpilot) in the Google Sheets n8n node match your desired destination spreadsheet and tab before activating this n8n workflow.

This n8n workflow uses several critical n8n node types to achieve reliable web scraping:

Form Trigger: This n8n trigger starts the workflow execution, providing a simple interface to input the required Trustpilot Website URL.
POST to Bright Data (HTTP Request n8n node): Initiates the scraping job. Key configuration includes using a POST method, sending the input URL in the JSON body, and setting the datasetid query parameter, ensuring the n8n node receives the initial job ID.
GET - snapshot status (HTTP Request n8n node): Essential for the long-running process. This n8n node dynamically constructs its URL using the snapshotid received from the previous step to poll the job status.
IF snapshotid not ready than wait (If n8n node): Controls the polling loop. It checks if $json.status equals 'ready'. If false, it branches to the Wait n8n node, looping the n8n workflow back for a retry.
Wait1mins (Wait n8n node): Pauses the n8n workflow execution for 1 minute (as configured) to prevent overloading the API while waiting for data collection to finish.
If (n8n node): Acts as a safeguard, ensuring the GET - snapshot download step only runs if $json.records is not equal to zero, meaning data was successfully scraped.
GET - snapshot download (HTTP Request n8n node): Downloads the final scraped data. The URL is configured to retrieve the JSON snapshot based on the successful snapshotid.
Google Sheets (Append) (Google Sheets n8n node): The final action. This n8n node is set to the 'Append' operation and automatically maps the extensive list of extracted review fields (like reviewtitle, reviewrating, company_name) to columns in the target Google Sheet.