“Two thousand dollars on ads, and the client asked: is it working?”
Every Sunday: leads by source → one message with the change from last week
Now the budget follows a number, not a feeling.
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 the ready-to-import blueprint by email
The full build is on this page, free, no email needed.
Short answer
Which source brings the leads? Every Sunday one Telegram message lists this week's leads per source (website, Facebook, referral) beside last week's.
- Tools
- Make, Google Sheets, Telegram
- Cost to run
- 5 Make credits (operations) per run
The problem
The client pays for ads and asks "is it working?". The answer sits in the leads sheet, but nobody counts by source every week. So budget decisions are made on a feeling.
What happens when it runs
- Schedule: every Sunday 08:00
- Read the leads from the last 7 days and the 7 days before
- Count by the source column: website, facebook, referral
- A Telegram message: each source, this week against last week, and the total
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 source names exactly as they appear in the sheet
- 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 log ·
timestamp | name | phone | email | source(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
What does not work in it
- The count is only as accurate as the source column. "FB", "Facebook" and "facebook ads" are three different sources — lock the column to a fixed list (data validation) before trusting the numbers.
- A lead with no source counts in the total and in no row. If the total is well above the sum of the rows, that is the sign.
- One week is noise. 3 leads against 5 is not a trend; a budget decision needs 4–6 weeks.
Questions
What does not work in "Every Sunday: leads by source → one message with the change from last week"?
The count is only as accurate as the source column. "FB", "Facebook" and "facebook ads" are three different sources — lock the column to a fixed list (data validation) before trusting the numbers. A lead with no source counts in the total and in no row. If the total is well above the sum of the rows, that is the sign. One week is noise. 3 leads against 5 is not a trend; a budget decision needs 4–6 weeks.
What do I have to fill in after importing the blueprint?
The leads spreadsheet id; The source names exactly as they appear in the sheet; Chat ID.
Which tools does it use, and what does a run cost?
Make, Google Sheets, Telegram. Each run uses 5 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".
COLD LEAD RADARA lead untouched for 7 days → an alert to the salesperson, not the client
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 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.