Automated Workflow for Sentiment Analysis and Storage of Twitter and Form Content

Workflow Name

Automated Workflow for Sentiment Analysis and Storage of Twitter and Form Content

Key Features and Highlights

This workflow automatically fetches the latest English tweets from Twitter containing the keywords “strapi” or “n8n.io” at scheduled intervals. It filters out retweets and tweets older than 30 minutes, extracts tweet content and author information, and performs sentiment analysis using Google Cloud Natural Language. Simultaneously, the workflow accepts external form submissions via Webhook, extracts the text, and conducts sentiment analysis on the form content as well. Tweets and form entries that meet the positive sentiment threshold are automatically stored in the Strapi Content Management System, enabling precise content filtering and structured management.

Core Problems Addressed

• Automates real-time monitoring of social media topics, eliminating the need for manual data collection and filtering.
• Utilizes natural language processing to intelligently assess text sentiment, focusing on positive content to enhance content quality.
• Unifies data collection and management of social media and form inputs, improving data integration efficiency.

Application Scenarios

• Brand Reputation Monitoring: Automatically capture and analyze brand-related tweets to promptly identify positive feedback.
• Market Research: Collect user feedback from forms and social media comments to evaluate user sentiment trends.
• Content Management: Filter and archive high-quality content automatically, providing valuable materials for content operations and promotion.
• Customer Relationship Management: Integrate multi-channel user inputs to support customer service and satisfaction improvement analysis.

Main Workflow Steps

1. Automatically trigger the tweet search node every 30 minutes to fetch the latest tweets matching the criteria.
2. Use a “Simplify Results” node to extract tweet text (excluding links), author information, posting time, and tweet URL.
3. Filter out retweets and tweets older than 30 minutes.
4. Perform sentiment analysis on qualifying tweets using Google Cloud Natural Language API.
5. Receive external form submissions via Webhook, simplify and extract text and author fields.
6. Conduct sentiment analysis on the form content as well.
7. Merge analysis results and determine if the sentiment score meets the predefined positive threshold.
8. Store qualifying tweets and form contents separately into the Strapi CMS.

Involved Systems and Services

• Twitter API (Tweet Search)
• Google Cloud Natural Language API (Sentiment Analysis)
• Webhook (Form Data Integration)
• Strapi (Content Management System for storing and managing analyzed content)

Target Users and Value

• Marketing Teams: Automate reputation monitoring and user feedback analysis to enhance response speed and decision-making.
• Content Operators: Efficiently filter high-quality social media content and user submissions to enrich the content repository.
• Product Managers and Customer Support: Gain insights into user sentiment and feedback to optimize product experience and service quality.
• Data Analysts: Integrate multi-channel data for sentiment trend analysis and reporting.

By integrating multiple systems and leveraging intelligent analysis, this workflow automates the collection and sentiment filtering of social media and form data, significantly improving information processing efficiency and the transformation of data into actionable value.