You can use SMS messaging to send marketing campaigns, customer notifications, invitations, and much more. Use the Toky bulk SMS sender add-on to send text messages to customers around the world, from a Google spreadsheet.
What do you need to send SMS?
To send an SMS using Toky, you must have:
-
A paid Toky plan
How to configure Toky bulk SMS add-on
1. After installing the add-on from Google Workspace Marketplace, open the Add-on and click on Bulk SMS Sender (if you can’t find it, try refreshing the sheet):

2. On the sidebar you will see the Toky SMS sender tool. Click on the API Key title to add your Toky API Key to the required field. You will find the key in this link.

3. After entering the right API key, the Not configured label will disappear and the SMS phone numbers list will be loaded. Click on Bulk SMS process.

4. Select the phone number to be used to send the SMS message.
Preparing the Google Spreadsheet to send SMS
Select a blank Sheet from your Google Spreadsheet:
-
Click on Tools and Generate Columns . You'll see three separate columns on the first row: Phone Number, Message and Status
-
On the Phone number column add the mobile phone numbers where you want to send your text messages. The phone numbers must have a country code.
-
On the Message column write the message to be sent. You can customize the SMS message for every phone number and you can even use Google Sheets formulas to do that.
-
Leave the Status column blank.
-
After adding the phone numbers and messages click on the Send SMS button

After clicking on the button, the add-on will start sending SMS. On the status column you will see:
-
Message sent: The message was sent successfully
-
Error: wrong destination phone number is not a mobile number. You must verify that the phone number is right and with the country code specified
Using templates to send bulk SMS
You can generate message templates easily with Toky Bulk SMS, following these steps:
-
Add custom fields starting in the D1 cell, the titles in this row will be the field names.
-
Click on SMS template option and add the custom text in the text field. You must put your template fields enclosed in brackets; example: {field_name}

-
Click on the Generate button to convert the template into formula. In the cell B2 the formula will be also copied to the cells below.