On a schedule

Get reminders for Notion tasks due soon

Each morning you get the tasks due in the next two days, overdue ones move to today, and anything a week late is flagged as stale.

Runs: On a schedule
Apps: Notion
AI: Not needed
Access: read+write

Send this to your assistant

Create a ClickRuntime automation: every weekday at 8am, email me the tasks in my Notion Tasks database due in the next 2 days. Move overdue tasks that aren't done to today, and tick Stale on any that are more than a week overdue.

Paste it into your assistant. It tells you what it will send or change before it runs live.

Add to ChatGPT Add to Claude

First time? Adding ClickRuntime to your assistant takes about two minutes.

Why use it

Why teams use this automation

A product team runs its sprint out of a Notion task board with Due, Status and Owner properties. By Thursday, a dozen cards have due dates in the past, some still marked In progress, and nobody can tell which are genuinely late and which were quietly abandoned. The board looks busy, the real commitments are buried, and standup turns into reading the list aloud.

On its schedule, the board is queried by due date and status. Anything due in the next two days goes into an email reminder. Open tasks whose date has already passed get their Due moved to today, and ones that are far behind get a Stale checkbox ticked.

It is most useful for solo founders and small teams who plan in Notion but have no project manager chasing dates.

What you get out of it

Tomorrow's deadlines are never a surprise
The email lists what is due soon with owners and dates, so a Friday client deliverable is in front of you on Wednesday and not discovered at four on Thursday afternoon.
Today's view stays truthful
Overdue cards roll forward to the current date, so a filter on Due equals today actually shows the work that needs doing, not just the tasks that happened to be scheduled for this morning.
Abandoned work gets a visible flag
A Stale checkbox on cards that are long past due lets you filter them in one click and decide whether to finish, reschedule or delete, instead of letting dead items pad the backlog forever.
Fewer minutes lost to board grooming
Dragging a pile of old dates forward by hand is a chore people postpone for weeks. Doing it on a timer saves that recurring slot and keeps Monday planning short.
A fair picture of slippage
Because stale items are marked and not silently deleted, you can count how many tasks routinely slip and use that to set more realistic sprint sizes next time. That history makes sprint estimates honest.

How it works

What happens, step by step

Every weekday at 8am ClickRuntime checks your Notion tasks database.
It finds open tasks due in the next few days and emails you the list.
Overdue tasks are moved to today and marked as stale, so nothing quietly slips.

Before it runs live

Connect Notion and share the database you want it to use

What you get

RunsOn a schedule

Get reminders for Notion tasks due soontoday, 9:00Succeeded

Email · 3 tasks due soon, 2 moved to todaySend Acme the revised quote (due 2026-10-20) Book Northwind workshop room (due 2026-10-21)

Build your own

Need it to work differently?

This template is a starting point. Copy the prompt and change it, or describe a different automation from scratch, with your own conditions, more apps or an AI step. Your assistant writes it, tests it and runs it on ClickRuntime.

Your own rules
Conditions, thresholds, filters and exceptions, written the way you'd explain them to a colleague.
Any number of apps
One automation can read from one app and update several others. Over 248 apps are ready, and anything with an API works too.
AI where it helps
Summaries, classification, extraction and drafts use ClickRuntime's built-in AI, with no extra key.
On a schedule or on each event
Runs as often as every 5 minutes, or the moment an app sends an event, and keeps track of what it already handled.

Changes you can ask for

Run it at a different time, more or less often, or only on weekdays
Add an AI step, for example to summarize, sort or draft a reply
Add another app, for example also send it to Slack
Combine it with other Notion steps into one automation

Under the hood

The code that runs this automation

This is the Python script that runs each time the automation starts. Your AI assistant writes it for you when you send the prompt, and you allow each step in your assistant. To change how the automation works, describe the change to your assistant and it updates the script for you. For every function it can use, see the script reference.

deadline_reminders_and_overdue_task_roll_forward.pyexample

from datetime import date, timedelta
from clickruntime import on_trigger, credentials, http, notify

NOTION = "https://api.notion.com/v1"

def headers():
    return {"Authorization": f"Bearer {credentials.secret('NOTION_TOKEN')}", "Notion-Version": "2022-06-28"}

def query(db, body=None):
    resp = http.post(f"{NOTION}/databases/{db}/query", headers=headers(), json=body or {})
    resp.raise_for_status()
    return resp.json()["results"]

def title(page, prop="Name"):
    return "".join(t["plain_text"] for t in page["properties"][prop]["title"])

TASKS = "tasks-database-id"

@on_trigger
def run(event):
    today = date.today()
    open_tasks = query(TASKS, {"filter": {"and": [
        {"property": "Done", "checkbox": {"equals": False}},
        {"property": "Due", "date": {"on_or_before": (today + timedelta(days=2)).isoformat()}}]}})
    due_soon, moved = [], 0
    for t in open_tasks:
        due = date.fromisoformat(t["properties"]["Due"]["date"]["start"][:10])
        if due >= today:
            due_soon.append(f"{title(t)} (due {due})")
            continue
        props = {"Due": {"date": {"start": today.isoformat()}}}
        if (today - due).days > 7:
            props["Stale"] = {"checkbox": True}
        http.patch(f"{NOTION}/pages/{t['id']}", headers=headers(), json={"properties": props}).raise_for_status()
        moved += 1
    notify.email_me(f"{len(due_soon)} tasks due soon, {moved} moved to today", "\n".join(due_soon) or "Nothing due in 2 days.")
    return {"due_soon": len(due_soon), "moved": moved}

FAQ

Common questions

What defines an overdue task in this setup?

A task counts as overdue when its Due date is earlier than today and its Status is not Done or a similar closed value. Tasks with no due date are left alone, since there is nothing to compare against.

Can the stale cutoff be five days instead of seven?

Yes. The number of days that makes a task stale is a plain threshold. Tell your AI assistant the cutoff you want, and it will show the updated rule for you to approve before it goes live.

Does it reschedule tasks owned by other people?

It updates every matching card in the database you connect, whoever owns it. If you want to limit it to your own tasks, a filter on the Owner or Assignee property keeps other people's cards untouched.

What permissions does it need?

read+write. Nothing else in your accounts is used.

Does it need AI?

No. It runs without AI, so it doesn't use your plan's AI allowance.

How many runs does it use?

One run each time it runs (on a schedule). Checks that find nothing to do and stop right away aren't counted.

Can I change how it works?

Yes. Describe the change to your AI assistant, for example a different schedule, channel or filter. It updates the automation, tests it and tells you what changed.

Daily