{"product_id":"notion-weekly-sunday-digest-email-via-smtp-n8n-workflow","title":"Notion Weekly Sunday Digest Email via SMTP (n8n Workflow)","description":"\u003ch3\u003eTurn your Notion data into a weekly Sunday email digest—automatically\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n workflow\u003c\/strong\u003e generates a plain-text \u003cstrong\u003eNotion Weekly Sunday Digest Email\u003c\/strong\u003e by pulling overdue invoices, active projects, pipeline deals needing attention, and upcoming draft\/scheduled content—then sending everything to your inbox via \u003cstrong\u003eSMTP\u003c\/strong\u003e every Sunday.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cp\u003eDesigned to keep SaaS operators and automation engineers on top of key work items, the workflow:\u003c\/p\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns every Sunday at 09:00\u003c\/strong\u003e (or via a manual test trigger).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFinance (Invoices):\u003c\/strong\u003e reads your Notion Finance database and selects pages where \u003cem\u003eStatus\u003c\/em\u003e equals \u003cstrong\u003eOverdue\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eProjects:\u003c\/strong\u003e reads your Notion Projects database and selects pages where \u003cem\u003eStatus\u003c\/em\u003e equals \u003cstrong\u003eActive\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePipeline deals:\u003c\/strong\u003e reads your Notion Pipeline database and keeps deals in \u003cstrong\u003eContacted\u003c\/strong\u003e, \u003cstrong\u003eProposal\u003c\/strong\u003e, or \u003cstrong\u003eNegotiation\u003c\/strong\u003e where \u003cem\u003eLast touched\u003c\/em\u003e is missing or older than a configured threshold.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eContent:\u003c\/strong\u003e reads your Notion Content database and keeps items where \u003cem\u003eStatus\u003c\/em\u003e is \u003cstrong\u003eDraft\u003c\/strong\u003e or \u003cstrong\u003eScheduled\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmails results:\u003c\/strong\u003e builds a plain-text email with counts and bullet lists for each section and sends it using the \u003cstrong\u003en8n Email (SMTP) node\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eWeekly end-of-week review: quickly see \u003cstrong\u003eoverdue invoices\u003c\/strong\u003e and \u003cstrong\u003eactive projects\u003c\/strong\u003e in one email.\u003c\/li\u003e\n  \u003cli\u003ePipeline hygiene: identify deals where \u003cstrong\u003eLast touched\u003c\/strong\u003e is missing\/too old and prioritize outreach.\u003c\/li\u003e\n  \u003cli\u003eContent planning: monitor which \u003cstrong\u003eDraft\u003c\/strong\u003e or \u003cstrong\u003eScheduled\u003c\/strong\u003e items need attention.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTriggers\/nodes:\u003c\/strong\u003e manual trigger, set, code, notion, sticky note, Email Send (SMTP).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup:\u003c\/strong\u003e create a Notion integration, connect and share all four databases, then paste the four Notion database IDs and recipient email into workflow settings.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCompatibility:\u003c\/strong\u003e ensure your Notion property names match expected fields (e.g., \u003cem\u003eName, Status, Amount, Stage, Last touched, Deal name, Title\u003c\/em\u003e) or update the filters\/digest logic.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46228898676915,"sku":"N8N-20951","price":3.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/6_eH_g9saUGyega_oYXGq_N25LfPhM.png?v=1792056106","url":"https:\/\/buyflowscripts.com\/products\/notion-weekly-sunday-digest-email-via-smtp-n8n-workflow","provider":"N8N Commerce","version":"1.0","type":"link"}