Analyze Reddit competitor sentiment with Bright Data and GPT-5.4

Description

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.