Text new enquiries a booking link, then chase once
Texts each new Airtable enquiry your Cal.com booking link in your texting hours, sends one reminder if they have not booked, then stops.
What it does
Each integration step this workflow runs, in order, what it is for, and the conditions and loops that decide when it runs.
- 1AirtableList recordsReads the enquiries added in the last few days that have not been texted yet, plus everyone still waiting on their reminder.
For each
enquiry- 2Cal.comList bookingsChecks whether the enquirer's email address already has an upcoming booking before any text is sent.
If
bookingLookup.bookingsis not empty- 3AirtableUpdate recordMarks the enquiry 'Link sent' or 'Reminded' once the text has gone out, 'Booked' when Cal.com shows a booking, or 'Needs attention' when it cannot be texted.
- 3
- 4TwilioSend smsTexts the booking link, or a single reminder after the waiting period, during your texting hours, each ending with an opt-out line.
- 5AirtableUpdate record
- 2
If
refusedIdsis not empty andtextsSentis more than 0For each
refusedId- 6AirtableUpdate record
- 6
How it works
What happens on each run, in plain English.
Every hour, the workflow looks for enquiries added to your Airtable table in the last few days and texts each one your Cal.com booking link. If they still have not booked after the waiting period you choose, it sends exactly one reminder, then leaves them alone. Texts only go out between the hours you set (9:00 to 19:00 unless you change them), so nobody hears from you at 2am, and enquiries already in your table when you connect it are never texted.
Nobody who has booked is chased: before every text, Cal.com is checked for an upcoming booking under their email address. A row is marked 'Link sent' or 'Reminded' only once Twilio has accepted the text, so nobody is texted twice. A row with no usable mobile number or email address is marked 'Needs attention' for you to look at instead of being texted at a guess. If Twilio refuses a text, Cal.com cannot be checked or a row cannot be updated, the run is marked as failed and names the people affected, so a problem never looks like a quiet day.
You need Airtable, Cal.com and Twilio connected, and an Airtable table with 'Name', 'Phone', 'Email', 'Follow-up Status' and 'Follow-up Date' columns. Fill in the base and table, your Cal.com booking link, the Twilio number to text from, your business name and the country your customers' numbers are from.
You may also be interested in
Brief yourself on the people you are meetingEmails you a short, sourced briefing on each outside guest booked into your calls in the day ahead.
Voice-note reminders for tomorrow's appointmentsEmails each client booked for tomorrow a spoken reminder as an audio attachment, and never reminds the same booking twice.
Find work emails for new Airtable leads with Prospeo and HunterFinds a work email for each new lead in your Airtable table, trying Prospeo then Hunter, and writes it onto the row.
Find a work email for every new lead in AirtableEvery 15 minutes, finds a work email for each new lead in your Airtable table, trying Apollo then Hunter, and writes it on the row.Start from a workflow that already works.
Add "Text new enquiries a booking link, then chase once" to your workspace, connect its apps, and make it yours.
Free plan, no credit card