Automated review scraping from Trustpilot to Google Sheets

• Scraping competitor reviews for marketing insights
• Automating data entry into Google Sheets for review analysis
• Generating targeted ad copy based on competitor weaknesses

User submits a form with competitor Trustpilot URL and review timeframe Workflow triggers an API call to Bright Data to fetch reviews Polls for dataset readiness and retrieves the reviews Filters negative reviews and aggregates them into a summary Uses OpenAI to create ad copy addressing competitor weaknesses Emails the summary and ad copy to the marketing team

1. 1
   Import the workflow template into your n8n instance
2. 2
   Configure the Google Sheets and OpenAI credentials
3. 3
   Set your Bright Data API key in the HTTP request nodes
4. 4
   Customize the email recipient in the Send Summary To Marketers node
5. 5
   Test the workflow by submitting the form with a competitor's URL