Scrape Competitor Reviews & Generate Ad Creatives with Bright Data & OpenAI

Input Amazon product URL → Bright Data scrapes reviews → OpenAI summarizes pain points & generates 1080×1080 image → Gmail sends to media buyers

Who

Marketers and ops teams who need rapid competitor weakness insights and Meta ad creatives

You get

Automatically scrape Amazon competitor reviews, aggregate weaknesses, generate a creative image, and email it to the media buying team

You need

n8n · Bright Data · Google Sheets · Gmail

Steps

1. Prepare the Google Sheets template

   Open the author's Google Sheets template and make a copy to your account. In the n8n Google Sheets node, replace the documentId with your actual document ID.

   Setup guidance · Source text。Google Sheets node configuration; replace documentId after copying the template

   Copy prompt

   In this workflow, I use Google Sheets to store the results. 
   
   You can use my template to get started faster:
   
   1. [Click on this link to get the template](https://docs.google.com/spreadsheets/d/1IR-yMQwEFTjbTCSPvVlQ54zQsnG0IRauTjPGoBWmR8U/edit?usp=sharing)
   2. Make a copy of the Sheets
   3. Add the URL to this node

2. Import workflow and configure credentials

   Import the workflow JSON into n8n. Configure credentials in the corresponding nodes: Bright Data API key (HTTP Request header), OpenAI API key (OpenAI Chat Model and OpenAI Image nodes), Google Sheets OAuth2, and Gmail OAuth2. Verify that the Google Sheets node's sheetName and documentId point to your copied template.

3. Submit the Amazon product URL

   Submit a competitor's Amazon product URL via the n8n Form Trigger. The form field is required; example format: https://www.amazon.com/.../dp/...

4. Wait for Bright Data scraping to complete

   The workflow automatically sends a scraping request to Bright Data, then enters a Wait node to poll. An If node checks the snapshot status: if still running, it loops back to wait; if complete, it proceeds to retrieve the JSON data.

5. Aggregate reviews and summarize weaknesses with OpenAI

   Scraped reviews are merged by review_text into Aggregated_reviews via the Aggregate node, then fed into the Basic LLM Chain. The model uses gpt-4o-mini to output a summary of the competitor's weakest points without naming the competitor.

   Execution prompt · Source text。Basic LLM Chain node text field (promptType=define)

   Copy prompt

   =Read the following reviews, these are reviews of our competitors:
   {{ $json.Aggregated_reviews }}
   
   ---
   After reading them, summarize their weakest points.
   Don't mention the competitor name.

   Setup guidance · Source text。Sticky Note4: LLM prompt adjustment suggestion, not a runtime instruction

   Copy prompt

   Adjust This Prompt with:
   1. Add info about your company and offer.
   
   2. The template requires the LLM to generate a summary of recent reviews but you can adjust it

6. Generate 1080×1080 ad image

   The OpenAI Image node generates a 1080×1080 ad image based on the weakness summary from the previous step. The prompt defines dimensions, target audience, visual style, and background colors in JSON format.

   Execution prompt · Source text。OpenAI Image node prompt field (resource=image)

   Copy prompt

   ={
     "ad_dimensions": {
       "width": 1080,
       "height": 1080
     },
     "target_audience": "B2C customer",
     "pain_points_source": "choose one pain point based on this {{ $json.text }}",
     "ad_requirements": {
       "image_style": "weird-and-fun",
       "weird_objects": [
         "Fruit with Faces",
         "Realistic People"
       ],
       "focus": "address the biggest pain point of competitors",
       "avoid_naming_competitors": true,
       "headline": {
         "position": "No",
         "text_only": "No",
         "other_text": "No"
       },
       "background": [
         "bold red",
         "black"
       ]
     }
   }

7. Send creative and summary via Gmail

   The Gmail node sends the generated image (as attachment) and the weakness summary text to the media buying team. Replace the sendTo placeholder [email protected] with the actual recipient address.

You are an n8n workflow setup assistant. The user wants to replicate the "Scrape Amazon competitor reviews and auto-generate ad creatives" template. Assist in this order: 1) Confirm the user has prepared Bright Data API key, OpenAI API key, Google Sheets and Gmail OAuth2 credentials; 2) Guide them to copy the Google Sheets template and replace the documentId; 3) Help import the workflow JSON and verify credentials in each node; 4) Explain how to submit a test URL and verify Bright Data polling and OpenAI output. Do not execute API calls or fill in real secrets for the user.