Use this Zapier integration to automatically update a spreadsheet with client responses generated from predetermined survey questions. When a response is received, it triggers the next question to send out. Zapier allows you to sync data and integrate it between many different applications. We have added Burst SMS to its rapidly growing list.
Before we dive into this Zapier integration, make sure that you have:
Burst SMS Account. We offer a 14-day free trial that you can use to test this Zapier SMS integration.
Zapier Account. Account. (Premium)
TABLE OF CONTENTS
Step 1 - Once you login to Zapier, click MAKE A ZAP.
Step 2 - Let's give the ZAP a name by clicking on the Name your zap.
Step 3 - Click on Search apps... and enter Google sheets.
Step 5 - Login to your Google account.
Step 6 - Grant access to Zapier.
Step 9 - Choose your account.
Step 10 - Create the worksheet.
*Name and number columns.
*Each SMS response will need its own column.
Step 12 - Test your trigger.
Step 13 - Your Spreadsheet should now be listed.
*If successful, columns containing data will be shown.
Step 14 - Search for the Burst SMS App.
Step 16 - Sign in to your Burst SMS Account.
Step 17 - To grant Zapier access to your Burst Account, you will need to provide your API Key + API Secret.
Step 18 - Your API Key and API Secret details will be located in your Burst SMS Account under Settings.
*Please create an API Secret if this box is empty and save it by clicking UPDATE PROFILE at the bottom of the page.
Step 19 - Click on Choose an account... If your API Key and API Secret have been entered correctly, you will see the account in the dropdown menu.
Step 20 - Set up action will allow you to insert data into the message. Click within the message box to insert the name.
Step 21 - The Recipient Mobile Number will work on the same principle, click Choose Value to retrieve the Number data column from the sheet.
Step 22 - Format Number and Caller ID are both optional.
*Format Number convert numbers to locale.
*Caller ID will result in messages originating from the same number and not the shared pool.
Step 23 - Before we test ZAP 1, we need to create ZAP 2 to forward the SMS replies.
*Open a new tab in the browser to create a new ZAP.
Step 24 - The Custom Webhook URL will be generated, this link needs to be copied by clicking the Copy function.
Step 25 - The link copied can now be pasted into ZAP 1 in the Forward Replies to URL field and click Continue.
Step 26 - Test & Continue will be highlighted (ZAP 1)
*If the test is successful, ZAP 1 is now complete.
*Turn on ZAP 1.
Step 27 - Send a reply to the SMS received.
Click Test Trigger (Zap 2)
*If no reply from mobile is sent, test trigger will fail.
Step 28 - Search apps... for Google Sheets.
Step 30 - Choose your account.
Step 31 - Select Spreadsheet + Worksheet + Number Column.
Step 32 - The Lookup Value can be inserted by clicking the insert data field and selecting Querystring Mobile.
Step 33 - Bottom-up to be marked as True.
*If a phone number is listed more than once, it will use the most recent in the list.
*Should This Step Be Considered a "Success" When Nothing Is Found? To be marked as False.
Step 34 - Test & Continue.
Step 35 - The test will show Successful if the spreadsheet Name and Number columns have data.
*Press + to create the next sequence in this ZAP.
Step 36 - Search apps... and enter Google Sheets.
Step 39 - Select your Spreadsheet + Worksheet + Row from the drop-down menus - Custom field.
Step 40 - Once the sheet details have been entered, the named columns will appear (Columns named in Step 10).
Step 42 - Test & Continue.
Step 43 - If the test is successful, columns A,B & C will contain data.
Step 44 - Verify the Spreadsheet to confirm it has data from the SMS reply.
Step 55 - Turn on Zap and click the + to create the next sequence.
Step 56 - Search for Burst SMS in Search apps...
Step 59 - 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 61 - 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 63 - The Custom Webhook URL will be generated, this link needs to be copied by clicking the Copy function.
Step 64 - The link copied can now be pasted into ZAP 2 in the Forward Replies to URL field and click Continue.
Step 65 - Test & Continue will be highlighted (ZAP 2).
*If the test is Successful, ZAP 2 is now complete.