“"I'll get back to you." Then nine days of silence.”
A lead untouched for 7 days → an alert to the salesperson, not the client
Now no warm lead goes cold unnoticed.
Every morning, each open lead not updated for a week surfaces in one list: name, source, owner, days quiet. The lead gets nothing — the owner does.
Get the ready-to-import blueprint by email
The full build is on this page, free, no email needed.
Short answer
Every morning, each open lead not updated for a week surfaces in one list: name, source, owner, days quiet. The lead gets nothing — the owner does.
- Tools
- Make, Google Sheets, Telegram
- Cost to run
- 3 Make credits (operations) per run
The problem
A warm lead goes cold within days. It does not vanish from the sheet, it just stops moving: a first call, "I will get back to you", and silence. Two weeks later they bought from someone else.
What happens when it runs
- Schedule: every day 08:30
- Read the leads sheet: status open, last update more than 7 days ago
- Aggregate into one list: lead · source · owner · days without movement
- A Telegram message to the salesperson (or the team group) — the lead gets nothing
The tools inside
Disclosure: links marked "paid link" pay us a commission from the vendor if you sign up. Your price is unchanged, and every file here works without them. How we choose tools →
- Make — the automation engine · Sign up (one month of Core free) → paid link · we earn a commission
- 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 leads spreadsheet id
- The number of days (default 7)
- 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.
- Leads pipeline ·
timestamp | name | phone | email | source | status | owner | last_update(Sent with the blueprint by email)
How to import (2 minutes)
- In Make: Scenarios → Create a new scenario
- At the bottom, the three dots (⋯) → Import Blueprint → choose the file you downloaded
- Click every module with an exclamation mark: choose your connection (Google, Telegram) — Make creates one in a click if you have none
- Replace every value in double curly braces ({{…}}) with your own from the list above
- 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
Read more
- Lead response time: what the research measured, what it does not show, and a checklist for small teams
- 27 Make.com automations consultants set up for clients: what to automate first, and why (free blueprints)
- Track where your leads come from in Google Sheets — and catch the ones going cold
- Make + Google Sheets as a free small-business database: the modules, the limits and the pitfalls
- Small business automation & lead response statistics (2026)
- Do you need a CRM, or is a Google Sheet enough? A decision checklist, what a sheet plus Make gives you, and when to move
What does not work in it
- Everything leans on the "last update" column. If salespeople do not touch it after a call, an active lead looks stuck. Let the sheet stamp it on edit (a formula or an on-edit script) — or accept the noise.
- The list goes to one chat. If each salesperson should see only their own, add a filter by owner and a Chat ID per person.
Questions
What does not work in "A lead untouched for 7 days → an alert to the salesperson, not the client"?
Everything leans on the "last update" column. If salespeople do not touch it after a call, an active lead looks stuck. Let the sheet stamp it on edit (a formula or an on-edit script) — or accept the noise. The list goes to one chat. If each salesperson should see only their own, add a filter by owner and a Chat ID per person.
What do I have to fill in after importing the blueprint?
The leads spreadsheet id; The number of days (default 7); Chat ID.
Which tools does it use, and what does a run cost?
Make, Google Sheets, Telegram. Each run uses 3 Make credits (operations).
Is the blueprint free?
Yes. The ready-to-import file is sent free to the email address you enter; the newsletter is a separate box you can leave unticked. The full build is on this page without any email. The file contains no connections and none of our ids, and works whether or not you use the paid Make link on the page.
Build your automation plan →Four questions, three automations ranked for your business.
Paid 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.
Next step
All automations →
LEAD ALERTLead comes in → logged → alert. No hands.
A form on the client site sends a lead; it is logged and an alert reaches Telegram in seconds. The first automation every consultant sets up.
DUPLICATE CHECKReturning lead → recognised → "second contact", not "new lead"
A returning lead is greeted as new. Before logging, the phone is checked against the log; if it is there, the alert says "came back", not "new lead".
SOURCE REPORTEvery Sunday: leads by source → one message with the change from last week
Which source brings the leads? Every Sunday one Telegram message lists this week's leads per source (website, Facebook, referral) beside last week's.
Get one new Make automation each week
Get the full 27-blueprint pack (ZIP) by email, then one new automation a week. Every build on the site stays open and free without it.