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.