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.