{"product_id":"n8n-brand-news-digest-google-sheets-gemini-slack-gmail","title":"n8n Brand News Digest: Google Sheets, Gemini, Slack \u0026 Gmail","description":"\u003ch3\u003eAutomated brand news monitoring, AI analysis, and Slack + Gmail alerts\u003c\/h3\u003e\n\u003cp\u003eThis 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 \u003cstrong\u003eSlack\u003c\/strong\u003e and \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduled monitoring:\u003c\/strong\u003e Runs on a schedule and loads your existing Google Sheets news log to use as a deduplication reference.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches Google News RSS:\u003c\/strong\u003e 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).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDrops incomplete items:\u003c\/strong\u003e Removes items missing key fields before processing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDeduplicates:\u003c\/strong\u003e Compares each article’s URL and a generated hash against the Google Sheets log to avoid reposting the same story.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI-driven analysis with Google Gemini:\u003c\/strong\u003e 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.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters and logs:\u003c\/strong\u003e Keeps important items (High\/Medium importance or score above a threshold), appends them to Google Sheets, and compiles a plaintext digest.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDelivers to teams and inboxes:\u003c\/strong\u003e Posts the digest to a Slack channel and emails the same digest via Gmail.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators who need a daily\/weekly pulse on brand mentions across Google News.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building an “AI news brief” for product, marketing, or support teams.\u003c\/li\u003e\n  \u003cli\u003eTeams that want deduped coverage stored in Google Sheets for auditability.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Sheets, Google Gemini (PaLM) API, Slack, Gmail.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow logic:\u003c\/strong\u003e Uses nodes such as \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003emerge\u003c\/strong\u003e to process items, deduplicate via URL\/hash, and attach AI results.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequired setup:\u003c\/strong\u003e 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.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45931004395699,"sku":"N8N-18991","price":54.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Nguy1dvyeA3tSbNLyaL7i_2FUpmMZV.png?v=1788253340","url":"https:\/\/buyflowscripts.com\/products\/n8n-brand-news-digest-google-sheets-gemini-slack-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}