Automated Deadline Tracker using Notion and Email Reminders - n8n Workflow

Students and teachers who manage assignment deadlines in Notion.
Automation enthusiasts looking for practical, real-world n8n templates.
Users who need a scheduled, reliable assignment tracking system.
Organizations seeking to improve timely task completion using a centralized database.

Missing deadlines is a common challenge in academic and project settings. This specialized n8n workflow solves this by establishing a robust, automated system that proactively monitors upcoming assignments recorded in a Notion database. By setting a daily schedule using the n8n trigger node, the system ensures that staff or students receive timely, personalized email notifications for items due within the next three days. This not only reduces manual checking but also leverages the power of n8n to ensure zero missed deadlines, providing a crucial layer of organization atop your existing project management tools.

The entire process is initiated by the 'Set Schedule For Trigger' n8n trigger. This n8n node is configured to run every weekday at 9 AM.

1. Data Retrieval (Notion): The 'Notion - Get Assignments' n8n node queries the specified Notion database. Although the filter details are not explicitly shown in the parameters, the context implies it retrieves assignments due shortly (e.g., within 3 days).


2. Conditional Check: The 'IF Assignments Exist' n8n node checks the length of the results array. If zero assignments are found, the n8n workflow halts gracefully via the 'No Assignments' node.


3. Item Splitting: If assignments are found, the 'SplitOutItems itemList' n8n node expands the list, ensuring that subsequent steps process each assignment individually.


4. Email Dispatch: For every individual assignment item, the 'Send Email Reminder' n8n node generates and sends a personalized email. The email uses dynamic data points retrieved from the Notion entry, such as the assignment name, due date, and the designated recipient's email address. This reliable n8n workflow ensures everyone is kept informed.

To deploy this assignment reminder n8n workflow, follow these steps:

1. Import the Workflow: Copy the provided JSON and import it directly into your n8n instance using the 'New' > 'Import from JSON' option.


2. Notion Setup: Locate the 'Notion - Get Assignments' n8n node. You must replace the placeholder databaseId with the actual ID of your Notion assignment tracking database. Ensure you have configured a Notion credential with the necessary permissions for that database.


3. SMTP Configuration: Set up the required SMTP credentials on the 'Send Email Reminder' n8n node. Update the From Email field to your desired sending address.


4. Customize Data Mapping: Verify that the dynamic expressions used for 'Assignment Name', 'Due Date', and 'To Email' in the email node correctly match the property names (schema) of your Notion database.


5. Activate: Once credentials and parameters are set, activate the n8n workflow to allow the scheduled n8n trigger to run.

Set Schedule For Trigger (n8n Trigger): Initiates the entire automation. Key Configuration: Set to run daily (every weekday) at 9 AM.
Notion - Get Assignments: Core integration n8n node. Function: Retrieves a list of records (assignments) from the configured Notion database. Configuration: Requires a valid Notion Database ID and Notion API credentials.
IF Assignments Exist (n8n Node): Logic Control. Function: Checks if the list returned from Notion contains any items. If the count is greater than zero, the flow continues down the 'True' path.
SplitOutItems itemList: Data manipulation n8n node. Function: Takes the array of assignments and splits it into separate executions, allowing the subsequent email node to process and send a unique email for each assignment.

• Send Email Reminder: Communication n8n node. Function: Sends personalized emails containing assignment name and due date. Key Configuration: Uses dynamic expressions to pull recipient email and assignment details from the current item's data structure.