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 the sheet:

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

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


Step 2: Search SMS Sheet or MSG91, and 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: Log in with MSG91 using Authkey and Email Id or Mobile. You can get Authkey by login into OneAPI Dashboard in MSG91. Enter the validity 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 a 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 steps 5 and 6 above for the 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 a 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 ticked, 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. 


Headings