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.