msg91, Send SMS from google spreadsheet

How to send SMS from Google Spreadsheets SMS is the most powerful marketing medium in the world. And it's very costly as well. To send less than one KB of data you have to spend nearly double the amount that you spend in any other type of advertising channels. Hence effective delivery and tracking of your SMS and subjects are very necessary.

We are giving you tools that will enable your SMS marketing to the next level. Let's dive in.

To get started, install the addon from Gsuite Marketplace. It free to get started and we are also giving 100 free SMS.

You need to get msg91 API key from the msg91 console. You also need to uncheck `ENABLE ADDITIONAL SECURITY` so that Google Addon server where the application is hosted can communicate with msg91 server. You can re-enable this after the addon run completes

There are three ways that you can send SMS to a set of phone numbers.

Same SMS to all phone numbers in the list
Same SMS, but with variables to all phone numbers in the list
Different SMS to each phone number in the list

We use three different strategies to send these three types of SMS. We do all these operations from the add-on sidebar.

The addon expects phone numbers in the first column in your spreadsheet.

Sending the same SMS to a list of users
To send the same SMS to a list of phone numbers,

List all your numbers in column A
Add a message to the sidebar
Click on send

Sending SMS with variables
To send the same SMS but with variables,

List all your numbers in column A
Add a message to the sidebar with variables enclosed in {{double_brackets}}
Add variables to the spreadsheet
Click on send

Send different SMS
To send different SMS to each number.

List all your numbers in column A
Add a message to your spreadsheet. Keep heading of the column as 'message'
Click on send

Now let's see how to get the delivery reports.

If you are using your own msg91 account then follow the below video that describes how to set up your spreadsheet to get delivery reports. Please see the same below. It may look complicated, but its not. if you are facing any issue, please get in touch with us.

To get the delivery report just write "=deliveryreport('phone number or cell-address', 'message_id or cell-address')"

Videos

Installing add-on.

Setting up the spreadsheet.

Sending messages.

Sending messages with variables.

Getting delivery reports.

Setting up delivery report.

Adding code to capture the delivery report.

Creating a Google App Script to record.

Getting the delivery report.

Need help? Send a message to addon@elifent.tech