X (Twitter) brand sentiment analysis with Gemini AI & Slack alerts
Ready for 3.0What this workflow does
This AI workflow has 29 nodes and runs on a schedule (every day) (plus 1 other trigger). Along the way it connects Google Sheets, Google Gemini Chat Model and Slack. It also calls api.twitterapi.io over HTTP.
How it runs
Trigger: On a schedule (every day) (plus 1 other trigger).
- Count (Edit Fields (Set)): sets 2 fields: count, query
- Get row(s) in sheet (Google Sheets): uses Google Sheets
- counter (Edit Fields (Set)): sets 2 fields: counter, cursor
- parser (Code): runs custom JavaScript code
- Wait: pauses before continuing
- Strategist Agent (Basic LLM Chain): sends a prompt to an LLM, with model: Google Gemini Chat Model
- Tweet Scraper (HTTP Request): calls api.twitterapi.io
- summary (Code): runs custom JavaScript code
- parseAlerts (Code): runs custom JavaScript code
- Code: runs custom JavaScript code
…plus 14 more steps. See the full node list below.
Services it uses
HTTP calls to: api.twitterapi.io
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (16)
- Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - Edit Fields (Set)
n8n-nodes-base.set - If
n8n-nodes-base.if - Limit
n8n-nodes-base.limit - Wait
n8n-nodes-base.wait - Switch
n8n-nodes-base.switch - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Google Sheets Tool
n8n-nodes-base.googleSheetsTool - Aggregate
n8n-nodes-base.aggregate - HTTP Request
n8n-nodes-base.httpRequest - Schedule Trigger
n8n-nodes-base.scheduleTrigger - AI Agent
@n8n/n8n-nodes-langchain.agent - Slack
n8n-nodes-base.slack - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm
From the author
This workflow is the AI analysis and alerting engine for a complete social media monitoring system. It's designed to work with data scraped from X (formerly Twitter) using a tool like the Apify Tweet Scraper, which logs the data into a Google Sheet. The…