Intermediate
How to set up recurring task automation on Notion
Quick Answer
Set up recurring task automation in Notion by creating a database with date properties, then using Notion's built-in automation features or templates with formulas. You can also integrate with external tools like Zapier or use recurring template buttons for automatic task generation.
Prerequisites
- Active Notion workspace
- Basic understanding of Notion databases
- Notion Pro plan for advanced automations
- Familiarity with database properties
1
Create a Tasks Database
Open your Notion workspace and create a new page. Add a Database block by typing
/database and selecting Table - Full page. Name your database "Recurring Tasks" and add these properties: Task Name (Title), Due Date (Date), Status (Select), Recurrence (Select), and Next Due Date (Formula).Tip
Set up your Status property with options like To Do, In Progress, and Done for better task tracking.
2
Configure Recurrence Property Options
Click on the Recurrence property header and select Edit property. Add these options: Daily, Weekly, Monthly, Yearly, and None. Set different colors for each option to make them easily distinguishable. This will help you categorize how often each task should repeat.
Tip
You can add custom recurrence options like "Bi-weekly" or "Quarterly" based on your specific needs.
3
Create Next Due Date Formula
Click on the Next Due Date property and select Formula. Enter this formula:
if(prop("Recurrence") == "Daily", dateAdd(prop("Due Date"), 1, "days"), if(prop("Recurrence") == "Weekly", dateAdd(prop("Due Date"), 1, "weeks"), if(prop("Recurrence") == "Monthly", dateAdd(prop("Due Date"), 1, "months"), if(prop("Recurrence") == "Yearly", dateAdd(prop("Due Date"), 1, "years"), prop("Due Date")))))Tip
Test the formula with a sample task to ensure it calculates the next due date correctly before adding all your tasks.
4
Set Up Automation with Templates
Create a Template by clicking the blue New dropdown arrow in your database and selecting New template. Name it "Recurring Task Template" and set default values for properties. Enable Repeat option and configure it to create new entries based on your recurrence pattern. Set the template to automatically populate when the current task is marked as Done.
Tip
Create multiple templates for different types of recurring tasks (daily habits, weekly reviews, monthly reports) to streamline task creation.
5
Configure Notion Automations
Go to Settings & members > My automations and click New automation. Set the trigger to When database property changes and select your Tasks database. Choose Status property changing to Done as the trigger. For the action, select Create database item and configure it to create a new task with the Next Due Date as the new Due Date.
Tip
Test your automation with a sample task to ensure it creates the next occurrence correctly before applying it to all recurring tasks.
6
Create Filtered Views for Task Management
Add multiple views to your database by clicking Add a view. Create these views: Today's Tasks (filter: Due Date is Today), This Week (filter: Due Date is This week), Overdue (filter: Due Date is Before today AND Status is not Done), and All Recurring (filter: Recurrence is not None). Use Calendar view for better visualization of upcoming tasks.
Tip
Set up notifications for the "Overdue" view to stay on top of missed recurring tasks.
7
Integrate External Automation Tools
For more advanced automation, connect your Notion database to Zapier or Make. Create a Zap that triggers when a task is completed and automatically creates the next occurrence. Go to Zapier, search for Notion, and set up a trigger for Updated Database Item. Then add an action to Create Database Item with the calculated next due date and reset status to To Do.
Tip
Use external tools for complex recurrence patterns that Notion's native features can't handle, like "every 3rd Tuesday" or "last day of each month".
Troubleshooting
Formula not calculating next due date correctly
Check that your Due Date and Recurrence properties are properly configured. Ensure the formula syntax is correct and test with a simple daily recurrence first. Verify that date formats match your workspace settings.
Automation not triggering when task marked as done
Go to Settings & members > My automations and check if the automation is active. Verify that the trigger conditions match exactly (Status property changing to "Done"). Test the automation manually by changing a task status.
Multiple duplicate tasks being created
Check if you have multiple automations running for the same trigger. Disable any conflicting automations or templates. Review your external automation tools (Zapier, Make) to ensure they're not creating duplicates. Add a delay in external automations if needed.
Recurring tasks not showing in filtered views
Review your view filters to ensure they're set correctly. Check that the Due Date property is populated and in the correct format. Refresh the page and verify that the Recurrence property is set to something other than "None" for recurring tasks.
Ready to get started with Notion?
Put this tutorial into practice. Visit Notion and follow the steps above.
Visit Notion →