Collect tweets and analyze sentiment with OpenAI
Workflow Description
This automation retrieves tweets about your topic from X, analyzes emotional tone using OpenAI's language model, and organizes results in Google Sheets. It classifies sentiments as positive, negative, or neutral for actionable brand insights.
How it works
- 1.Manual or scheduled trigger to start the workflow
- 2.Search and retrieve relevant tweets from X
- 3.Extract text and metadata from each tweet
- 4.Send tweets to OpenAI for sentiment analysis
- 5.Classify results as positive, negative, or neutral
- 6.Store analyzed data with scores in Google Sheets
Use cases
- Monitor brand reputation by tracking customer sentiment in real-time
- Analyze customer feedback on new product launches
- Identify market trends and consumer opinions from public conversations
Requirements
- Active X account with valid API credentials
- OpenAI project with API key configured
- Google Sheets spreadsheet set up for data storage
- Reliable internet connection
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