Analyze Amazon review gaps with Bright Data, OpenAI, Google Sheets, and Slack

Description

Quick overview
This workflow collects Amazon product URLs via an n8n form, pulls reviews from Bright Data, extracts complaint and praise themes with OpenAI (GPT-5.6), identifies competitive gaps versus up to three competitors, then logs findings to Google Sheets and posts a digest to Slack.

How it works
Receives your product URL and up to three competitor Amazon URLs through an n8n form.
Triggers the Bright Data Amazon reviews dataset for all submitted products and polls the snapshot status every 30 seconds until the results are ready (up to 10 minutes).
Downloads the review data, cleans duplicated fields, and keeps a weighted set focused on critical and most-helpful reviews per product.
Sends each product’s review set to OpenAI (GPT-5.6) to extract structured complaint themes, praise themes, and feature requests.
Compares your complaint themes to competitors’ praise themes to identify overlapping “competitive gaps” and uses OpenAI (GPT-5.6) to write a short competitive brief.
Appends one row per top complaint and gap to Google Sheets and posts a formatted digest (including the brief) to a Slack channel.

Setup
Add a Bright Data API key as an HTTP Header Auth credential using an Authorization: Bearer header.
Add an OpenAI credential and ensure the GPT-5.6 model selected in the OpenAI nodes is available to your account.
Connect Google Sheets and set the target spreadsheet URL and the “Review themes” sheet name (or update the workflow to match your sheet).
Connect Slack and set the target channel name in the configuration values (for example, #product).