Send automated appointment reminder emails before or after a date collected in a Google Form booking form.
This automation checks to see if today's date matches an appointment reminder date specified in a Google Form and automatically sends a reminder email if TRUE.
Connect your Google Form responses to Lido's spreadsheet with one-click.
Set up custom SMS text triggers around the appointment date. Use basic spreadsheet formulas to calculate reminder dates.
For example, if the appointment date is in column B and you want to send a reminder email 3 days before, the formula would be:
=B2-3
You can include details from each Google Form submission, like the customer's name and appointment time, in the body of the email.
=IF(TODAY()=C2, SENDSMS(<sender-number>, "+18293821192", "Appointment reminder", "[Name], your appointment is in 3 days")