How to send SMS and Email from Google Spreadsheet?

You can send SMS directly from your Google spreadsheet by using this add-on without switching back and forth to the panel. This add-on is introduced to save your time and help you to send SMS efficiently to all your contacts from the sheet itself.

Follow the below-mentioned steps to send SMS directly by using sheet:

Install the SMS Sheet add-on from MSG91 in Google spreadsheet

Step 1: Click on Extension, hover to Add-ons section, and click on Add-ons section, and click on Get add-ons.


Step 2:
Search SMS Sheet or MSG91, click on it.


Step 3: Install
the add-on.

For Sending SMS:

Step 4: Click on Extension and hover to MSG91 and select Transactional SMS.

Note: If you are not getting any option when you hover to MSG91 then follow the steps: 17-21


Step 5:
Login with MSG91 using Authkey and Email Id or Mobile. You can get Authkey by login to OneAPI Dasboard in MSG91. Enter the validatidy duration 2hrs/3hrs/4hrs from the drop down and click on Submit.


Step 6:
Enter OTP received in your email id or registered phone.


Step 7
: Select the column in which mobile numbers of recipients are saved.


Step 8
: Select whether to send all the contacts in particular row or specific people and select template ID.


Step 9: Click on Preview and Send SMS.


For Sending Email:

Step 10: Click on Extension and hover to MSG91 and select Transactional SMS


Step 11:
Follow step 5 and 6 above for sign in process.

Step 12: Select the recipient column from To. Also you can select CC and BCC.


Step 13:
Select whether to send all the contacts in particular row or specific people.


Step 14:
Select the necessary details: from which email the recipient should receive, the domain of your company and the name they will be receiving the email from.

Step 15: Choose Email type. (Transactional or Promotional or Notification) and choose the template.

Step 16: Click Send.


If you are not seeing the options in MSG91 Addon

Step 17: Click on Extension, hover to Add-ons and then click on Manage add-ons.


Step 18: Click on the three dots.


Step 19: Select use in this document option

Note: If the option is already tick, then skip this step.

Step 20: Click on Extension, hover to Add-ons and then click on use in this document.


Step 21: Click on the dropdown beside use and select the action: Transactional SMS or Email and then follow the steps as explained above Step 4-15









Still need help? Contact Us Contact Us