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: 1. Weekly schedule trigger runs on Monday at 8 AM. 2. Reads the 'competitorbrands' sheet (columns: brandname, url, industry). 3. Sends each URL to Bright Data for Reddit post discovery. 4. Validates the Bright Data API response. 5. GPT-5.4 analyzes sentiment distribution and identifies competitive opportunities. 6. Parses AI output and merges with original brand data. 7. Filters by AI confidence (>= 0.7). 8. Brands with competitiveopportunityscore >= 70 trigger email alerts and go to 'highopportunitybrands'. 9. Lower-scoring brands go to 'competitorsentiment'. 10. Low-confidence results go to 'lowconfidencesentiment'.

Setup: - Create a Google Sheet with a 'competitorbrands' tab containing columns: brandname, url, industry. - Create output tabs: highopportunitybrands, competitorsentiment, lowconfidencesentiment. - 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 competitiveopportunityscore over time to spot widening vulnerabilities. - Use the vulnerabilityareas field to inform your product positioning and messaging. - Combine with your own product monitoring (Template 21) for a complete competitive picture.