Booking form → meetings sheet → confirmation email. Feeds the no-show reminder
A Tally booking form writes the meeting into the meetings sheet, emails the client a confirmation with the date and time, and tells you on Telegram. The no-show reminder then takes over the day before.
The problem
Meetings booked by phone or WhatsApp never make it into a sheet, so the no-show reminder has nothing to remind about. A form the client fills in is the only way the sheet stays complete without someone typing.
What happens when it runs
- A Tally form (name, email, date, time) sends the booking to the Make webhook
- A new row in the meetings sheet with status "booked"
- A confirmation email to the client with the date and time
- A Telegram message to you
The tools inside
- Tally — the form that fires the webhook (free; any form tool works) · Create a free form →affiliate link
- Make — the automation engine · Sign up (one month of Core free) →affiliate link
- Google Sheets — log and lists
- Gmail — email
- Telegram — alerts
Before you start
Three things to have ready before importing, or Make will ask and you will have to leave halfway:
- The webhook address (paste it in Tally)
- The meetings spreadsheet id
- The confirmation wording
- 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.
- Meetings sheet ·
client | email | date | time | status | reminder_sentDownload ↓
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
Read more
What does not work in it
- This does not check your availability. Two clients can book the same slot. Either offer fixed slots in the form (a dropdown you prune by hand) or use a scheduling tool and keep this for logging.
- The date must arrive as YYYY-MM-DD for the no-show reminder to find it. Use Tally's date field, not a free-text one.
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.
More automations
All automations →
AUTO WELCOMENew client → welcome email → onboarding checklist → alert
The moment a client signs, three things happen on their own: they get an email that says what comes next, an onboarding checklist opens, and the team is alerted.
QUOTE FOLLOW-UPQuote unanswered for 3 days → one follow-up, automatic
Every quote sent and unanswered within three days gets one short follow-up email, and the consultant gets an alert. Nothing to remember, nobody to chase.
REVIEW ASKProject closed → 7 days → a Google review request
A week after a project is marked "done", the client gets a personal email with a direct link to write a review. Once, at the right moment.