Weekly Security RSS Digest Automation with Google Sheets & Email

Weekly Security RSS Digest Automation—drafts, logs, and emails your review

This 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.

What this workflow does

• Weekly Monday 8:00am run: Checks whether SECURITY_DIGEST_FEED_URLS contains one or more RSS feed URLs.
• RSS collection & filtering: Fetches items from each configured feed, then filters to recent entries within DIGEST_LOOKBACK_DAYS that match RELEVANCE_KEYWORDS.
• Digest drafting: Compiles all filtered items into a single digest draft, assigns a unique digest ID and timestamp, and includes a “no relevant items found” message when nothing matches.
• Google Sheets logging: Appends every digest draft (or setup-needed notice) to your Google Sheets log.
• Reviewer email: Sends an HTML and text review-request email via SMTP.
• Setup-needed path: If no feeds are configured, it creates a setup-needed notice with an ID, logs it to Google Sheets, and emails the reviewer.
• Weekly Thursday 9:00am reminder check: Reads the Sheets log and finds pending drafts older than STALE_DRAFT_REMINDER_DAYS. If any are stale, it emails a single reminder listing all stale drafts; otherwise it does nothing.

Use cases

• SaaS security teams who want a consistent weekly security RSS digest for review.
• Automation engineers standardizing compliance monitoring with n8n, RSS, and Google Sheets.
• Operations leaders needing a simple review workflow with automatic stale reminders.

Technical details

• n8n nodes/logic: if, code, no op, rss feed read, and email send (SMTP).
• Integrations: RSS feeds (via SECURITY_DIGEST_FEED_URLS) and Google Sheets for audit/logging.

Set the required n8n variables (SECURITY_DIGEST_FEED_URLS, RELEVANCE_KEYWORDS, DIGEST_LOOKBACK_DAYS, STALE_DRAFT_REMINDER_DAYS) and create your Google Sheets document to begin.