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 initi

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: - 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: $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 5. π Wait Node Purpose: Implements polling delay for incomplete jobs - Type: n8n-nodes-base.wait - Duration: 1 minute - Function: Pauses execution before re-checking snapshot status 6. π Loop Logic Purpose: Continuous monitoring until completion - Flow: Wait β Check Status β Evaluate β (Loop or Proceed) - Prevents: API rate limiting and unnecessary requests 7. π₯ Snapshot Download Purpose: Retrieves completed scraped data - Type: n8n-nodes-base.httpRequest - Method: GET - Endpoint: $json.snapshotid }} - Configuration: - Query Parameters: format=json - Headers: Authorization: Bearer BRIGHTDATAAPIKEY 8. π Google Sheets Integration Purpose: Stores extracted data in spreadsheet - Type: n8n-nodes-base.googleSheets - Operation: Append - Configuration: - Document ID: 1yQ10Q2qSjm-hhafHF2sXu-hohurW5KD8fIv4IXEA3I - Sheet Name: "Trustpilot" - Mapping: Auto-map all 35+ fields - Credentials: Google OAuth2 integration Data Flow Technical Specifications Authentication - Bright Data: Bearer token authentication - Google Sheets: OAuth2 integration Error Handling - Includes error tracking in Bright Data requests - Conditional logic prevents infinite loops - Wait periods prevent API rate limiting Data Processing - Mapping Mode: Auto-map input data - Schema: 35+ predefined fields with string types - Conversion: No type conversion (preserves raw data) Setup Requirements Prerequisites 1. Bright Data Account: Active account with API access 2. Google Account: With Sheets API enabled 3. n8n Instance: Self-hosted or cloud version Configuration Steps 1. API Keys: Configure Bright Data bearer token 2. OAuth Setup: Connect Google Sheets credentials 3. Dataset ID: Verify correct Bright Data dataset ID 4. Sheet Access: Ensure proper permissions for target spreadsheet Environment Variables - BRIGHTDATAAPIKEY: Your Bright Data API authentication token Use Cases Business Intelligence - Competitor analysis and market research - Customer sentiment monitoring - Brand reputation tracking Data Analytics - Review trend analysis - Rating distribution studies - Customer feedback aggregation Automation Benefits - Scalability: Handle multiple URLs sequentially - Reliability: Built-in error handling and retry logic - Efficiency: Automated data collection and storage - Consistency: Standardized data format across all scrapes Limitations and Considerations Rate Limits - Bright Data API has usage limitations - 1-minute wait periods help manage request frequency Data Volume - Limited to 2 results per request (configurable) - Large datasets may require multiple workflow runs Compliance - Ensure compliance with Trustpilot's terms of service - Respect robots.txt and rate limiting guidelines Monitoring and Maintenance Status Tracking - Monitor workflow execution logs - Check Google Sheets for data accuracy - Review Bright Data usage statistics Regular Updates - Update API keys as needed - Verify dataset ID remains valid - Test workflow functionality periodically Workflow Metadata - Version ID: dd3afc3c-91fc-474e-99e0-1b25e62ab392 - Instance ID: bc8ca75c203589705ae2e446cad7181d6f2a7cc1766f958ef9f34810e53b8cb2 - Execution Order: v1 - Active Status: Currently inactive (requires manual activation) - Template Status: Credentials setup completed For any questions or support, please contact: Email or fill out this form
Download the workflow JSON file after purchase.
Open n8n β click the menu β Import from File.
Select the downloaded JSON and import.
Set up credentials for each node that requires them.
Click Execute Workflow to test, then activate.
Setup guide included
Purchase to unlock the full step-by-step guide
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.