Track Brand Reputation with Gemini AI & Google News Sentiment Analysis to Email

Create a powerful brand/company monitoring system that fetches news headlines, performs AI-powered sentiment analysis, and delivers witty, easy-to-read reports via email.

This workflow turns brand mentions into a lively “personality analysis” — making your reports not only insightful but also fun to read. Perfect for teams that want to stay informed and entertained.

How it works ++Data Collection++: A Google Sheets table captures brand name and recipient email which triggers the workflow.

++News Aggregation++: The RSS Read node fetches recent news headlines from Google News based on the specified brand or company keyword.

++Content Processing++: News headlines are aggregated and formatted for AI analysis.

++AI Analysis++: Gemini 2.5 Flash model plays the role of a brand analyst, writing reports as if the brand were a character in a story. It highlights strengths, quirks, and challenges in a witty, narrative-driven style — while still providing sentiment scores and action points.

++Report Generation++: JavaScript code structures the AI response into well-formatted HTML paragraphs for a smooth email reading experience.

++Automated Delivery++: Gmail integration sends the analysis report directly to the specified email address.

How to use

First, create a google sheets document with sheet name="page1", A1 cell name="keyword" and B1 cell name="email". The system will read the keyword & email data when a new row data is entered. Paste the url of your google sheets document into the first trigger node. Select trigger on "row added" in the node. Enter your credentials to connect Gemini PaLM API account in the "message a model" node of Google. Enter your credentials to connect Gmail account in the "send a message" node.

The workflow automatically runs when new row is detected. Recipients receive comprehensive sentiment analysis reports within minutes!

Requirements

-Google Sheets URL -Google Gemini API credentials for AI analysis -Gmail API credentials for email delivery