Step 2: Connect Bright Data API Requests

These nodes trigger the Bright Data scrape and poll for completion before downloading results.

1. Open Trigger Bright Data Job and set URL to https://api.brightdata.com/datasets/v3/trigger with Method POST.
2. Set JSON Body to =[ { "url": "{{ $json['Competitor TRUSTPILOT URL (include https://www.trsutpilot.com/review/'] }}", "date_posted": "{{ $json['Please select the time frame of reviews you\'d like. If it\'s a big brand go with 30 days'] }}" } ].
3. In Query Parameters, set dataset_id to [YOUR_ID] and include_errors to true.
4. In Header Parameters, set Authorization to Bearer [CONFIGURE_YOUR_API_KEY].
5. Open Delay for Data Poll and set Unit to minutes and Amount to 2.
6. Open Fetch Snapshot Status and set URL to =https://api.brightdata.com/datasets/v3/progress/{{ $('Trigger Bright Data Job').item.json.snapshot_id }}, and keep the Authorization header as Bearer [CONFIGURE_YOUR_API_KEY].
7. In Snapshot Status Check, confirm the condition uses ={{ $json.status }} equals running.
8. Open Retrieve Bright Data Results and set URL to =https://api.brightdata.com/datasets/v3/snapshot/{{ $('Trigger Bright Data Job').item.json.snapshot_id }} with query format set to json and the same Authorization header.

Step 3: Connect Google Sheets

Store retrieved reviews in Google Sheets for recordkeeping and downstream filtering.

1. Open Append Reviews to Sheet and confirm Operation is set to append.
2. Set Document to [YOUR_ID] and Sheet to gid=0.
3. Credential Required: Connect your googleSheetsOAuth2Api credentials.

Step 4: Filter and Aggregate Low Ratings

This stage keeps only 1–2 star reviews and compiles review text for summarization.

1. Open Filter Low Ratings and ensure conditions use ={{ $json.review_rating }} equals 1 OR 2.
2. Open Compile Review Text and set Fields To Aggregate to aggregate review_content into Aggregated_reviews.

Step 5: Set Up the AI Summary

Use an LLM to generate insights and ad copy from the aggregated complaints.

1. Open LLM Summary Builder and set Prompt Type to define.
2. Set Text to =Read the following bad reviews, these are reviews of our competitors: {{ $json.Aggregated_reviews }} --- After reading them, summarize their weakest points. Don't mention the competitor name. Write 3 different ads copy for our Facebook ads campaign, addressing these concerns.
3. Open OpenAI Chat Engine and select the model gpt-4o-mini.
4. Credential Required: Connect your openAiApi credentials in OpenAI Chat Engine, which powers LLM Summary Builder.

Step 6: Configure the Email Output

Send the summary and full complaint breakdown to your inbox.

1. Open Email Marketing Summary and set Send To to [YOUR_EMAIL].
2. Set Subject to =Summary of Complaints of competitor: {{ $('Form Intake Trigger').item.json['Competitor TRUSTPILOT URL (include https://www.trsutpilot.com/review/'] }}.
3. Set Message to =Based on the following Trustpilot page: {{ $('Form Intake Trigger').item.json['Competitor TRUSTPILOT URL (include https://www.trsutpilot.com/review/'] }} Here is a summary of recent complaints including ideas for ad copy: {{ $json.text }} ----------------------------- I'm also attaching a break down of all recent complaints {{ $('Compile Review Text').item.json.Aggregated_reviews }} .
4. Credential Required: Connect your gmailOAuth2 credentials.

Step 7: Test & Activate

Validate the workflow end-to-end before turning it on.

1. Click Execute Workflow, then submit the Form Intake Trigger form with a valid Trustpilot URL.
2. Confirm Snapshot Status Check routes back to Delay for Data Poll when status is running, and to Retrieve Bright Data Results when it completes.
3. Verify new rows appear in Google Sheets from Append Reviews to Sheet and only 1–2 star reviews continue through Filter Low Ratings.
4. Check your inbox for the email from Email Marketing Summary containing a summary and the aggregated complaints.
5. Once successful, toggle the workflow to Active for production use.