Trustpilot insights scraper: Auto reviews via Bright Data + Google Sheets sync

Trustpilot Insights Scraper: Auto Reviews via Bright Data + Google Sheets Sync

Overview A comprehensive n8n automation that scrapes Trustpilot business reviews using Bright Data and automatically stores structured data in Google Sheets.

Workflow Architecture

1. 📝 Form Trigger Node Purpose: Manual input interface for users - Type: n8n-nodes-base.formTrigger - Configuration: - Form Title: "Website URL" - Field: "Trustpilot Website URL" - Function: Accepts Trustpilot URL input from users to initiate the scraping process

2. 🌐 HTTP Request (Trigger Scraping) Purpose: Initiates scraping on Bright Data platform - Type: n8n-nodes-base.httpRequest - Method: POST - Endpoint: https://api.brightdata.com/datasets/v3/trigger - Configuration: - Query Parameters: - datasetid: gdlm5zmhwd2sni130p - includeerrors: true - limitmultipleresults: 2 - Headers: - Authorization: Bearer BRIGHTDATAAPIKEY - Body: JSON with input URL and 35+ custom output fields

Custom Output Fields The workflow extracts the following data points: - Company Information: companyname, companylogo, companyoverallrating, companytotalreviews, companyabout, companyemail, companyphone, companylocation, companycountry, companycategory, companyid, companywebsite - Review Data: reviewid, reviewdate, reviewrating, reviewtitle, reviewcontent, reviewdateofexperience, reviewurl, dateposted - Reviewer Information: reviewername, reviewerlocation, reviewspostedoverall - Review Metadata: isverifiedreview, reviewreplies, reviewusefulcount - Rating Distribution: 5star, 4star, 3star, 2star, 1star - Additional Fields: url, companyratingname, isverifiedcompany, breadcrumbs, companyothercategories

3. ⌛ Snapshot Progress Check Purpose: Monitors scraping job status - Type: n8n-nodes-base.httpRequest - Method: GET - Endpoint: https://api.brightdata.com/datasets/v3/progress/{{ $json.snapshotid }} - Configuration: - Query Parameters: format=json - Headers: Authorization: Bearer BRIGHTDATAAPIKEY - Function: Receives snapshotid from previous step and checks if data is ready

4. ✅ IF Node (Status Check) Purpose: Determines next action based on scraping status - Type: n8n-nodes-base.if - Condition: $json.status === "ready" - Logic: - If True: Proceeds to data download - If False: Triggers wait cycle