Scrape Trustpilot Reviews Using Bright Data for Winning Ad Insights
This workflow automatically captures and analyzes negative reviews within a specified time frame by having users input the competitor's Trustpilot review link and the time range. It stores the review data in Google Sheets, filters out low-rated reviews, and uses AI to generate targeted advertising copy. Ultimately, the analysis results and advertising copy are sent to the marketing team via email, helping to enhance advertising effectiveness and optimize marketing strategies, thereby achieving automation in competitor analysis and content creation.
Workflow Name
Scrape Trustpilot Reviews Using Bright Data for Winning Ad Insights
Key Features and Highlights
This workflow enables users to input a competitor’s Trustpilot review URL along with a specified time range, then automatically calls Bright Data’s API to scrape Trustpilot review data within that period. All reviews are stored in Google Sheets, where low-rated (1-star and 2-star) negative reviews are automatically filtered and aggregated. The aggregated negative feedback is then analyzed using the OpenAI GPT-4o-mini model to extract competitors’ weaknesses and automatically generate three targeted Facebook ad copies addressing these pain points. Finally, the analysis summary and ad copies are sent via email to the marketing team, supporting ad campaigns and marketing strategy optimization.
Core Problems Addressed
- Automates the collection of authentic competitor customer feedback, eliminating the complexity and instability of manual scraping
- Precisely filters and consolidates negative reviews to quickly identify weaknesses in competitors’ products or services
- Leverages AI to generate targeted advertising copy, enhancing the relevance and conversion potential of marketing materials
- Achieves end-to-end automation of data storage, processing, and result delivery, saving time on market research and content creation
Use Cases
- Marketing teams conducting competitive analysis and ad creative planning
- E-commerce or brand managers identifying industry pain points to optimize their own products and services
- Data analysts automating the collection and organization of customer review data
- Advertising agencies rapidly generating competitor-focused ad creatives for clients
Main Workflow Steps
- User submits the target competitor’s Trustpilot URL and review time range via an n8n built-in form
- Sends a POST request to Bright Data API to initiate review data scraping
- Polls the API to check the scraping status until data collection is complete
- Retrieves the review data and writes it into a Google Sheets document for easy viewing and sharing
- Filters out negative reviews with 1-star and 2-star ratings
- Aggregates the content of all negative reviews into a text summary
- Calls the OpenAI model to generate a summary of competitor weaknesses and three Facebook ad copies based on the negative feedback
- Sends the summary and ad creatives to the marketing team via Gmail node
Involved Systems and Services
- Bright Data (Data scraping API)
- Google Sheets (Data storage and management)
- OpenAI GPT-4o-mini (Natural language processing and copy generation)
- Gmail (Email delivery)
- n8n Form Trigger (User input interface)
Target Users and Value
- Marketing professionals and ad creative teams: Quickly gain insights from competitor negative feedback and generate precise ad copy
- Brand and product managers: Stay informed of competitor user pain points to guide product improvements
- Data analysts and automation engineers: Automate competitor data collection and analysis workflows
- Advertising agencies: Enhance client service efficiency by providing data-driven marketing recommendations
By integrating multiple automation and AI services, this workflow makes competitive analysis and marketing content creation efficient, intelligent, and systematic—significantly boosting market insight and advertising effectiveness.