Scrape Competitor Reviews & Generate Ad Creatives with Bright data and OpenAI
How the Flow Runs
-
Fill the Form
- Enter the Amazon product URL to analyze competitor reviews.
-
Trigger Bright Data Scraper
- Bright Data scrapes Amazon reviews based on the provided URL.
-
Wait for Snapshot Completion
- Periodically checks Bright Data until the scraping is complete.
-
Retrieve JSON Data
- Collects the scraped review data in JSON format.
-
Save Reviews to Google Sheets
- Automatically appends the scraped reviews to your Google Sheets.
-
Aggregate Reviews
- Consolidates all reviews into a single summary for simpler analysis.
-
Analyze Reviews with OpenAI LLM
- Sends the aggregated reviews to OpenAI (GPT-4o mini) to summarize competitors’ main weaknesses clearly.
-
Generate Creative Ad Image
- OpenAI generates a visually appealing 1080x1080 ad image addressing these identified pain points.
-
Send Ad Creative via Gmail
- Automatically emails the creative and review summary to your media buying team for immediate use in Meta ads.
What You Need
- Google Sheets: Template
- Bright Data: Dataset and API key:
www.brightdata.com
- OpenAI API Key: For GPT-4o mini or your preferred LLM
- Automation Tool: Ensure it supports HTTP Requests, Wait, Conditional (If), Google Sheets integration, Form Trigger, OpenAI integration, and Gmail integration.
Form Fields to Fill
- Amazon Product URL: Enter the competitor’s product URL from Amazon.
Setup Steps
- Copy the provided Google Sheet template.
- Import the JSON workflow into your automation tool.
- Update credentials for Bright Data, Google Sheets, Gmail, and OpenAI.
- Test manually by submitting the form and verifying functionality.
- Optional: Set a schedule for regular workflow execution.
Bright Data Trigger Example
[
{
"url": "https://www.amazon.com/example-product"
}
]
Tips
Frequently update URLs to ensure fresh insights.
Allow more wait time for extensive data scrapes.
Focus on targeted products to optimize cost-efficiency.
Need Help?
Email: [[email protected]](/cdn-cgi/l/email-protection)
Resources:
YouTube:
https://www.youtube.com/@YaronBeen/videos
LinkedIn:
https://www.linkedin.com/in/yaronbeen/
Bright Data Documentation:
https://docs.brightdata.com/introduction
