๐Ÿšš SMS batch sending with csv input

adriens - Sep 1 '22 - - Dev Community

โ” 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 :

Image description

... 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"
Enter fullscreen mode Exit fullscreen mode

Next, to send the csv, just :

opt-sms send -f "${SHORT_NUMBER_CODE}"\
    -c "${ACCOUNT}"\
    -i "~/demo_batch_sms.csv"
Enter fullscreen mode Exit fullscreen mode

And you're done.

Now... enough talk, let's enjoy the demo!

๐Ÿฟ Demo

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .