Automated sentiment analysis and tweet storage from Twitter to MongoDB and Postgres

• Monitor public sentiment on specific dates through historical tweets.
• Store and analyze tweet data for marketing campaigns.
• Automate notifications for significant social media events.
• Enhance content strategies based on sentiment analysis.

Triggers daily to collect tweets from Twitter. Stores tweets in MongoDB for unstructured data. Analyzes tweet sentiment using Google Cloud Natural Language. Stores sentiment scores and text in Postgres for structured data. Sends notifications to Slack for tweets with high sentiment scores.

1. 1
   Import the workflow template into n8n.
2. 2
   Configure Twitter credentials for tweet extraction.
3. 3
   Set up MongoDB and Postgres credentials for data storage.
4. 4
   Adjust Slack channel settings for notifications.
5. 5
   Activate the workflow to start the automation.