Hourly
Get an email when a project task goes overdue
When a task in your project passes its due date unfinished, you get one email about it.
- Runs
- Hourly
- Apps
- Wrike
- AI
- Not needed
- Access
- read
Send this to your assistant
Create a ClickRuntime automation: every hour check my 'Q3 Launch' project in Wrike and email me when an active task passes its due date, with the task name, owner and link.
First time? Adding ClickRuntime to your assistant takes about two minutes.
Why use it
Why teams use this automation
A task in a Wrike project slips past its due date and nothing happens. There is no red banner for the project lead, the assignee may not have looked at it for days, and the client milestone that depended on it comes and goes. By the time someone spots the overdue marker on the board, the delay has already passed to the next three tasks in the chain.
Every hour, active tasks in the folder you picked with a due date before today are listed. Tasks that were already reported are skipped using stored state, and new ones are emailed to you with their titles and links. You hear about each overdue task once, soon after it falls behind.
Project managers responsible for a single high-stakes project, such as a product launch or an event, usually point this at that folder.
What you get out of it
Slippage is caught within the hour
Hearing about a missed date shortly after it passes gives you time to reassign, renegotiate or warn the client while there is still room to recover. Even a one-day head start can be the difference between a small slip and a missed milestone.
Each task is flagged once
Remembering which tasks were reported keeps your inbox from filling with the same overdue item every hour, so every alert is genuinely new information. A short list of new items is far easier to act on than a repeated alert about old ones.
Dependent tasks are protected
A late design task delays development, which delays testing. Seeing the first domino early lets you adjust the plan before the delay grows. Fixing the first late task protects the dates of everything scheduled behind it.
Accountability without nagging
The project lead sees the overdue item and decides whether to chase, instead of the team receiving automated reminders that feel impersonal and get ignored. Leads choose whether to call, reassign or wait, and the team is spared noisy automated pings.
Scoped to the work that matters
Pointing the check at one folder avoids alerts about old tasks in unrelated spaces, so the signal comes from the project you are actually accountable for. That keeps the signal strong for the project you answer for, without alerts from other spaces.
How it works
What happens, step by step
Every hour, ClickRuntime checks the active tasks in your Wrike project folder for any past their due date.
Tasks it has already told you about are skipped, so each one is reported once.
You get an email listing the newly overdue tasks with who they are assigned to, their due dates and links.
Before it runs live
- Connect Wrike
What you get
Build your own
Need it to work differently?
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
- Act only on the items that match your own rules, and skip the rest
- 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 Wrike steps into one automation
Under the hood
The code that runs this automation
import json
from datetime import date, timedelta
from clickruntime import on_trigger, report_fetched, state, notify, http, credentials
API = "https://www.wrike.com/api/v4"
FOLDER = "IEAAAAAAI4AAAAAA" # your 'Q3 Launch' project id
@on_trigger
def run(event):
headers = {"Authorization": "Bearer " + credentials.connection("wrike", "main")}
yesterday = (date.today() - timedelta(days=1)).isoformat()
tasks = http.get(f"{API}/folders/{FOLDER}/tasks", headers=headers, params={
"status": "Active", "dueDate": json.dumps({"end": yesterday}), "fields": json.dumps(["responsibleIds"]),
}).json()["data"]
known = set(state.get("alerted") or [])
new = [t for t in tasks if t["id"] not in known]
report_fetched(len(new))
if not new:
return {"summary": "No newly overdue tasks"}
ids = {r for t in new for r in t["responsibleIds"]}
names = {c["id"]: f"{c['firstName']} {c['lastName']}" for c in http.get(f"{API}/contacts/{','.join(ids)}", headers=headers).json()["data"]} if ids else {}
lines = [f"{t['title']} | {', '.join(names.get(r, '?') for r in t['responsibleIds']) or 'unassigned'} | due {t['dates']['due'][:10]}\n{t['permalink']}" for t in new]
notify.email_me(f"{len(new)} Q3 Launch tasks now overdue", "\n\n".join(lines))
state.set("alerted", list(known | {t["id"] for t in new}))
return {"alerted": len(new)}FAQ
Common questions
What counts as overdue?
Will I be alerted again if the date passes a second time?
Can the alert go to the assignee as well as me?
What permissions does it need?
Does it need AI?
How many runs does it use?
Can I change how it works?
Related
You might also like
Get your Wrike tasks for today in Slack
Every weekday morning you get a Slack list of your tasks due today and anything already overdue.
See how it worksPost Wrike status changes to Slack
When a task's status moves, the channel sees the task with its old and new status.
See how it worksGet a Monday list of overdue tasks by owner
One email each week shows every overdue task in a folder, grouped by owner, with days late.
See how it worksKeep exploring
Set up “Get an email when a project task goes overdue” from your assistant
Copy the prompt above, or connect your assistant first. Free plan, no credit card.
