A task overdue by 3 days → an alert to the consultant, not the client

The problem

The task log looks tidy, but between the rows sit tasks a week past due that nobody touched. They surface when the client calls. By then it is not a delay, it is a trust problem.

What happens when it runs

1. Schedule: every day 08:30
2. Read the task log: status open, due more than 3 days ago
3. Aggregate into one list: task · client · days overdue
4. A Telegram message to the consultant (or the team group) — not to the client

The tools inside

• Make — the automation engine · Sign up (one month of Core free) →affiliate link
• Google Sheets — log and lists
• Telegram — alerts

Before you start

Three things to have ready before importing, or Make will ask and you will have to leave halfway:

• The task log spreadsheet id
• Days overdue threshold (default 3)
• Chat ID

Sheet templates

The file maps columns by position. Start from exactly these headers, in this order — a column in the wrong place writes a phone number into the email column.

• Task log · task | client | due | status Download ↓

How to import (2 minutes)

1. In Make: Scenarios → Create a new scenario
2. At the bottom, the three dots (⋯) → Import Blueprint → choose the file you downloaded
3. Click every module with an exclamation mark: choose your connection (Google, Telegram) — Make creates one in a click if you have none
4. Replace every value in double curly braces ({{…}}) with your own from the list above
5. Run once with a test row in the sheet. Only when it passes — Schedule and ON

The video

Watch on YouTube → · Subscribe to BuilderStack · Telegram channel

Affiliate link. If you sign up through it we earn a commission from Make; your price is the same, and the link gives you one month of Core free.