n8n Data Management Analytics Social Media Management
Contributed by Sabrina Ramonov 🍄. From the community directory at agents.sabrina.dev, republished with permission and full credit.
This workflow allows you to collect tweets, store them in MongoDB, analyze their sentiment, insert them into a Postgres database, and post positive tweets in a Slack channel.
Cron node: Schedule the workflow to run every day.
Twitter node: Collect tweets.
MongoDB node: Insert the collected tweets in MongoDB.
Google Cloud Natural Language node: Analyze the sentiment of the collected tweets.
Set node: Extract the sentiment score and magnitude.
Postgres node: Insert the tweets and their sentiment score and magnitude in a Postgres database.
IF node: Filter tweets with positive and negative sentiment scores.
Slack node: Post tweets with a positive sentiment score in a Slack channel.
NoOp node: Ignore tweets with a negative sentiment score.
Tools used: MongoDB, Postgres, Slack
Download the workflow template (JSON)
Want this running in your business? KOBA42 builds and operates automations like this one.