Turn competitor reviews into ready to use ad ideas in one flow. Teams capture a product link, gather fresh reviews, and get a summary and image concept by email. Great for marketers who want faster research and creative testing.

The run starts from a form where you paste a product URL. The workflow requests a Bright Data snapshot, waits, and checks status until the data is ready. It pulls all reviews in JSON, saves them into Google Sheets, and aggregates them. An OpenAI model writes a short summary of recent feedback, then an image is generated for a creative idea. Finally, Gmail sends the package to your media buyers.

You will need Bright Data for the dataset, OpenAI for text and image, Google Sheets for storage, and Gmail for delivery. Expect faster launches and less manual scraping work. Use it for weekly creative refresh, competitor tracking, and product research before ad tests.

• Form capture collects a product URL to start the run.
• HTTP request triggers a Bright Data snapshot using your dataset ID and API key.
• Wait node pauses for one minute and supports polling without hitting rate limits.
• If check loops until the snapshot status shows the data is ready.
• HTTP request downloads the snapshot as JSON for clean parsing.
• Google Sheets node writes all reviews into a single sheet for analysis.
• Aggregate node groups recent reviews to feed the summary prompt.
• OpenAI creates a short, clear summary of recent customer feedback.
• OpenAI image generation produces a simple ad visual concept.
• Gmail sends the summary and creative to media buyers automatically.

• Reduce manual review research from 4 hours to 10 minutes
• Automate 90% of copy and image prep for test ads
• Improve data accuracy by 95% with API based collection
• Handle 10 times more product reviews without extra staff
• Connect Bright Data, Google Sheets, OpenAI, and Gmail in one flow
• Deliver summaries and creative concepts minutes after data is ready

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Bright Data, Google Sheets, OpenAI and Gmail. See the Tools Required section above for links to create accounts with these services.
3. In the n8n credentials manager, create OpenAI credentials: choose API Key, paste your OpenAI key from the OpenAI dashboard, and save. Use a clear name like OpenAI Main.
4. In the n8n credentials manager, create Google Sheets OAuth2 credentials: click Create new credential on the Google Sheets node and follow the on screen steps in n8n Cloud.
5. In the n8n credentials manager, create Gmail OAuth2 credentials: open the Gmail node, click Create new credential, and grant access in the Google popup.
6. Get your Bright Data API key from the Bright Data account settings. In both HTTP Request nodes, add the header Authorization with value Bearer YOUR_API_KEY.
7. Open the HTTP Request node that triggers the dataset and confirm the query parameter dataset_id matches your Bright Data dataset. Replace the sample ID if needed.
8. Open the Form Trigger node and ensure it has a field named Amazon Product URL. Copy the form link and keep it for testing.
9. Open the Google Sheets node and select your spreadsheet and target sheet. Make sure the sheet has columns to store review fields like title, body, rating, date, and URL.
10. Check the Wait and If nodes: keep the wait at 1 minute for gentle polling. If you see timeouts, increase the wait or add a max attempts limit.
11. Open the Basic LLM Chain and set the prompt to your tone and offer details. Connect it to the OpenAI Chat Model credentials you created.
12. Open the OpenAI Image node and set size and prompt style. Make sure it uses the same OpenAI credentials.
13. Set the Gmail node recipients to your media buyer list. Add a clear subject line and include the summary and image link in the body.
14. Activate the workflow. Submit the form with a real product URL. Watch the execution: it should trigger the snapshot, poll, pull data, write to Sheets, generate the summary and image, then email the results.
15. Troubleshooting: If no data arrives, verify the dataset_id and API key. If Sheets is empty, check field mappings. If email fails, reauthorize Gmail. If polling never ends, confirm the snapshot ID is returned in the first HTTP request.