About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Question

How do I automate SMS sequencing for unbooked leads using Zapier?

  • 4 September 2023
  • 5 replies
  • 52 views
cmwallace

I need to be able to create an integration that will put our leads in a sms sequence due to them not booking a call with our sales team. 

Our flow works like this 
Website → Lead Form Fill Out → Calendly Link

Sometimes people will fill out lead form but not book a call. I have their info now and want to get our sales team on the leads that dont book so they dont fall through the cracks. I am not sure how to automatically do this on zapier. Ideally I would like to create a lead in my CRM for the ones that didnt book and automatically assign them a texting campaign. 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

5 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @cmwallace 

Good question.

Which CRM app are you using?

You’ll likely need 2 Zaps.

  • Lead Booked
  • Lead has not yet Booked
    • You’ll need to defined the logic for this. (e.g. 5 days, etc.)

Also, you may need Zaps to handle canceled bookings and rescheduled bookings.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
cmwallace

We use woosender. 

ken.a
Userlevel 7
Badge +6

Hi @cmwallace,

I’m jumping in to see if I can help!

Have you tried using the “Appointment Created” and “Appointment Cancelled” trigger in WooSender? Those triggers might be the ones that you need for your workflow.

https://zapier.com/apps/woosender/integrations

10f080f2bbf41e842d9dee30b0846884.png
(view larger)

Please give that a try, and let us know how it goes!

cmwallace

No because the appointment was never created to be cancelled. 

SamB
Rank
Userlevel 7
Badge +11

Hi @cmwallace! 👋

What you’d need here is a way to search Calendly to check whether the person that submitted the form booked a call that way you could then use the Create Contact (WooSender) action to add them if they hadn’t booked. So I’ve added you to an existing feature request for that functionality, since it’s what you’d need here. Can’t make any promises as to when or if it would be added to the Calendly app but we’ll be sure to notify you by email as soon as it is.

In the meantime, as a workaround you may need to store a record of everyone who books a call in a third party app like Google Sheets to Airtable. Then you can search those records to see if the person has booked or not. I’m not sure what app you’re using for the form, but the workaround I’m thinking of would be like so:

 

Zap 1 - Adds new bookings to a spreadsheet

  • Trigger: Invitee Created (Calendly) - triggers when someone books a call event.
  • Action: Create Spreadsheet Row (Google Sheets) - creates a new row for the booking. Stores unique information that can be used for searching by the second Zap (e.g. email address). Using Google Sheets as an example here but the principle would be similar for an app like Airtable, Microsoft Excel etc.

 

Zap 2 - Checks spreadsheet to see if they’ve booked and if not, add them to WooSender 

  • Trigger: New Form Submission (Your form app) - triggers for each new form submission.
  • Action: Delay For (Delay by Zapier) - set to delay the Zap from continuing for 5 minutes to give people enough time to book before allowing this Zap to look for them on the spreadsheet. You may need to increase this delay depending on how long it take folks to make a booking. (See Add delays to Zaps)
  • Action: Lookup Spreadsheet Row (Google Sheets) - searches for the user’s email address. If a user is not found then that would indicate that they didn’t make a booking. (See Search for existing data in Zaps)
  • Action: Only Continue If… (Filter by Zapier) - set to only continue if _zap_search_was_found_status field is false (this means that the user wasn’t found in the bookings spreadsheet. (See Add conditions to Zaps with filters)
  • Action: Create Contact (WooSender) - Adds the lead to WooSender

 

Do you think that approach might work?

If you run into any issues in setting that up just let us know. Always happy to help further!

Terms & Conditions