How to Create a Recurring Task Template in Notion Databases

1. Create a database template.
2. Create database automation.
3. Set trigger (e.g., weekly time).
4. Set action: Create new entry, select template.

To enable recurring database entries based on a template, first create the database template, then configure database automation to periodically trigger (e.g., weekly) and set the action to ‘Create new entry’, selecting that template. Copy-paste this setup method.

The Syntax Breakdown

  • Database Template: A predefined page structure within a database, including pre-filled properties and page content. Templates serve as blueprints for new database entries.
  • Database Automation Trigger: A time-based schedule (repeating daily, weekly, monthly, or yearly) or property change that initiates the automation sequence. For recurring tasks, this is always a repeating time interval.
  • Database Automation Action: The specific operation executed when the trigger is activated. In this scenario, the action must be set to Create new entry. Crucially, the desired database template must be selected within this action to pre-populate the new entry.

Real-World Example: Daily Infrastructure Checks

An operations manager requires a new Daily Infrastructure Check entry to be generated automatically every weekday morning in the System Logs database.

Mock Data Table (before automation):

Check NameDateStatusSRENotes

Application of Setup:

  1. Define Template: Create a database template named Infrastructure Check Template, pre-filling Check Name (perhaps with @today token in Title, though not natively dynamic in title without @today being part of the title configuration, often better handled in properties or just naming template conceptually), Status property as Pending, and empty properties for SRE and Notes.
  2. Configure Automation: Navigate to database Automations, creating a new automation.
    • Set Trigger: Choose Repeating, configuring for Every Weekday at 8:00 AM.
    • Set Action: Choose Create new entry, and select Infrastructure Check Template.

Output: Every weekday at 8:00 AM, a new entry (e.g., Infrastructure Check Template) is automatically created in the database. The Date property will default to the current date if configured as @today in a text title/property, Status will be Pending, and the SRE/Notes properties will be blank, ready for the engineer to fill out.

Common Errors & How to Fix Them

  • Automated entries are created, but they are blank or don’t use the pre-filled template information. Fix: Edit the automation action, click ‘Select template’, and choose the correct template.
  • Recurring entries are not being generated on schedule. Fix: Review automation trigger settings, verify frequency and time are accurate, and ensure automation is toggled ON.

About the Architect: Grid and Formula

Lead Data Analyst and Workspace Automation Engineer at Grid & Formula. Specializing in Excel logic, Google Sheets architecture, and Notion database blueprints. I build and rigorously test the formula frameworks and error fixes published here, ensuring you get immediate, no-fluff solutions to your most complex data bottlenecks.