What does this Google Sheets automation do?
A daily check reads date columns and raises a task for anything due or overdue.
What can you do with it?
- Stop relying on conditional formatting nobody looks at
- Get a real task instead of a red cell
- Catch overdue items the day they slip
The Steps
This automation runs in 3 steps:
- When Schedule — Every Day
- Then Google Sheets — Find Row(s)
- Then Loop over each row that is due or overdue — Add Task
Who is this automation for?
Built for anyone tracking dates in a sheet. A daily check reads date columns and raises a task for anything due or overdue.
How do you set it up?
- Open the "Automations" tab in your workspace.
- Click ➕ Add automation, then start from scratch.
- Add the trigger "Every Day" from Schedule.
- Add the action "Find Row(s)" from Google Sheets.
- Add a Loop step: Loop over each row that is due or overdue — Add Task.
- Connect your Google Sheets account when prompted, then enable the toggle in the top-right corner.
Prefer to describe it instead? Click Build this flow with AI above and Taskade wires the trigger, the steps for you.