How to set up recurring task automation on Notion

intermediate 12 min read Updated 2026-03-18

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.

Try Notion Full Notion Review

Prerequisites

Active Notion workspace
Basic understanding of Notion databases
Notion Pro plan for advanced automations
Familiarity with database properties

Step-by-Step Instructions

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).

Set up your Status property with options like To Do, In Progress, and Done for better task tracking.

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.

You can add custom recurrence options like "Bi-weekly" or "Quarterly" based on your specific needs.

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")))))

Test the formula with a sample task to ensure it calculates the next due date correctly before adding all your tasks.

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.

Create multiple templates for different types of recurring tasks (daily habits, weekly reviews, monthly reports) to streamline task creation.

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.

Test your automation with a sample task to ensure it creates the next occurrence correctly before applying it to all recurring tasks.

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.

Set up notifications for the "Overdue" view to stay on top of missed recurring tasks.

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.

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".

Common Issues & 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.

Prices mentioned in this guide are pulled from current plan data and may change. Always verify on the official Notion website before purchasing.

Visit Notion View Notion Pricing