Send a weekly Sunday digest email from Notion via SMTP
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 9 nodes and runs on a schedule (cron 0 9 * * 0) (plus 1 other trigger). Along the way it connects Notion.
How it runs
Trigger: On a schedule (cron 0 9 * * 0) (plus 1 other trigger).
- Set your settings (Edit Fields (Set)): sets 6 fields: NOTIFY_EMAIL, FINANCE_DB_ID, PROJECTS_DB_ID…
- Get overdue invoices from Notion (Notion): get many (database page)
- Get active projects from Notion (Notion): get many (database page)
- Get sales pipeline from Notion (Notion): get many (database page)
- Get content plan from Notion (Notion): get many (database page)
- Build Sunday digest text (Code): runs custom JavaScript code
- Send Sunday digest email (Send Email): sends an email over SMTP
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (6)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - Notion
n8n-nodes-base.notion - Code
n8n-nodes-base.code - Send Email
n8n-nodes-base.emailSend
From the author
Quick Overview This workflow runs every Sunday and pulls invoices, projects, pipeline deals, and content items from four Notion databases, then compiles them into a single plain-text digest and sends it to your email address via SMTP. How it works 1. Runs…