# Daily #OnThisDay tweet collection with sentiment analysis and Slack alerts
This automation monitors public sentiment around the #OnThisDay hashtag on Twitter. Every morning, it collects fresh tweets, analyzes their emotional tone using Google Cloud Natural Language, stores structured results in PostgreSQL and raw text in MongoDB, and sends real-time alerts to Slack when strong emotional reactions are detected. Ideal for professionals who need to respond quickly to spikes in public discussion.
## Who it´s for
- Marketers tracking public opinion by hashtags
- Social media analysts working with historical data
- SMM teams automating Twitter activity monitoring
- Product managers gathering feedback from open sources
## What the automation does
- Triggers daily at 6:00 AM via cron schedule
- Fetches tweets containing the #OnThisDay hashtag via Twitter API
- Stores raw tweet text in MongoDB
- Analyzes sentiment using Google Cloud Natural Language API
- Saves sentiment scores and emotion strength to PostgreSQL
- Sends notifications to a Slack channel when sentiment exceeds a defined threshold
## What´s included
- Ready-to-use n8n workflow
- Trigger and conditional logic pre-configured
- Integrations with Twitter, Slack, Google Cloud Natural Language, PostgreSQL, and MongoDB
- Basic setup and adaptation guide
## Requirements for setup
- n8n account (cloud or self-hosted)
- Twitter API access with read permissions
- Google Cloud Natural Language API enabled and service account key
- Active PostgreSQL and MongoDB instances
- Slack workspace with authorized bot token and target channel
## Benefits and outcomes
- Automated data collection without manual searches
- Real-time alerts on emotionally charged content
- Dual storage of raw and enriched data for analysis and backup
- Enables long-term reporting on sentiment trends
- Saves time on daily hashtag monitoring
- Improves response speed to public feedback
## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via chat
No feedback yet