Back to Templates
Analyze Reddit sentiment around competitor brands using Bright Data URL-based scraping and GPT-5.4.
This workflow Reads competitor post URLs from Google Sheets, scrapes Reddit posts via URL using Bright Data's Reddit Posts API, and uses GPT-5.4 to map sentiment distribution. The AI calculates positive, neutral, and negative sentiment percentages, extracts top complaints and praises, identifies vulnerability areas, and scores the competitive opportunity (0-100). High-opportunity brands trigger alerts to the strategy team.
How it works:
- Weekly schedule trigger runs on Monday at 8 AM.
- Reads the 'competitor_brands' sheet (columns: brand_name, url, industry).
- Sends each URL to Bright Data for Reddit post discovery.
- Validates the Bright Data API response.
- GPT-5.4 analyzes sentiment distribution and identifies competitive opportunities.
- Parses AI output and merges with original brand data.
- Filters by AI confidence (>= 0.7).
- Brands with competitive_opportunity_score >= 70 trigger email alerts and go to 'high_opportunity_brands'.
- Lower-scoring brands go to 'competitor_sentiment'.
- Low-confidence results go to 'low_confidence_sentiment'.
Setup:
- Create a Google Sheet with a 'competitor_brands' tab containing columns: brand_name, url, industry.
- Create output tabs: high_opportunity_brands, competitor_sentiment, low_confidence_sentiment.
- Configure Bright Data API credentials as HTTP Header Auth (Bearer token).
- Connect OpenAI, Google Sheets, and Gmail OAuth2 credentials.
Requirements:
- Bright Data API account (~$0.003-0.005 per URL scrape).
- OpenAI API account (GPT-5.4 costs ~$0.003-0.008 per call).
- Google Sheets OAuth2 credentials.
- Gmail OAuth2 credentials.
Notes:
- Track competitive_opportunity_score over time to spot widening vulnerabilities.
- Use the vulnerability_areas field to inform your product positioning and messaging.
- Combine with your own product monitoring (Template 21) for a complete competitive picture.