Collect tweets and analyze sentiment with OpenAI
Workflow Description
Automation that retrieves tweets from X platform, analyzes the emotional tone of each tweet using advanced OpenAI models, and automatically records results in a Google Sheets spreadsheet for review and further analysis.
How it works
- 1.Trigger search for tweets related to a specific brand name or topic
- 2.Extract text content and metadata from each tweet
- 3.Send tweet to OpenAI for sentiment analysis and classification
- 4.Record analysis results (positive/negative/neutral) in the spreadsheet
Use cases
- Monitor brand reputation on X and automatically understand customer opinions
- Identify negative sentiment quickly to respond and take action immediately
- Gather sentiment data to generate comprehensive reports on follower sentiment
- Study discussion trends around company products or services
Requirements
- Active X account with valid API credentials available
- Google account with edit permissions on a shared Sheets document
- OpenAI API key with sufficient credits for repeated requests
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
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 (20)
Split Out
Split Out
Information Extractor
Information Extractor
If
If
When clicking ‘Test workflow’
Manual Trigger
Limit1
Limit
Sticky Note
Sticky Note
Sticky Note1
Sticky Note
Sticky Note2
Sticky Note
Sticky Note3
Sticky Note
Set Parameters
Set
Get reviews
HTTP Request
Extract
HTML Page
Get rows
Google Sheets
Get Google Sheets
Google Sheets
Get Single review
HTTP Request
Extract review
HTML Page
Update sheet
Google Sheets
Sentiment Analysis
Sentiment Analysis
DeepSeek Chat Model
OpenAI
OpenAI Chat Model
OpenAI