n8n Brand News Digest: Google Sheets, Gemini, Slack & Gmail

Automated brand news monitoring, AI analysis, and Slack + Gmail alerts

This n8n workflow automatically checks Google News RSS for your brand keywords, deduplicates new mentions using a Google Sheets log, analyzes each article with Google Gemini, and sends an “important news” digest to both Slack and Gmail.

What this workflow does

• Scheduled monitoring: Runs on a schedule and loads your existing Google Sheets news log to use as a deduplication reference.
• Fetches Google News RSS: Builds Google News RSS search URLs for each configured keyword, fetches feeds over HTTP, and parses RSS XML into structured fields (title, description, URL, source, published date).
• Drops incomplete items: Removes items missing key fields before processing.
• Deduplicates: Compares each article’s URL and a generated hash against the Google Sheets log to avoid reposting the same story.
• AI-driven analysis with Google Gemini: Sends remaining articles to Google Gemini to generate JSON analysis (summary, sentiment, importance, score, and reason), then merges the AI output back into the article data.
• Filters and logs: Keeps important items (High/Medium importance or score above a threshold), appends them to Google Sheets, and compiles a plaintext digest.
• Delivers to teams and inboxes: Posts the digest to a Slack channel and emails the same digest via Gmail.

Use cases

• SaaS operators who need a daily/weekly pulse on brand mentions across Google News.
• Automation engineers building an “AI news brief” for product, marketing, or support teams.
• Teams that want deduped coverage stored in Google Sheets for auditability.

Technical details

• Integrations: Google Sheets, Google Gemini (PaLM) API, Slack, Gmail.
• Workflow logic: Uses nodes such as if, set, code, merge to process items, deduplicate via URL/hash, and attach AI results.
• Required setup: Configure Google Sheets columns (keyword, title, description, url, source, publishedAt, summary, sentiment, importance, score, hash, processedAt) and provide Gemini credentials and an available Gemini model.