***Please note that Integromat evolved into Make in February 2022. All content for Integromat is also valid for Make.***

The Problem

• A client needed an SMS bot which would ask for a rating  (1-10) via SMS if the previous call with the client lasted more than X seconds.
• On the top of that, based on the collected answer, another SMS needed to be sent to the client.
• The client is using Telebroad phone system which is not yet supported by Integromat.
• The client needs to be able to change the SMS texts whenever they decide to.

The Solution

Since the Integromat does not support Telebroad yet, I had to develop a series of HTTP API calls to get the needed information (inbound calls, inbound SMS, send SMS) from the API. This is one of many great things in Integromat – when something is not supported, you can always make HTTP API calls via their generic HTTP module which lets out literally connect to ANY API.

After having solved the connection problem, there were several other challenges on the way:

• How to make sure the caller does not get the same SMSs over and over
  • The client wants to ask for rating only once per month but the caller can call 10 times per month. I had to build an internal database within Integromat called “Data Store” which is keeping track of incoming calls, incoming SMSs, and outgoing SMSs. Before Integromat sends out SMSs, it always checks whether the conditions for sending are met by querying the Data Store.
• How to make sure a correct phone number is used to send out the SMSs since the client has more phone numbers in place (over 20). Only 3 numbers are part of the project.
  • I had to build an internal database within Integromat called “Data Store” which is keeping track of incoming calls, incoming SMSs, and outgoing SMSs. Before Integromat sends out SMSs, it always checks whether the conditions for sending are met by querying the Data Store.
• How to consume the least possible number of operations.
  • One should always aim to consume the least possible number of operations. In order to do that in this project, I had to setup very specific filters as they scenario progresses and logically place all the modules into the scenario only where they were really needed.
• How to easily give control to the client over the texts of SMSs
  • A simple Google Sheets spreadsheet is storing the templated SMSs which are being pulled by Integromat prior to the sending of SMS

The Scenario

This is how the scenario looks:

Integromat apps used: Set multiple variables, Router, HTTP, Iterator, Phone Number, Data Store, Google Sheets, Gmail, Break

Conclusion

The final scenario is checking for new calls every 5 minutes during business hours.  The scenario sends out roughly 200 SMSs every day and the client is able to collect roughly 30 ratings per day which are stored in a Google Sheets spreadsheet.

The whole project took roughly 10 hours to finish where at least 5 hours were spent on figuring out how to connect to Telebroad’s API which does not have a great documentation (but their support team is quite helpful and responsive).

Do you want to replicate this for your business yourself? 
GO TO MAKE

Or looking for someone to build your integrations?
HIRE ME