Form Submission to Google Sheets and Gmail Notification

### Scrape Trustpilot Reviews Using Bright Data for Winning Ad Insights

This **n8n workflow** scrapes Trustpilot reviews of a specified competitor using **Bright Data's dataset API**. Users input the competitor's Trustpilot URL and select a timeframe (30 days, 3 months, 6 months, or 12 months) via an n8n form.

**Workflow steps:**

- Sends a request to Bright Data to fetch Trustpilot reviews based on user input.
- Polls Bright Data until the dataset is ready.
- Retrieves the reviews and logs them into a Google Sheet.
- Filters the results to isolate negative reviews (ratings of 1 or 2 stars).
- Aggregates negative reviews into summarized text.
- Uses OpenAI's GPT-4o-mini to analyze competitor weaknesses and generate three Facebook ad copy variations addressing these pain points.
- Emails the summary, including suggested ad copy and aggregated reviews, to the marketing team.