📊 Track regional sentiment from social media with Bright Data & OpenAI
⚡ 529 views · 📊 Market Research & Insights
💡 Pro Tip — HTTP Request scraping tends to break when sites update their markup. If you’re scraping a major platform, check if ScraperNode covers it — it has maintained scrapers for LinkedIn, Instagram, TikTok, YouTube, and 20+ other platforms that return structured data.
Description
This workflow contains community nodes that are only compatible with the self-hosted version of n8n.
This workflow automatically tracks regional sentiment across social media and news outlets, giving you a real-time pulse on how people in a specific area feel about your brand or topic.
Overview
The automation queries Twitter, Reddit, and major news APIs filtered by geolocation. Bright Data handles location-specific scraping where APIs are limited. OpenAI performs sentiment and keyword extraction, aggregating scores into a daily report stored in Google Sheets and visualized in Data Studio.
Tools Used
- n8n – Coordinates all steps
- Bright Data – Collects geo-targeted data beyond API limits
- OpenAI – Runs sentiment analysis and topic modeling
- Google Sheets – Houses cleaned sentiment metrics
- Data Studio / Looker – Optional dashboard for visualization
How to Install
- Import the Workflow into n8n with the provided
.json. - Configure Bright Data credentials.
- Set Up OpenAI API key.
- Connect Google Sheets and create a destination spreadsheet.
- Customize Regions & Keywords in the Start node.
Use Cases
- Brand Monitoring: Measure public opinion in target markets.
- Political Campaigns: Gauge voter sentiment by district.
- Market Entry: Understand regional attitudes before launching.
- Crisis Management: Detect negative spikes early.
Connect with Me
- Website: https://www.nofluff.online
- YouTube: https://www.youtube.com/@YaronBeen/videos
- LinkedIn: https://www.linkedin.com/in/yaronbeen/
- Get Bright Data: https://get.brightdata.com/1tndi4600b25 (Using this link supports my free workflows with a small commission)
#n8n #automation #sentimentanalysis #geolocation #brightdata #openai #sociallistening #n8nworkflow #nocode #brandmonitoring
🔗 Nodes Used
Trello, AI Agent, OpenAI Chat Model, Auto-fixing Output Parser, Structured Output Parser
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File