Collect X posts, analyze sentiment, and store in MongoDB with Slack alerts
Loading workflow…
Workflow Description
A scheduled automation that retrieves posts from your X account, analyzes their sentiment and language patterns using Google Cloud Natural Language, stores analyzed data in MongoDB, and sends periodic summaries to your Slack workspace for monitoring trends and engagement.
How it works
- 1.Trigger the workflow on a defined schedule using Cron expressions
- 2.Fetch posts from your X timeline using the Twitter/X API connector
- 3.Analyze text sentiment and extract key entities via Google Cloud Natural Language
- 4.Store original posts and analysis results in MongoDB collections
- 5.Send formatted analysis reports to your designated Slack channel
Use cases
- Monitor brand mentions and user engagement across your X account with persistent historical records
- Automatically categorize posts by sentiment to identify positive, negative, or neutral audience reactions
- Build a searchable archive of your posts with AI-extracted insights for future content strategy analysis
Requirements
- Active X account with valid API credentials and read permissions
- MongoDB instance with write access and proper authentication configured
- Slack workspace with bot token authorized to post messages to channels
- Google Cloud project with Natural Language API enabled and service account setup
Service Value
Ready-made workflow template for automation delivery and service execution.
Apps Used
Details
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (9)
Set
Postgres
Postgres
MongoDB
Mongo Db
Slack
Slack
IF
If
NoOp
No Op
Google Cloud Natural Language
Google Cloud Natural Language
Set
Set
Cron
Cron
Fresh workflows, straight to your inbox
Get newly published DROPIDEA workflows, a clear overview of what they do, and a link to explore them.
- New workflows
- Clear overviews
- Setup guides