Sending SMS Alerts via Google Sheets

Google Apps Script can send email messages through Gmail but uses a workaround for sending SMS text messages. It creates an event in your default Google Calendar with an SMS reminder  – the event is set to expire in 30 seconds and thus you get an instant text alerts on your mobile.

Also see: Get SMS Alerts for Important Gmail Messages

*The SMS option is however only available to Google Apps for Work accounts. If you aren’t getting text alerts on your phone, please ensure that your phone number is associated with Google Calendar as detailed in this tutorial.