โ About
In many customer usecases, people need to send SMS in a batch mode... for a very wide amount of business cases.
๐ญ ERP Integration considerations and csv
Customer data can be managed through an endless list of ERP/CRM and middlewares (relational databases, ETL jobs,...), including hand-made solutions and Spreadsheets, etc...
โ๏ธ Still, at some point, they all may need to notify their customers on a regular or event driven basis (birthdays, fidelity points, special events, emergency, dates,...).
What all these people do is an export of :
1๏ธโฃ The customer phone number
2๏ธโฃ The custom message to send
This is exactly what this feature is about.
We need to send that data to your customer thanks to a simple csv
as :
โ๏ธ They are easy to produce on any language and any platform/middleware
โ๏ธ There are a lot of ready to use automation tools (Power Automate, Zapier, IFTTT,...) around them
๐๏ธ Input data : the csv
The input can come from any spreadsheet :
... then exported to csv
:
to,message
+687XXXXXX,"Hey Jack, All work and no play makes Jack a dull boy."
+687XXXXXX,"Today is your birthday, come to our shop to enjoy your discount."
+687XXXXXX,"Come enjoy black friday tomorrow morning!"
+687XXXXXX,"Yoy now have 1000pts. on your fidelity card, come enjoy discount today"
+687XXXXXX,"Your command has been delivered and awaits for you at the postoffice"
Next, to send the csv
, just :
opt-sms send -f "${SHORT_NUMBER_CODE}"\
-c "${ACCOUNT}"\
-i "~/demo_batch_sms.csv"
And you're done.
Now... enough talk, let's enjoy the demo!
๐ฟ Demo