You can use Zapier integration to automatically update a spreadsheet with client responses generated from predetermined SMS survey questions.

If you have not created the Zapier integration already, follow the instruction here to create one : SMS Survey (Multiple SMS responses)

Test Burst SMS Zap

Step 1 - Search for Burst SMS in Search apps...

 

 

Step 2 - Select Send SMS from the drop-down menu.

Step 3 - Select your account from the Choose an account drop-down menu.

 

Step 4 - Clicking within the message box will allow you to insert data into the message. To personalize each message, select the option for Lookup Spreadsheet Row in Google Sheets and select Name.

 

 

Step 5 - To insert the recipient's mobile number, select Number from the drop-down menu.

 

Step 6 - Before we test ZAP 2, we need to create ZAP 3 to forward SMS replies.
*Open a new tab in the browser and create a new ZAP (Repeat Step 1 and 2)
Search for apps... for webhook.

 

 

Step 7 - Select Catch Hook from the Trigger Event drop-down menu. 

Step 8 - The Custom Webhook URL will be generated, this link needs to be copied by clicking the Copy function.

 

Step 9 - The link copied can now be pasted into ZAP 2 in the Forward Replies to URL field and click Continue.

Step 10 - Test & Continue will be highlighted (ZAP 2).

*If the test is Successful, ZAP 2 is now complete.

 

 

 

Step 11 - If the test is Successful, can now Turn on ZAP 2.