Scrape Trustpilot Reviews Using Bright Data & GPT-4o-mini for Winning Ad Copy

🔍 Competitor Review Scraper & Ad Copy Generator (Trustpilot + Bright Data + GPT-4o-mini)

📌 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 Trigger (Manual Form Submission) Input required:

Competitor’s Trustpilot URL

Review timeframe (30d, 3m, 6m, 12m)

Fetch Reviews

Calls Bright Data’s Dataset API with URL & timeframe

Polls until snapshot is ready

Retrieve & Store

Extracts all reviews

Saves them into a structured Google Sheet

Filter & Aggregate

Filters to only 1–2 star reviews

Summarizes common negative feedback

Generate Ad Copy

Sends the summary to OpenAI GPT-4o-mini

Produces 3 variations of ad copy targeting pain points

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/1Zi758ds2_aWzvbDYqwuGiQNaurLgs-leS9wjLWWlbUU/edit?gid=0#gid=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-4o-mini

**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-4o-mini prompts for tone or vertical

💬 Support & Feedback Need help or customization?

📧 Email: Yaron@nofluff.online 📺 YouTube: @YaronBeen 🔗 LinkedIn: linkedin.com/in/yaronbeen

📚 Bright Data Docs: docs.brightdata.com/introduction