Automated Content Aggregation and Sentiment Analysis
detail.loadingPreview
This workflow automates the collection of relevant content from Twitter, filters out retweets and outdated posts, and analyzes their sentiment. It then stores the curated content and its sentiment score in Strapi for further use.
About This Workflow
This n8n workflow is designed to efficiently aggregate and analyze content from Twitter. It begins by periodically searching for tweets containing specific keywords like 'strapi' or 'n8n.io'. The system then refines these results by simplifying the data, removing URLs, and standardizing the output. A crucial step involves filtering out retweets and posts older than 30 minutes to ensure fresh, original content. For relevant tweets, the workflow utilizes Google Cloud Natural Language to perform sentiment analysis, gauging the emotional tone. Finally, the processed content, author, creation date, and URL, along with the sentiment score, are stored in a Strapi CMS under the 'posts' content type. This provides a clean, analyzed dataset for marketing or operational purposes.
Key Features
- Automated Tweet Fetching: Regularly searches Twitter for relevant content based on defined keywords.
- Content Curation: Filters out retweets and older posts to maintain relevance and originality.
- Sentiment Analysis: Leverages Google Cloud Natural Language to determine the emotional tone of tweets.
- Data Enrichment: Extracts and formats key information such as author, creation date, and direct URL.
- Strapi Integration: Seamlessly stores processed content and sentiment scores in Strapi CMS.
How To Use
- Configure Trigger: Set the 'Every 30 Minutes' node to your desired polling interval.
- Define Search Terms: In the 'Search Tweets' node, update
searchTextwith your target keywords and language. - Connect Strapi: Ensure your Strapi credentials are set up in the 'Store in Strapi' node, and verify the
contentTypeis correctly set to 'posts'. - Set Up Google Cloud NLP: Configure your Google Cloud Natural Language credentials for sentiment analysis.
- Review Filters: Adjust the conditions in the 'Is Retweet or Old?' node if your definition of 'old' or 'retweet' needs modification.
- Map Sentiment Thresholds: Modify the
value2in the 'Positive Form Sentiment?' and 'Positive Tweet Sentiment?' nodes to adjust the sentiment score thresholds for further processing if needed.
Apps Used
Workflow JSON
{
"id": "69052fcc-fd86-4c80-9af1-6886e75fefe2",
"name": "Automated Content Aggregation and Sentiment Analysis",
"nodes": 29,
"category": "Operations",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 69052fcc-fd86...
About the Author
SaaS_Connector
Integration Guru
Connecting CRM, Notion, and Slack to automate your life.
Statistics
Related Workflows
Discover more workflows you might like
Universal CSV to JSON API Converter
Effortlessly transform CSV data into structured JSON with this versatile n8n workflow. Integrate it into any application as a custom API endpoint, supporting various input methods including file uploads and raw text.
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.
On-Demand Microsoft SQL Query Execution
This workflow allows you to manually trigger and execute any SQL query against your Microsoft SQL Server database. Perfect for ad-hoc data lookups, administrative tasks, or quick tests, giving you direct control over your database operations.