Appointment reminders 3 days and 1 day before — by email and message

On a new booking the scenario saves it to Baserow and Postgres, then sends reminders three days and one day before — by email to Gmail and message via MSG91.

  • Reminders go out automatically at the right time
  • Two reminders: three days and one day before
  • By email and by message via MSG91
  • Fewer no-shows from forgetting
Webhook
Set it up for yourselfScriptera

How it works

To get Google Sheets notifications in Baserow, you don't need a developer: a ready-made scenario watches events and sends messages for you.

  1. Starts when: Webhook: New Appointment
  2. Then: Extract Appointment Data
  3. Then: Format & Validate Data
  4. Then: Store in Google Sheets
  5. Then: Wait: 3 Days Before
  6. Then: Send 3-Day Email Reminder
  7. Then: Update Google Sheets: 3-Day Sent
  8. Then: Wait: 1 Day Before
  9. Then: Send 1-Day Email Reminder
  10. Then: Update Google Sheets: 1-Day Sent
  11. Then: Update Airtable: 1-Day Sent
  12. Then: Update PostgreSQL: 1-Day Sent
  13. Then: Send 1-Day SMS Reminder
  14. Then: Update Airtable: 3-Day Sent
  15. Then: Update PostgreSQL: 3-Day Sent
  16. Then: Send 3-Day SMS Reminder
  17. Then: Store in Airtable
  18. Then: Store in PostgreSQL

You can launch this Google Sheets + Baserow integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.

Similar scenarios