Scrape Trustpilot reviews using Bright Data & GPT-5.5 for winning ad copy
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
Nodes used (10)
- HTTP Request
n8n-nodes-base.httpRequest - n8n Form Trigger
n8n-nodes-base.formTrigger - Wait
n8n-nodes-base.wait - If
n8n-nodes-base.if - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Gmail
n8n-nodes-base.gmail - Filter
n8n-nodes-base.filter - Aggregate
n8n-nodes-base.aggregate - Google Sheets
n8n-nodes-base.googleSheets
What it does
🔍 Competitor Review Scraper & Ad Copy Generator (Trustpilot + Bright Data + GPT-5.5) 📌 Who It's For Marketers, business owners, and agencies looking to: - Analyze competitor pain points - Generate high-impact Facebook ad copy - Automate manual data processing 🧩 How It Works This n8n-based workflow combines Bright Data, Google Sheets, and OpenAI to scrape, process, and transform Trustpilot reviews into ready-to-use ad copy. 🔹 Step-by-Step Breakdown 1. Trigger (Manual Form Submission) Input required: Competitor’s Trustpilot URL Review timeframe (30d, 3m, 6m, 12m) 2. Fetch Reviews Calls Bright Data’s Dataset API with URL & timeframe Polls until snapshot is ready 3. Retrieve & Store Extracts all reviews Saves them into a structured Google Sheet 4. Filter & Aggregate Filters to only 1–2 star reviews Summarizes common negative feedback 5. Generate Ad Copy Sends the summary to OpenAI GPT-5.5 Produces 3 variations of ad copy targeting pain points 6. Distribute Insights Sends ad copy + summary via email to the marketing team ✅ Requirements -LLM Account -Google Sheets - Copy this sheet: https://docs.google.com/spreadsheets/d/1Zi758ds2aWzvbDYqwuGiQNaurLgs-leS9wjLWWlbUU/edit?gid=0gid=0 -Bright Data account ⚙️ Setup Instructions Step 1: Google Sheets Copy this Google Sheets template Do not change column headers Step 2: n8n Credential Setup Google Sheets: OAuth2 Bright Data: Authorization Header OpenAI: API Key for GPT-5,4 Step 3: Import Workflow Import the .json file into n8n Configure your sheet + dataset ID Adjust GPT prompts as needed Step 4: Run the Workflow Trigger via form Receive ad copy + review insights via email 🧠 Tips & Best Practices - Bright Data snapshots may take time — polling is handled - Focusing on 1–2 star reviews yields the most actionable pain points - You can customize GPT-5.5 prompts for tone or vertical 💬 Support & Feedback Need help or customization? 📧 Email: [email protected] 📺 YouTube: @YaronBeen 🔗 LinkedIn: linkedin.com/in/yaronbeen 📚 Bright Data Docs: docs.brightdata.com/introduction