![]() ![]() One other low-tech solution to consider is that spreadsheets have a built-in edit notification under Tools > Notification Rules. If you're not well versed in using APIs, you can instead use MailApp to send e-mail or log any activity in another spreadsheet for tracking purposes. Once you have your service/API selected and set up and have the API Documentation, refer to the following Google Developers page to access the service API with Apps Script. Twilio is a great tool (although not free) or you may find another API that fits your needs based on your region in this list of SMS APIs. If you want to accomplish this sms functionality, you will need to identify a company that offers an SMS/Text messaging API and access the API with a custom script. ![]() Google Apps Script does not have built in functionality for SMS/Text messaging however. Best SMS app for small, local businesses. You will need to define toNumber, bodyMessage, SID, Token, and twilioNumber. Here is some basic code you can use with Twilio if you go that route. From 16/month for the Starter plan with 500 messages sent or received, including one free number additional SMS messages from 0.032. You basically use the spreadsheet to send the request to Twilio and then Twilio sends the messages out. and have it received as an SMS by that phone. Adding a menu or setting up an onEdit even function in a document is pretty straightforward (just a few lines of code depending on the complexity of your application). An SMS service will help you send bulk text messages to existing and potential customers. The sites that send SMS for free usually use the email interface that most of the carriers implement which allow you to send an email to (for instance) .![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |