[Hack] Want To Send SMS in Salesforce? Find Out How We Avoided Expensive Apps By Using Zapier And MessageBird

21/04/2021
5 mins

Like many businesses we have a need to send and receive SMS with our clients whether that be to engage them with our service, organise a time to speak or to send passwords for sensitive documentation.

We already have a VoIP phone system built into our Salesforce CRM but there was no SMS functionality. I spent some time looking for a 3rd party application but I couldn’t find a solution that met the following criteria:

  • Utilise the existing activity object in Salesforce to be able to report as part of our advisers’ activities
  • Two way communication between client and adviser
  • A look and feel like the native Salesforce user experience
  • Support automation based on triggers in Salesforce
  • Support SMS templates
  • Inexpensive implementation including no additional per user subscription cost.

Some of the applications felt like they were just bolted on to Salesforce with little integration while others were requiring a significant additional cost per user and still didn’t quite meet our needs.

In the end I couldn’t find a solution that worked for us so, with a good working knowledge of Salesforce and Zapier, I started piecing together a process to develop the existing activity functionality in Salesforce to support inbound and outbound SMS.

5 hours later we had a fully integrated solution that just needed some good old fashioned testing 💪

Do It Yourself SMS Functionality in Salesforce

First of all we will build out outbound functionality which allows our advisers to send personal or templated SMS messages to their clients simply by creating a task in Salesforce.

Step 1 : Build Out an SMS Specific Activity Record Type

Utilising the existing standard Activity object in Salesforce I built out a new record type and stripped it right back to a basic set of fields that would be required to send an SMS.

salesforce sms record type

You will want to create a workflow which fires on creation of an SMS activity which sends an outbound message from Salesforce to an endpoint in Zapier.

outbound sms from salesforce to zapier

Step 2 : Build a Zap to Catch an Outbound XML from Salesforce

In Zapier you will want to build a zap to catch an outbound xml call from Salesforce and then pass that information into MessageBird to translate the activity fields into an SMS and send on to the intended recipient.

zapier to message bird

When you have it working correctly you should have a completed task in Salesforce documenting the outbound message as well as a text message on your phone 👍.

sms outbound activityreceived sms from messagebird

Step 3 : Managing Replies. Send Inbound Messages to Zapier from MessageBird

MessageBird is a brilliant platform that now does a lot more than SMS including voice and other communication channels. They have recently built out a useful visual flow builder which can help with automation.

The first thing you will want to do is push any new messages from MessageBird to a Zapier webhook.

messagebird to zapier flow

Step 4 : Inserting the Inbound SMS into Salesforce as an Open Task

It gets a little more complicated here particularly if you are using both Lead and Contact objects in Salesforce. If you have records across both objects you will need to query both to find the record related to the mobile number you received the reply from.

For the purpose of this example I am only referencing Contacts but it is exactly the same process for Leads. Either way the cleaner your data and the less duplication you have in Salesforce the better.

Once Zapier has received the inbound message there is a bit of work to update the string which is sent from MessageBird to match the format of the mobile number we have in Salesforce. Once we know it has been structured correctly to make a positive match we find the Contact record in Salesforce with that mobile number.

With access to the relevant Salesforce record we create an open task for the adviser who is associated with that Contact which includes the body of the SMS whilst also sending them an email alert for good measure to let them know they have an inbound SMS waiting for them.

zapier inbound sms workflow

When everything is working correctly you should see an open activity in the Contact record in Salesforce waiting to be actioned by the record owner 😎.

inbound sms activity salesforceinbound sms from iphone

Immediate adoption and improved engagement

The introduction of our SMS functionality into our Salesforce environment was a big success. Where the functionality is native to Salesforce the adoption among our advisers was instant and having another channel to communicate with our clients has resulted in an increased level of engagement.

If you are looking to replicate in your organisation and need some guidance you can pop me a message on linkedin.

About Drewberry

Our goal is simple: to improve our clients’ financial wellbeing.

We help our clients take control of their finances by building lasting relationships where we support them to make informed decisions.

We provide financial advice services to individuals and businesses throughout the UK. Whether it’s setting up personal insurance to protect your lifestyle, managing your pensions, investments and other assets to improve your financial future or setting up employee benefits for a company, we’re here to help.

Contact Us

Head Office & Pensions and Investments
Senator House
85 Queen Victoria Street
London
EC4V 4AB
Personal Insurance & Accounts Payable
Telecom House
125-135 Preston Road
Brighton
BN1 6AF
Drewberry London Office MapDrewberry Brighton Office Map

If you are unhappy with our service, we have a complaints procedure, details of which are available upon request. If you are unhappy with how your complaint has been dealt with, you may be able to refer your complaint to the Financial Ombudsman Service (FOS). The FOS website is www.financial-ombudsman.org.uk.

Drewberry Ltd is registered in England and Wales. Companies House No. 06675912

Drewberry Ltd registered office: Telecom House, Preston Road, Brighton, England, BN1 6AF. Telephone 0208 432 7333

Drewberry Ltd (Financial Conduct Authority No. 505473) is an Appointed Representative of Quilter Wealth Limited and Quilter Mortgage Planning

Limited, which are authorised and regulated by the Financial Conduct Authority.

Cookies

Drewberry™ uses cookies to offer you the best experience online. By continuing to use our website you agree to the use of cookies including for ad personalization.

If you would like to know more about cookies and how to manage them please view our privacy & cookie policy.

Deny
Approve