Weekly report → Telegram, every Sunday at eight

The problem

"What’s happening with the leads?" is a conversation that repeats weekly. The consultant opens three sheets, counts, and answers. The client feels like a nag. Both lose an hour.

What happens when it runs

1. Schedule: Sunday 08:00
2. Read three sheets: this week’s leads, open tasks, open invoices
3. Compose one short message with the numbers and the change from last week
4. Send to the client’s Telegram group

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:

• Three spreadsheet ids
• The client's Chat ID
• The send hour

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 Download ↓
• Task log · date | from | subject | link | 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.