Automations → A meeting tomorrow → a reminder 24 hours ahead, with a "can't make it" link

NO-SHOW SHIELD

A meeting tomorrow → a reminder 24 hours ahead, with a "can't make it" link

Every morning, each of tomorrow's meetings in the sheet gets a reminder email with the time and a "can't make it" link. Whoever cannot come says so in advance, instead of not showing up.

MakeGoogle SheetsGmail3 operations / run✓ Imported successfully into our Make account
Video cover: NO-SHOW SHIELD

The problem

A client who misses a meeting does not mean harm — they forgot, or something changed and telling you felt awkward. The result: an hour burned, sometimes two with the drive.

What happens when it runs

  1. Schedule: every day 09:00
  2. Read the meetings sheet: status "booked", date tomorrow, reminder not yet sent
  3. An email to the client: tomorrow at X, and a "can't make it" link that opens a ready email to you
  4. Mark the reminder in the sheet so it never goes out twice

The tools inside

Before you start

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

  • The meetings spreadsheet id
  • Your email address (for the "can't make it" link)
  • The email wording

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_sent 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

What does not work in it

  • The "can't make it" link opens an email to you — it does not change the sheet by itself. The status updates when you read that email, or with a second automation that spots the subject.
  • A meeting booked today for tomorrow is only caught if it was logged before 09:00. Last-minute bookings get no reminder.
  • The log is a sheet, not Google Calendar. If your meetings live in Google Calendar, reading them needs a different module.

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 →