n8n

How to Automate Notion Task Email Updates?

Get a weekly email that lists Notion tasks by what is overdue and what is due soon. A short push alert lets you know the email is sent. Great for teams and managers who want a clear view of deadlines without manual work.

Every Monday at 9 am, the schedule runs. The flow pulls pages from a Notion database, keeps only items with a deadline, and sorts them by the closest date. It creates simple HTML for each task, checks if the due date is late, and groups items into overdue and upcoming. The groups are merged into a styled email, sent by your SMTP server, and a Pushover message confirms delivery.

You need access to your Notion database, an SMTP account, and a Pushover user key. Set your email and Pushover key in the Set Workflow vars node, and point the Notion node to your Tasks database. Many teams use it for weekly standups, manager updates, or personal planning. Expect fewer missed dates and far less time spent writing status messages.

What are the key features?

  • Weekly schedule at Monday 9 am plus a manual test trigger
  • Pulls all pages from a Notion database and lets you add filters
  • Keeps only tasks with a deadline and sorts by the closest date
  • Builds an HTML block per task with a link and a formatted due date
  • Checks each task date to split items into overdue and due soon
  • Aggregates and merges groups into a single clean email layout
  • Sends the summary through your SMTP server with your subject and sender
  • Sends a Pushover notification after the email goes out

What are the benefits?

  • Reduce manual weekly status work from 60 minutes to 5 minutes
  • Automate 100 percent of recurring task digest emails
  • Cut missed deadlines by 30 percent with clear overdue and upcoming groups
  • Connect Notion, email, and Pushover in one flow
  • Scale to hundreds of tasks with no extra effort

How do you set it up?

  1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
  2. You'll need accounts with Notion, Pushover and SMTP. See the Tools Required section above for links to create accounts with these services.
  3. Open the Set Workflow vars node and enter your email address and your Pushover user key. Save the node.
  4. Double click the Notion node, select the Tasks database, and confirm the databaseId points to your Notion table. If needed, paste the database URL to select it.
  5. In the Notion node, add filters to exclude finished items, for example Status is not Closed, so done tasks do not appear in the email.
  6. For Notion credentials in n8n Cloud, double click the Notion node, choose Credential to connect with, click Create new credential, then follow the on screen steps. Make sure your Notion integration has access to the database by sharing it in Notion.
  7. Double click the Send Email node and set your SMTP credential. If you do not have one, click Create new credential, enter your SMTP host, port, username, and password. Update the from address and subject if you want.
  8. Double click the Pushover node and select or create a Pushover credential. Enter your user key in Set Workflow vars so the push goes to your device.
  9. Check the field names used in the HTML for Task node. Your deadline property in Notion should match property_deadline.start or adjust the field path to match your database.
  10. Confirm the schedule in the Schedule Trigger node is set to Monday at 9 am in your time zone. Adjust the time if your team needs a different slot.
  11. Click Test workflow to run it once. Verify the email arrives, the HTML shows overdue and upcoming lists, and the Pushover message appears on your phone.
  12. If tasks are missing, review the Notion filters and the sort settings. If the email does not arrive, check SMTP credentials and your spam folder. If no push arrives, confirm the Pushover user key and priority settings.

Tools Required

$24 / mo or $20 / mo billed annually to use n8n in the cloud. However, the local or self-hosted n8n Community Edition is free.

Notion

Sign up

Free plan: $0 per member / mo (Public API included)

Pushover

Sign up

API free: up to 10,000 messages / mo per app; recipient device license $4.99 one‑time per platform (iOS/Android/Desktop). Teams optional at $5/user / mo.

Similar Templates

Join Futurise to access 1,200+ automation templates

Get instant access to ready-made automation workflows for n8n, Make.com, AI agents, and more. Download, customise, and deploy in minutes.