SMS multi-step survey

[bsh3p]

Hi everybody

I'm trying to build a multi-step SMS survey and hoping for some guidance, please. I've put steps below.

• Patient has surgery
• Message 1: Night of surgery, send SMS to check on them and ask for a pain rating 0-10 (if they respond prior to next outbound SMS, record their answer in Google Sheet)
• Message 2: 7 days later, send another SMS almost the same (if they respond prior to next outbound SMS, record their answer in Google Sheet)
• Message 3: 7 days later, send another SMS almost the same (if they respond prior to next outbound SMS, record their answer in Google Sheet)

So far I've got the first SMS working via Google Sheets containing name, number and blank columns awaiting responses, delay til day of surgery then send message via Twilio. Easy.

For the next step however, in my mind I need a branch that says, if a webhook is received from Twilio after sending message 1 but before Message 2, place response into Google Sheets. Same again for between Message 2 and 3, and perhaps x days after Message 3 no longer care about responses. It's a pretty simple workflow if I think of it in process terms, but unsure how to use Pabbly to do it.

I'm really keen on trying to understand how this might be possible, please. I really understand the outbound which is super easy, and having Twilio send a webhook to Pabbly is pretty easy via Twilio Studio, but unsure how I link that together with the timings of the inbound messages.

I'm open to suggestions , even those which don't utilise Twilio (I'm flexible on the SMS provider)

Thanks so much.

 

[Arshita]

Hey @bsh3p

The use case you are looking for is possible. Please allow me some time to check it.

In the meantime, I suggest you to refer the following video tutorials that explain how Twilio works in Pabbly Connect:

Additionally, please let me know the application you wish to use as the trigger for your workflow. This information will assist me in providing you with the necessary guidance and support.

 

[bsh3p]

Hey @bsh3p

The use case you are looking for is possible. Please allow me some time to check it.

In the meantime, I suggest you to refer the following video tutorials that explain how Twilio works in Pabbly Connect:

Additionally, please let me know the application you wish to use as the trigger for your workflow. This information will assist me in providing you with the necessary guidance and support.

Thanks for the reply Arshita

I am using Google Sheets as the trigger; I am comfortable with sending Twilio messages (which these videos demonstrate), rather it is handling SMS responses that I need help with, please. Specifically, handling multiple incoming messages and associating them to the correct column in Google Sheets based on when SMS responses are received relative to the messages I am sending out.

Thanks, Brendan

 

[Arshita]

Hey @bsh3p

The use case you mentioned is possible, but it requires the creation of two separate workflows.

The first workflow will be for triggering data from Google Sheets and sending messages, while the second workflow will handle receiving responses from the Twilio application.

To assist you in setting up these workflows, we have provided a video tutorial. I kindly request you to follow the tutorial and create the workflow first.

If you face any issues or have questions, please let me know, and I'll help you.

 

[bsh3p]

Thank you Arshita. Sorry if I'm being silly, but where is the video tutorial, please?

 

[Arshita]

Hey @bsh3p

I kindly request you to please refer to the below video tutorial for a better understanding of the Twilio application: