The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"nodes": [
{
"id": "dac02623-ee83-444b-b039-fd310dee3260",
"name": "When clicking \u2018Test workflow\u2019",
"type": "n8n-nodes-base.manualTrigger",
"position": [
700,
1000
],
"parameters": {},
"typeVersion": 1
},
{
"id": "7268d9c0-44ae-4226-9e5f-f3b19e3fbfa1",
"name": "Notion",
"type": "n8n-nodes-base.notion",
"position": [
1360,
980
],
"parameters": {
"options": {},
"resource": "databasePage",
"operation": "getAll",
"databaseId": {
"__rl": true,
"mode": "list",
"value": "b1e11f75-06df-42b4-8dd9-557ba937978d",
"cachedResultUrl": "https://www.notion.so/b1e11f7506df42b48dd9557ba937978d",
"cachedResultName": "Tasks"
},
"filterType": "manual"
},
"credentials": {
"notionApi": {
"name": "<your credential>"
}
},
"typeVersion": 2.2
},
{
"id": "607752ef-ac76-4a07-a3e7-39be7d5770e7",
"name": "Sort by closest deadline",
"type": "n8n-nodes-base.sort",
"position": [
1760,
880
],
"parameters": {
"options": {},
"sortFieldsUi": {
"sortField": [
{
"fieldName": "property_deadline.start"
}
]
}
},
"typeVersion": 1
},
{
"id": "81c6ded2-7766-4351-b597-27794b595283",
"name": "Filter for deadline",
"type": "n8n-nodes-base.filter",
"position": [
1600,
880
],
"parameters": {
"options": {},
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "179eecfc-7eea-46b9-a971-78824e5774dc",
"operator": {
"type": "string",
"operation": "exists",
"singleValue": true
},
"leftValue": "={{ $json.property_deadline.start }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.1
},
{
"id": "21ecbd8d-7a2f-4a0a-8d99-3365c88a187b",
"name": "Send Email",
"type": "n8n-nodes-base.emailSend",
"position": [
4100,
900
],
"parameters": {
"html": "={{ $json.html }}",
"options": {},
"subject": "Weekly Update about Notion Tasks",
"toEmail": "={{ $('Set Workflow vars').item.json.your_email }}",
"fromEmail": "n8n@unitize.de"
},
"credentials": {
"smtp": {
"name": "<your credential>"
}
},
"typeVersion": 2.1
},
{
"id": "8379f4e4-cab6-46cd-9ba0-e6bf78076de5",
"name": "HTML",
"type": "n8n-nodes-base.html",
"position": [
3720,
900
],
"parameters": {
"html": "<!DOCTYPE html>\n\n<html>\n<head>\n <meta charset=\"UTF-8\" />\n <title>Weekly Update about Notion Tasks</title>\n <meta name=\"color-scheme\" content=\"only\">\n <style>\n body {font-family: 'Courier'; color: #15124a; background-color: #ffffff;padding:20px;}\n .button {background-color: #126bf3; padding: 10px 15px; border-radius: 5px; text-decoration: none; color: white}\n a {text-decoration: none; color: #126bf3}\n h3 {margin-top: 0px}\n .task {background-color: #f0f0f0; padding: 20px; border-radius: 5px;}\n p:last-child {margin-bottom: 0px;}\n </style>\n</head>\n<body>\n <div class=\"container\">\n <img width=\"40\" src=\"{{ $('Set Workflow vars').item.json.logo_path }}\" />\n <h1>Weekly Update about Notion Tasks</h1>\n <p><a class=\"button\" href=\"{{ $('Set Workflow vars').item.json.notion_database_url }}\">To the Task Board in Notion</a></p>\n <br>\n {{ $json.html_groups.pluck('html') }}\n </div>\n</body>\n</html>"
},
"typeVersion": 1.2
},
{
"id": "c86a8391-90ed-450a-b142-85ff62d84ab8",
"name": "Aggregate due to tasks",
"type": "n8n-nodes-base.aggregate",
"position": [
2700,
1040
],
"parameters": {
"options": {},
"aggregate": "aggregateAllItemData",
"destinationFieldName": "due_to"
},
"typeVersion": 1
},
{
"id": "07506629-4244-4270-aecc-87b0237c65e7",
"name": "Aggregate overdue tasks",
"type": "n8n-nodes-base.aggregate",
"position": [
2700,
760
],
"parameters": {
"options": {},
"aggregate": "aggregateAllItemData",
"destinationFieldName": "overdue"
},
"typeVersion": 1
},
{
"id": "93d4f3be-8081-41d9-bd59-5a7a0439c27b",
"name": "Pushover",
"type": "n8n-nodes-base.pushover",
"position": [
4100,
1100
],
"parameters": {
"message": "You received a weekly update about your Notion Tasks. Check your mails!",
"userKey": "={{ $('Set Workflow vars').item.json.pushover_user_key }}",
"priority": 1,
"additionalFields": {}
},
"credentials": {
"pushoverApi": {
"name": "<your credential>"
}
},
"typeVersion": 1
},
{
"id": "112aa538-1497-4a53-85ff-b04504896b81",
"name": "Schedule Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
700,
780
],
"parameters": {
"rule": {
"interval": [
{
"field": "weeks",
"triggerAtDay": [
1
],
"triggerAtHour": 9
}
]
}
},
"typeVersion": 1.2
},
{
"id": "1ec9608a-9a06-4140-a6e0-2e38b4a8c201",
"name": "If deadline is overdue",
"type": "n8n-nodes-base.if",
"position": [
2460,
900
],
"parameters": {
"options": {},
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "e65c0597-d067-423a-8496-35e91a8ddf1b",
"operator": {
"type": "dateTime",
"operation": "beforeOrEquals"
},
"leftValue": "={{ $json.property_deadline.start.toDateTime() }}",
"rightValue": "={{ $now }}"
}
]
}
},
"typeVersion": 2.1
},
{
"id": "2a25952d-7149-4b42-b520-497997d2838c",
"name": "Merge",
"type": "n8n-nodes-base.merge",
"position": [
2220,
900
],
"parameters": {
"mode": "combine",
"options": {},
"combineBy": "combineByPosition"
},
"typeVersion": 3
},
{
"id": "a80b5658-b83d-45e7-ade3-6a828f26a356",
"name": "HTML for Task",
"type": "n8n-nodes-base.html",
"position": [
2000,
1060
],
"parameters": {
"html": "<div class=\"task\">\n <a href=\"{{ $json.url }}\">\n <h3>{{ $json.name }}\"</h3>\n </a>\n <p>\n <strong>Deadline: </strong>{{ $json.property_deadline.start.toDateTime().format('dd.MM.yyyy') }}\n <br>\n <strong>Prio: </strong>{{ $json.property_prio }}\n <br>\n <strong>Status: </strong>{{ $json.property_status }}\n <br>\n <strong>Tags: </strong>{{ $json.property_tags }}\n </p>\n</div>"
},
"typeVersion": 1.2
},
{
"id": "8589e878-249d-43a0-b523-994108b3471b",
"name": "HTML due to List",
"type": "n8n-nodes-base.html",
"position": [
2920,
1040
],
"parameters": {
"html": "<h2>Tasks with an <u>upcoming</u> deadline</h2>\n{{ $json.due_to.pluck('html') }}"
},
"typeVersion": 1.2
},
{
"id": "c3eccab0-56f8-4038-8526-f2f51a19fb59",
"name": "HTML overdue List",
"type": "n8n-nodes-base.html",
"position": [
2920,
760
],
"parameters": {
"html": "<h2>Tasks which are already <u>overdue</u></h2>\n{{ $if($json.overdue.length > 0, $json.overdue.pluck('html'), 'No overdue tasks. Great!') }}"
},
"typeVersion": 1.2
},
{
"id": "054aa055-6f71-4ecb-80fe-69e5b95f6390",
"name": "Aggregate",
"type": "n8n-nodes-base.aggregate",
"position": [
3440,
900
],
"parameters": {
"options": {},
"aggregate": "aggregateAllItemData",
"destinationFieldName": "html_groups"
},
"typeVersion": 1
},
{
"id": "10a799fb-66f3-4fe3-b7b8-01d3a93047d2",
"name": "Merge groups",
"type": "n8n-nodes-base.merge",
"position": [
3220,
900
],
"parameters": {},
"typeVersion": 3
},
{
"id": "acde5a16-bdd1-4fb6-a986-14ae0b1b1240",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
620,
640
],
"parameters": {
"color": 4,
"width": 265.6985239367243,
"height": 702.0052321200026,
"content": "## Triggers\nCurrent schedule is every monday at 9 am."
},
"typeVersion": 1
},
{
"id": "7766fa25-2486-4eb5-a3d6-23ec2472be94",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
1240,
640
],
"parameters": {
"width": 648.1928627806343,
"height": 710.0046767294216,
"content": "## Fetch, filter and sort notion tasks\nCurrently tasks are filtered by having a deadline and sorted by this"
},
"typeVersion": 1
},
{
"id": "5a44f536-5af9-40dd-a9ae-9d56e4540971",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1920,
640
],
"parameters": {
"width": 442.45022302855995,
"height": 707.700156943336,
"content": "## Generate HTML template per task\nGenerate a template for each task. It displays the headline and some prperties.\nYou can adjust the template here to show more or less information about each task."
},
"typeVersion": 1
},
{
"id": "765f25ad-3dfa-4a48-9c07-07c7fc0049b6",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
2400,
640
],
"parameters": {
"width": 1185.3702378922917,
"height": 707.7001569433354,
"content": "## Create groups of tasks to \"overdue\" and \"due to\"\nThis is used to group the tasks and display them accordingly in the final html email template."
},
"typeVersion": 1
},
{
"id": "5fb2c5d9-fba9-463c-9574-38146d14e272",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
3620,
640
],
"parameters": {
"width": 314.11124235866913,
"height": 705.8925656662948,
"content": "## Create html email template\nHere the whole html email template is set up.\nStyles are applied and some sugar around list of tasks are shown.\nYou may change this to your design and even replace the logo."
},
"typeVersion": 1
},
{
"id": "891e126b-1a34-489b-8a3d-fa3a56308153",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
3980,
640
],
"parameters": {
"color": 4,
"width": 355.68584173060526,
"height": 704.0849743892543,
"content": "## Send email and push notification\nIn the Pushover node you need to place you User Key to receive push notifications.\nUse the Pushover docs to read more about how to setup this service."
},
"typeVersion": 1
},
{
"id": "6cd611da-f3da-4da1-90ae-e5e04a91f915",
"name": "Sticky Note6",
"type": "n8n-nodes-base.stickyNote",
"position": [
620,
400
],
"parameters": {
"color": 6,
"width": 539.3442720010472,
"height": 199.46339277184228,
"content": "## Dependencies\n- You need to have access to your notion page/database\n- You need to create a Pushover account in order to receive push notifications via this service"
},
"typeVersion": 1
},
{
"id": "8da5e4b3-ee1a-4c62-aeec-40d85fb9754e",
"name": "Sticky Note7",
"type": "n8n-nodes-base.stickyNote",
"position": [
920,
640
],
"parameters": {
"width": 284.11715106246396,
"height": 706.9018085580076,
"content": "## Set workflow variables\nAdjust this node to your needs!"
},
"typeVersion": 1
},
{
"id": "4759edd5-edae-4d4c-8cc7-55c8cd8336ca",
"name": "Set Workflow vars",
"type": "n8n-nodes-base.set",
"position": [
1000,
880
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "976aac71-63c6-48a4-a965-8112ae3480bf",
"name": "logo_path",
"type": "string",
"value": ""
},
{
"id": "d9ec1fff-56ff-4c3e-befd-99520b78200e",
"name": "pushover_user_key",
"type": "string",
"value": ""
},
{
"id": "8271abe0-b9c7-4102-b1a2-37181dcb4ea6",
"name": "notion_database_url",
"type": "string",
"value": ""
},
{
"id": "ed7c4c03-f8e2-46fa-ac3b-ccabbeab24fa",
"name": "your_email",
"type": "string",
"value": ""
}
]
}
},
"typeVersion": 3.4
},
{
"id": "25f16b5e-7500-4b51-ac8e-e7d8b3b205be",
"name": "Sticky Note8",
"type": "n8n-nodes-base.stickyNote",
"position": [
1260,
740
],
"parameters": {
"color": 3,
"width": 296.4350404695249,
"height": 463.2108881217612,
"content": "## Adjustment needed\nIn order to not receive \"Done\" or \"Closed\" items from your notion database you need to add some filters in this Notion node.\n\nE.g. you could add \"Status\" is not equal to \"Closed\", to not get closed items."
},
"typeVersion": 1
}
],
"connections": {
"HTML": {
"main": [
[
{
"node": "Send Email",
"type": "main",
"index": 0
},
{
"node": "Pushover",
"type": "main",
"index": 0
}
]
]
},
"Merge": {
"main": [
[
{
"node": "If deadline is overdue",
"type": "main",
"index": 0
}
]
]
},
"Notion": {
"main": [
[
{
"node": "Filter for deadline",
"type": "main",
"index": 0
}
]
]
},
"Aggregate": {
"main": [
[
{
"node": "HTML",
"type": "main",
"index": 0
}
]
]
},
"Merge groups": {
"main": [
[
{
"node": "Aggregate",
"type": "main",
"index": 0
}
]
]
},
"HTML for Task": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 1
}
]
]
},
"HTML due to List": {
"main": [
[
{
"node": "Merge groups",
"type": "main",
"index": 1
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Set Workflow vars",
"type": "main",
"index": 0
}
]
]
},
"HTML overdue List": {
"main": [
[
{
"node": "Merge groups",
"type": "main",
"index": 0
}
]
]
},
"Set Workflow vars": {
"main": [
[
{
"node": "Notion",
"type": "main",
"index": 0
}
]
]
},
"Filter for deadline": {
"main": [
[
{
"node": "Sort by closest deadline",
"type": "main",
"index": 0
}
]
]
},
"Aggregate due to tasks": {
"main": [
[
{
"node": "HTML due to List",
"type": "main",
"index": 0
}
]
]
},
"If deadline is overdue": {
"main": [
[
{
"node": "Aggregate overdue tasks",
"type": "main",
"index": 0
}
],
[
{
"node": "Aggregate due to tasks",
"type": "main",
"index": 0
}
]
]
},
"Aggregate overdue tasks": {
"main": [
[
{
"node": "HTML overdue List",
"type": "main",
"index": 0
}
]
]
},
"Sort by closest deadline": {
"main": [
[
{
"node": "HTML for Task",
"type": "main",
"index": 0
},
{
"node": "Merge",
"type": "main",
"index": 0
}
]
]
},
"When clicking \u2018Test workflow\u2019": {
"main": [
[
{
"node": "Set Workflow vars",
"type": "main",
"index": 0
}
]
]
}
}
}
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
notionApipushoverApismtp
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
How this works
This workflow streamlines task management by automatically scanning your Notion database for items approaching deadlines, sorting and filtering them to highlight urgent priorities, and notifying you via email or Pushover alerts. It's ideal for busy professionals or teams relying on Notion to track projects, ensuring nothing slips through the cracks without constant manual checks. The key step involves aggregating overdue and due tasks into a clear summary, delivered right to your inbox for quick action.
Use this when you need recurring reminders for time-sensitive Notion entries, such as weekly deadline reviews, to maintain productivity without daily logins. Avoid it for one-off tasks or if your database lacks consistent deadline fields, as it relies on structured data. Common variations include adjusting the filter for custom time windows or integrating additional channels like Slack for team notifications.
About this workflow
Filter Schedule. Uses manualTrigger, notion, sort, emailSend. Event-driven trigger; 27 nodes.
Source: https://github.com/Zie619/n8n-workflows — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
Everyone organizing him/herself by using a notion database for tasks but losing track on some important tasks having a deadline. The weekly reminder helps you to not forget about your notion tasks. Th
Notion, Email Send, Pushover
Code Schedule. Uses httpRequest, splitInBatches, noOp, notion. Scheduled trigger; 27 nodes.
HTTP Request, Notion
Wait Splitout. Uses manualTrigger, httpRequest, splitInBatches, n8n. Event-driven trigger; 23 nodes.
HTTP Request, n8n, XML +1
You’ve onboarded your client with elegance. Now, keep the relationship warm — and get glowing testimonials — without manual follow-up.
Notion, Email Send
Log errors and avoid sending too many emails. Uses errorTrigger, postgres, stickyNote, emailSend. Event-driven trigger; 16 nodes.
Error Trigger, Postgres, Email Send +2