{"product_id":"n8n-regulatory-update-digest-google-sheets-openai-email","title":"n8n Regulatory Update Digest: Google Sheets + OpenAI Email","description":"\u003ch3\u003eGet a clean regulatory digest every three days—automatically\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n Regulatory Update Digest\u003c\/strong\u003e workflow scans your chosen authority websites, extracts \u003cstrong\u003erecent regulatory notices\u003c\/strong\u003e using \u003cstrong\u003eOpenAI\u003c\/strong\u003e (with a web-scraper sub-workflow) and \u003cstrong\u003ePerplexity\u003c\/strong\u003e, logs deduplicated updates to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and emails an \u003cstrong\u003eHTML digest\u003c\/strong\u003e to recipients stored in a \u003cstrong\u003eMicrosoft Excel\u003c\/strong\u003e workbook—complete with unsubscribe handling.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns every three days\u003c\/strong\u003e and reads an authority website list from \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, including \u003cem\u003einclude\/exclude topics\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003eFor each website, uses \u003cstrong\u003eOpenAI\u003c\/strong\u003e to extract regulatory updates by combining results from:\n    \u003cul\u003e\n      \u003cli\u003ea \u003cstrong\u003eweb-scraper sub-workflow\u003c\/strong\u003e, and\u003c\/li\u003e\n      \u003cli\u003ea \u003cstrong\u003ePerplexity\u003c\/strong\u003e domain-filtered search.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters notices to the last three days\u003c\/strong\u003e; if nothing recent remains, the workflow skips that site.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrites updates to a Google Sheets “updates” spreadsheet\u003c\/strong\u003e, deduplicating by \u003cstrong\u003etitle\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds one HTML digest\u003c\/strong\u003e and sends it to recipients pulled from \u003cstrong\u003eall worksheets\u003c\/strong\u003e in a Microsoft Excel workbook, excluding rows marked as not interested\/unavailable.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends in BCC batches of 20\u003c\/strong\u003e per email, grouped by category, using \u003cstrong\u003eSMTP\u003c\/strong\u003e with a short pause between sends.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMonitors an IMAP inbox for replies\u003c\/strong\u003e containing “\u003cstrong\u003eNot Interested\u003c\/strong\u003e” and updates the matching recipient row in Excel to mark them unsubscribed.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators and compliance teams who need \u003cstrong\u003enear-real-time regulatory awareness\u003c\/strong\u003e without manual web research.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers maintaining a reliable \u003cstrong\u003en8n regulatory monitoring pipeline\u003c\/strong\u003e across multiple authority sources.\u003c\/li\u003e\n  \u003cli\u003eTeams who want an auditable feed: each update is stored in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e with deduplication.\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 OpenAI, Perplexity, Google Sheets, Microsoft Excel, SMTP, IMAP.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow nodes:\u003c\/strong\u003e if, code, wait, filter, split out, aggregate.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup:\u003c\/strong\u003e add credentials for all services and update the Google Sheets document IDs to point to your authority list.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45899945050291,"sku":"N8N-18722","price":77.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/osoJ-KCoxjku9wSUQTrfF_AjS5j9hV.png?v=1787734978","url":"https:\/\/buyflowscripts.com\/products\/n8n-regulatory-update-digest-google-sheets-openai-email","provider":"N8N Commerce","version":"1.0","type":"link"}