{"product_id":"weekly-security-rss-digest-automation-with-google-sheets-email","title":"Weekly Security RSS Digest Automation with Google Sheets \u0026 Email","description":"\u003ch3\u003eWeekly Security RSS Digest Automation—drafts, logs, and emails your review\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically collects security and compliance updates from RSS feeds every week, turns them into a plain-English digest with “why this matters” blurbs, logs each digest draft to Google Sheets, and emails it to a reviewer—plus sends a reminder if any drafts go stale.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWeekly Monday 8:00am run:\u003c\/strong\u003e Checks whether \u003ccode\u003eSECURITY_DIGEST_FEED_URLS\u003c\/code\u003e contains one or more RSS feed URLs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRSS collection \u0026amp; filtering:\u003c\/strong\u003e Fetches items from each configured feed, then filters to recent entries within \u003ccode\u003eDIGEST_LOOKBACK_DAYS\u003c\/code\u003e that match \u003ccode\u003eRELEVANCE_KEYWORDS\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDigest drafting:\u003c\/strong\u003e Compiles all filtered items into a single digest draft, assigns a unique digest ID and timestamp, and includes a \u003cem\u003e“no relevant items found”\u003c\/em\u003e message when nothing matches.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets logging:\u003c\/strong\u003e Appends every digest draft (or setup-needed notice) to your Google Sheets log.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReviewer email:\u003c\/strong\u003e Sends an HTML and text review-request email via SMTP.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup-needed path:\u003c\/strong\u003e If no feeds are configured, it creates a setup-needed notice with an ID, logs it to Google Sheets, and emails the reviewer.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWeekly Thursday 9:00am reminder check:\u003c\/strong\u003e Reads the Sheets log and finds pending drafts older than \u003ccode\u003eSTALE_DRAFT_REMINDER_DAYS\u003c\/code\u003e. If any are stale, it emails a single reminder listing all stale drafts; otherwise it does nothing.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS security teams who want a consistent weekly security RSS digest for review.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers standardizing compliance monitoring with n8n, RSS, and Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eOperations leaders needing a simple review workflow with automatic stale reminders.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/logic:\u003c\/strong\u003e \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003eno op\u003c\/code\u003e, \u003ccode\u003erss feed read\u003c\/code\u003e, and \u003ccode\u003eemail send\u003c\/code\u003e (SMTP).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e RSS feeds (via \u003ccode\u003eSECURITY_DIGEST_FEED_URLS\u003c\/code\u003e) and \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e for audit\/logging.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eSet the required n8n variables (\u003ccode\u003eSECURITY_DIGEST_FEED_URLS\u003c\/code\u003e, \u003ccode\u003eRELEVANCE_KEYWORDS\u003c\/code\u003e, \u003ccode\u003eDIGEST_LOOKBACK_DAYS\u003c\/code\u003e, \u003ccode\u003eSTALE_DRAFT_REMINDER_DAYS\u003c\/code\u003e) and create your Google Sheets document to begin.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45978860191923,"sku":"N8N-19378","price":21.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/WdKB2HoWa3CrsvfgPJair_rbIIy4Pp.png?v=1788858134","url":"https:\/\/buyflowscripts.com\/products\/weekly-security-rss-digest-automation-with-google-sheets-email","provider":"N8N Commerce","version":"1.0","type":"link"}