Analyze Reddit competitor sentiment with Bright Data and GPT-5.4

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.