Collect tweets and analyze sentiment with OpenAI
Workflow Description
This automation retrieves tweets from X platform, analyzes their sentiment using OpenAI's language model, and logs results to Google Sheets for continuous brand monitoring. Track customer opinions and emotional responses in real time with minimal manual effort.
How it works
- 1.Trigger manually or when new tweets arrive
- 2.Extract tweets mentioning your brand from X
- 3.Send each tweet to OpenAI for sentiment analysis
- 4.Record sentiment classification (positive/negative/neutral) in Google Sheets
- 5.Manage volume and control processing limits
Use cases
- Monitor brand reputation and public perception on social media
- Automatically collect and analyze customer reviews and satisfaction
- Track sentiment trends for quarterly reports and strategic insights
Requirements
- Active X account with API access permissions
- Valid OpenAI API key with sufficient quota
- Editor permissions on target Google Sheets document
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