Extract and Analyze X Tweets, Save Results to Google Sheets
Workflow Description
Intelligent automation that monitors X tweets, analyzes them using an AI agent powered by OpenAI, categorizes content, and automatically stores results in Google Sheets while maintaining conversation context through memory buffers.
How it works
- 1.Activate Chat Trigger to initiate analysis workflow
- 2.Extract and organize tweet data from X into batches
- 3.Process each batch through advanced AI agent for content analysis
- 4.Store categorized results and insights in Google Sheets tables
- 5.Preserve context and historical data using memory system
Use cases
- Monitor key accounts on X and auto-archive analyzed tweets
- Automatically categorize and organize tweets by type or relevance in Sheets
- Track trends and discussions with complete structured documentation
Requirements
- Active X/Twitter account with API access
- OpenAI API key
- Full access to Google Sheets
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 (19)
Information Extractor
Information Extractor
OpenAI Chat Model1
OpenAI
If
If
Google Sheets
Google Sheets
Code
Code
Loop Over Items
Split In Batches
Replace Me
No Op
No Operation, do nothing
No Op
Sticky Note
Sticky Note
Sticky Note1
Sticky Note
Sticky Note2
Sticky Note
Triggered on Restaurant Chat workflow
Execute Workflow Trigger
When chat message received
Chat Trigger
AI Agent
Agent
OpenAI Chat Model
OpenAI
Call n8n Workflow Tool
Tool Workflow
Last 5 conversations Memory
Memory Buffer Window
Sticky Note3
Sticky Note
Sticky Note4
Sticky Note