{"product_id":"n8n-regulatory-rss-digest-to-google-sheets-email","title":"n8n Regulatory RSS Digest to Google Sheets \u0026 Email","description":"\u003ch3\u003eTurn regulatory RSS updates into review-ready digests—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically collects new regulatory and bar association items from RSS feeds, organizes them by practice area, logs each draft to Google Sheets, and emails a reviewer for approval—then sends a separate weekly reminder if any drafts remain pending too long.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns Mondays at 8:00am\u003c\/strong\u003e and checks whether the \u003ccode\u003eAGENCY_BAR_FEED_URLS\u003c\/code\u003e variable contains at least one RSS feed URL.\u003c\/li\u003e\n  \u003cli\u003eIf feeds are configured, it \u003cstrong\u003ereads each RSS feed\u003c\/strong\u003e and collects recent items within the \u003ccode\u003eDIGEST_LOOKBACK_DAYS\u003c\/code\u003e window.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTags items by practice area\u003c\/strong\u003e using the \u003ccode\u003ePRACTICE_AREA_KEYWORDS\u003c\/code\u003e map, dropping any items that match no practice area and grouping the digest accordingly.\u003c\/li\u003e\n  \u003cli\u003eIf no feeds are configured, it still creates a \u003cstrong\u003e“setup required”\u003c\/strong\u003e digest notice so there’s always a logged draft and review email.\u003c\/li\u003e\n  \u003cli\u003eCreates a unique \u003cstrong\u003edigest ID\u003c\/strong\u003e, appends a draft record with \u003ccode\u003estatus = pending_review\u003c\/code\u003e to the Google Sheet tab named \u003cstrong\u003e“Regulatory Digest Drafts”\u003c\/strong\u003e, and emails the draft to the content reviewer via \u003cstrong\u003eSMTP\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns Thursdays at 9:00am\u003c\/strong\u003e to read the same Google Sheets log and filter drafts where \u003ccode\u003estatus = pending_review\u003c\/code\u003e and the draft is older than \u003ccode\u003eSTALE_DRAFT_REMINDER_DAYS\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003eIf stale drafts exist, it sends a \u003cstrong\u003ereminder email\u003c\/strong\u003e via SMTP listing the pending digest IDs; otherwise, it skips sending.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eLegal ops teams needing weekly regulatory updates grouped by practice area.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building a reliable content intake pipeline from RSS sources.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators managing editorial review workflows with a “no stale drafts” reminder process.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduling:\u003c\/strong\u003e Monday 8:00am and Thursday 9:00am.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRSS feed intake:\u003c\/strong\u003e RSS Feed Read.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogic \u0026amp; filtering:\u003c\/strong\u003e \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, and \u003ccode\u003eno op\u003c\/code\u003e steps to handle configured vs. missing feeds and practice-area tagging.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogging:\u003c\/strong\u003e Google Sheets (write new drafts to “Regulatory Digest Drafts”).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmail delivery:\u003c\/strong\u003e Email Send via SMTP (initial digest + stale-draft reminders).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRecommended config:\u003c\/strong\u003e \u003ccode\u003eREGULATORY_LOG_SHEET_ID\u003c\/code\u003e pointing to the spreadsheet with matching columns, plus the feed and keyword variables above.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46001850319027,"sku":"N8N-19470","price":36.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/HrMrDXOWU2hVYfViwz7J0_eSPHdOCE.png?v=1789117614","url":"https:\/\/buyflowscripts.com\/products\/n8n-regulatory-rss-digest-to-google-sheets-email","provider":"N8N Commerce","version":"1.0","type":"link"}