Send SMS 2 hours before the appointment

Updated 2 months ago

This article will guide you how to set up to send SMS 2 hours before the appointment time.

First you will need to have an account with Zapier and with any scheduling platform that Zapier supports. On this guide, we will be using Zoho Bookings.

  1. Create a Zap and start by adding Zoho Bookings App. Trigger event should be Appointment Booked. Connect your account and proceed to Test Triggerto get a return data.
  1. Add Formatter action - this is a built-in action in Zapier. Action event should be Date/Time
  2. Under Formatter, choose Add/Subtract Time for Transform field. Also, there is a Values section, wherein you will be required to input the dynamic data for the Start time.
  1. On the Expression field, type -2 hours since you are wanting to send SMS 2 hours before the start time / appointment time. Not only you can subtract, but you can also add time. You may use these following formats on the Expression field:   +8 hours, -8 hours, +1 minute, -1 minute, +2 days, -2 days, +1 month and -1 month
  1. Choose 'X' for to Format field to get the conversion of start time minus 2 hours into unix timestamp that is acceptable by ClickSend system. Continue and do a test to get returned data.
  1. Add an action and look for ClickSend SMS to be able to send SMS. As for To field, you can dynamically fetch the customer's number if they left their contact details when they booked. Or you can manually type your number and be notified.
  2. As for Message field, you can also fetch dynamic datas to include in the body message.
  3. Now for Schedule field which is a very important part that you should not missed filling up. Put the unix time stamp that was converted by the Formatter.
  4. From field - type your dedicated number or leave it blank to use our shared random numbers.
  5. Continue and Test. Do not forget to enable this zap so it will be active.

With that set up, an automated SMS will send every time a customer booked.


How Did We Do?


Powered by HelpDocs (opens in a new tab)