Analyze competitor Instagram engagement by scraping profiles with Bright Data and scoring them with GPT-5.4.
This workflow reads competitor Instagram URLs from a Google Sheet, scrapes their profile data using the Bright Data Instagram Profiles dataset, validates the API response, then sends the data to GPT-5.4 for engagement scoring. Each competitor is scored on follower growth, engagement rate quality, content consistency, and audience authenticity (0-25 each, total 0-100). High-scoring competitors trigger email alerts.
How it works:
- Schedule trigger runs the workflow daily.
- Reads competitor URLs from the 'competitor_accounts' sheet.
- Sends each URL to Bright Data's Instagram Profiles API.
- Validates the API response (handles async/error cases).
- GPT-5.4 analyzes profile metrics and scores engagement quality.
- Parses the structured JSON response.
- Filters by AI confidence (>= 0.7 threshold).
- Routes high scorers (engagement_score >= 75) to 'top_performers' with Gmail alert.
- Routes normal results to 'engagement_analysis'.
- Low confidence results go to 'low_confidence_engagement' for review.
Setup:
- Create a Google Sheet with a 'competitor_accounts' tab containing columns: competitor_name, url, our_industry.
- Add output tabs: engagement_analysis, top_performers, low_confidence_engagement.
- Configure all credentials (Bright Data API, OpenAI, Google Sheets, Gmail).
Requirements:
- Bright Data API account (~$0.01-0.03 per profile scrape).
- OpenAI API account (GPT-5.4 costs ~$0.003-0.008 per call).
- Google Sheets OAuth2 credentials.
- Gmail OAuth2 credentials.
Notes:
- Add competitors one per row with their full Instagram profile URL.
- The engagement_score threshold of 75 can be adjusted in the IF node.
- Low confidence results may indicate incomplete profile data from Bright Data.