TrustPilot Review Analyzer and Tracker using Bright Data and AI - n8n Workflow

• SaaS Product Managers and Owners who need timely insights into customer feedback.


• Data Analysts requiring structured JSON data extracted from unstructured web reviews.


• Users looking for advanced web scraping n8n templates integrating external proxy services like Bright Data.


• Business intelligence teams automating data collection using the powerful n8n node ecosystem.

This comprehensive n8n workflow is designed to automate the often complex task of tracking and analyzing public product reviews, specifically from TrustPilot. It addresses the challenges of dynamic content and scraping resistance by leveraging Bright Data's Web Unlocker service. Once the raw, markdown-formatted review data is collected via the initial n8n node, the automation shifts focus to advanced AI processing. The core value lies in transforming massive blocks of unstructured review text into two valuable formats: a concise summary (ideal for quick insights) and highly structured JSON data (perfect for databases or reporting). This sophisticated n8n workflow ensures data integrity and high-quality analysis by utilizing specialized LangChain n8n nodes powered by OpenAI's GPT-4o-mini model. This entire n8n workflow template ultimately pushes the analyzed data to multiple endpoints, including Google Sheets, local storage, and real-time webhook notifications.

1. Initialization: The n8n workflow is initiated by a Manual n8n trigger for testing purposes. Variables defining the target TrustPilot URL and the Bright Data zone (web_unlocker1) are set using an n8n node.


2. Web Scraping: The Perform Bright Data Web Request n8n node executes an HTTP POST request to Bright Data's API, fetching the target TrustPilot review page content in markdown format.


3. Data Cleaning: The raw markdown is cleaned and converted into pure textual data by the Markdown to Textual Data Extractor n8n node, powered by an OpenAI Language Model (LLM).


4. Parallel AI Analysis: The cleaned text flows into two parallel branches:

1. Data Consolidation: The summarized text and the structured JSON output are merged together. An Aggregate the responses n8n node prepares this complete data package for final output distribution.


2. Distribution: The aggregated data is simultaneously written to three destinations: a Google Sheets n8n node (appending a new row to a 'SaaS Product Review' document), a file saved to disk (for archiving structured JSON), and a real-time Webhook Notification. This ensures comprehensive data storage and instant alerts based on the results of the n8n workflow.

1. Import: Copy the provided n8n workflow JSON and paste it into your n8n canvas using the 'New' -> 'Import from JSON' function.


2. Credentials Setup:

1. Configuration: Update the Set URL and Bright Data Zone n8n node with the specific TrustPilot URL and Bright Data zone name you wish to target. You must also update the specific Google Sheet ID and Sheet name in the Google Sheets n8n node.


2. Output Hooks: Review and update the Webhook URL in the Initiate a Webhook Notification n8n node and the file path in the Write the structured content to disk n8n node if local storage is required.


3. Test: Click the 'Test workflow' n8n trigger to verify successful data retrieval and processing.

Manual Trigger: The initial n8n trigger used for starting the n8n workflow manually during setup and testing.
Set URL and Bright Data Zone (Set n8n node): Defines two key variables, url (https://www.trustpilot.com/review/brightdata.com) and the proxy zone (web_unlocker1), making the n8n workflow easily configurable.
Perform Bright Data Web Request (HTTP Request n8n node): Sends a POST request to https://api.brightdata.com/request using HTTP Header Authentication to retrieve raw web content, configured to request data in markdown format.
Markdown to Textual Data Extractor (Langchain Chain LLM n8n node): Utilizes the LLM to strip HTML, links, and formatting from the raw markdown, resulting in clean, extractable text, serving as a critical step in this n8n workflow.
Structured JSON Data Extractor (Langchain Information Extractor n8n node): Uses the OpenAI Chat Model for Structured Data to rigorously extract specific information fields (like review author, date, and body) based on a detailed JSON schema example.
Summarization Chain (Langchain Chain Summarization n8n node): Creates a concise summary of the textual data, essential for high-level monitoring of the review data.
Aggregate the responses (Aggregate n8n node): Consolidates the results from the summarization and structured extraction branches before final distribution, ensuring the subsequent n8n nodes receive comprehensive data.
Google Sheets (n8n node): Appends the final analyzed data to a spreadsheet named 'SaaS Product Review'.

• Write the structured content to disk (Read/Write File n8n node): Saves a copy of the structured JSON output to a local directory (e.g., d:\TrustPilot-StructuredData.json) for persistent storage and archiving.