AutomationMart
Home/Browse/X (Twitter) brand sentiment analysis with Gemini AI & Slack alerts
n8n

X (Twitter) brand sentiment analysis with Gemini AI & Slack alerts

n8nn8n29 modulesv1.0
SlackGoogle SheetsGemini

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 workflow then automatically analyzes new tweets with Google Gemini and sends tailored alerts to Slack. How it works This workflow automates the analysis and reporting part of your social media monitoring: tweet Hunting: It finds tweets for the q

At a glance

X (Twitter) brand sentiment analysis with Gemini AI & Slack alerts is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Slack, Google Sheets, Gemini. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Slack, Google Sheets, Gemini
Modules
29
Price
Free
Version
v1.0
X (Twitter) brand sentiment analysis with Gemini AI & Slack alerts workflow diagram

About this workflow

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 workflow then automatically analyzes new tweets with Google Gemini and sends tailored alerts to Slack. How it works This workflow automates the analysis and reporting part of your social media monitoring: tweet Hunting: It finds tweets for the query entered in the set node and passes the data to the google sheets Fetches New Tweets: It gets all new rows from your Google Sheet that haven't been processed yet (it looks for "Notmarked" in the 'action taken' column). Prepares for AI: It combines the data from all new tweets into a single, clean prompt for the AI to analyze. AI Analysis with Gemini: It sends the compiled data to Google Gemini, asking for a full summary report and a separate, machine-readable JSON list of any urgent items. Splits the Response: The workflow intelligently separates the AI's text summary from the JSON data for urgent alerts. Sends Notifications: The high-level summary is sent to a general Slack channel (e.g., #brand-alerts). Each urgent item is sent as a separate, detailed alert to a high-priority Slack channel (e.g., #urgent). Set up steps It should take about 5-10 minutes to get this workflow running. 1. Prerequisite - Data Source: Ensure you have a Google Sheet being populated with tweet data. For a complete automation, you can set up a new google sheet with the same structure for saving the tweets data and run the Tweet Scraper on a schedule. 2. Configure Credentials: Make sure you have credentials set up in your n8n instance for Google Sheets, Google Gemini (PaLM) API, and Slack. 3. Google Sheets Node ("Get row(s) in sheet"): Select your Google Sheet containing the tweet data. Choose the specific sheet name from the dropdown. Ensure your sheet has a column named action taken so the filter works correctly. 4. Google Gemini Chat Model Node: Select your Google Gemini credential from the dropdown. 5. Slack Nodes ("Send a message" & "Send a message1"): In the first Slack node, choose the channel for the summary report. In the second Slack node, choose the channel for urgent alerts. 6. Save and Activate: Once configured, save your workflow and turn it on!

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Export data from Facebook Insights (advanced) - PART 1 - receiving webhook

This scenario listens to the [other](https://www.integromat.com/en/integration/4265-create-a-job-in-facebook-insights-advanced-part-2) scenario where the request for Facebook Insights report is requested. When a new webhook is received, Make checks the status of the report being created. If the report is ready, the data are sent to Google Sheets spreadsheet. Otherwise a new request for check of the status is sent with a delay. This scenario is intended for advanced reports which take more time t

Free

Post new Facebook videos to Slack

Every time a new video is posted to Facebook, Make will automatically post it to Slack.

Free

Filter and update rows in Google Sheets using Powerlink queries

Automatically filter Google Sheets rows, execute Powerlink queries, and update rows based on query results, streamlining data management and analysis.

Free

Effortless job hunting: Let this automation find your next role

Find Job Postings from LinkedIn, Indeed, and Glassdoor and Save Them to Google Sheets Using AI Overview Effortlessly discover and apply to jobs tailored to your profile—AI handles the search, you handle the interviews. Say goodbye to endless job board scrolling. This automation leverages AI to analyze your resume, identify your skills, experience, and more, to match you with the most relevant job opportunities. It sources job postings from LinkedIn, Indeed, Glassdoor, ZipRecruiter, Monster, and

Free

Send email notifications with content from Google Sheets

Automatically send email notifications using content from Google Sheets. Extract data from Google Sheets and trigger email alerts for streamlined communication.

Free

Fetch range values from Google Sheets and update a cell from ChatGPT responses

This template fetched range values from Google Sheets, generate responses using ChatGPT, and update a cell with new insights for streamlined data management.

Free

Automated product review monitoring with sentiment analysis via Decodo, Gemini & Telegram

Decodo-powered review aggregation to Google Sheets with Gemini analysis and Telegram alerts Who’s it for This template is designed for e-commerce owners, marketplace sellers, product teams, and CX/reputation managers who need an automated way to monitor product reviews. It’s ideal for anyone tracking Amazon listings or other URLs and wants AI-powered sentiment, summaries, and alerts without manual scraping. What it does This workflow automatically retrieves product URLs from Goo

Free

Extract seed-funded startup data with RSS, GPT-4.1-MINI & BrightData to Excel

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. What It Does This workflow automatically discovers recently seed-funded startups by monitoring RSS feeds for funding announcements. It uses Bright Data to scrape full article content, then extracts structured company information using OpenAI (GPT). The data is exported to an Excel sheet on OneDrive, providing sales teams with a real-time list of qualified leads without any manual effort. How It W

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free