David This workflow corresponds to n8n.io template #2409 — we link there as the canonical source.
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": "user@example.com"
},
"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
About this workflow
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. The workflow fetches all your notion tasks from a desired database but the closed…
Source: https://n8n.io/workflows/2409/ — 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.
You’ve onboarded your client with elegance. Now, keep the relationship warm — and get glowing testimonials — without manual follow-up.
Notion, Email Send
Stop scrambling before birthdays, anniversaries, or family gatherings. This workflow turns a simple Google Calendar event into a 7-day prep plan — complete with shopping lists, tasks, and reminders —
Google Calendar Trigger, Hub Gpt, Notion +2
Automate sales call analysis and store structured insights in Notion with AI-powered intelligence.
Execute Workflow Trigger, Notion, HTTP Request
A warm, reliable onboarding system for small businesses and studios. Captures a form submission via webhook, creates a Client record in Notion, sends a concierge-style welcome email (with scheduler +
Notion, Email Send, Telegram +4
Inspired by Alex Kim's workflow, this version adds the ability to keep multiple versions of the same workflow on the destination instance. Each copied workflow’s name is prefixed with the date (), ena
n8n, Notion