Scrape competitor reviews generate ad creatives with Bright Da
Scrape Competitor Reviews & Generate Ad Creatives with Bright data and OpenAI How the Flow Runs 1. Fill the Form - Enter the Amazon product URL to analyze co...
🔌 Nodes & Integrations Used (7)
📖 Implementation & Setup Guide
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.
2. **Trigger Bright Data Scraper** - Bright Data scrapes Amazon reviews based on the provided URL.
3. **Wait for Snapshot Completion** - Periodically checks Bright Data until the scraping is complete.
4. **Retrieve JSON Data** - Collects the scraped review data in JSON format.
5. **Save Reviews to Google Sheets** - Automatically appends the scraped reviews to your Google Sheets.
6. **Aggregate Reviews** - Consolidates all reviews into a single summary for simpler analysis.
7. **Analyze Reviews with OpenAI LLM** - Sends the aggregated reviews to OpenAI (GPT-4o mini) to summarize competitors’ main weaknesses clearly.
8. **Generate Creative Ad Image** - OpenAI generates a visually appealing 1080x1080 ad image addressing these identified pain points.
9. **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](https://docs.google.com/spreadsheets/d/1IR-yMQwEFTjbTCSPvVlQ54zQsnG0IRauTjPGoBWmR8U/edit?usp=sharing)
- **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
```json [ { "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: Yaron@nofluff.online
Resources:
YouTube: https://www.youtube.com/@YaronBeen/videos
LinkedIn: https://www.linkedin.com/in/yaronbeen/
Bright Data Documentation: https://docs.brightdata.com/introduction
⚡ How to import this workflow into n8n:
- Click the Direct Download JSON button above to save
Scrape_competitor_reviews_generate_ad_creatives_with_Bright_Da.json. - Log in to your n8n Cloud or self-hosted n8n instance.
- In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
- Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
- Click Execute Workflow to test and switch to Active!
Related Email & Outreach Workflows
View All in Email & Outreach →Abandoned cart recovery for Shopify via Gmail Google Sheets T
Who is this for? This template is ideal for solo store owners, eCommerce marketers, automation beginners, or anyone using Shopify and Gmail who wants to reco...
Add new leads in Lemlist from Airtable
This workflow allows you to add new leads in Lemlist from Airtable. !workflow-screenshot Airtable node: This node lists all the emails that are stored in you...
Add Subscriber and Send Email Campaign
Production-ready n8n automation template for Add Subscriber and Send Email Campaign built by AhiXLight. Seamlessly connects Sendy with 3 configured nodes.
Add new contacts from HubSpot to the email list in Mailchimp
This workflow adds new HubSpot contacts to the Mailchimp email list. Prerequisites - HubSpot account and HubSpot credentials - Mailchimp account and Mailchim...