# Free push notifications Workaround **URL:** \ **Category:** Community Resources\ **Tags:** tutorial\ **Created:** [March 31, 2020, 3:25am UTC](https://community.glideapps.com/t/free-push-notifications-workaround/6183 "2020-03-31T03:25:35Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [March 31, 2020, 3:25am UTC](https://community.glideapps.com/t/free-push-notifications-workaround/6183/1 "2020-03-31T03:25:35Z")
I have a solution for PUSH NOTIFICATIONS. It works with IOS and ANDROID. It is quick and has ZERO cost to everyone. You can do this in your google sheet or a separate sheet that is linked to your original (I used 4 linked sheets, I’ll explain later). 1st you setup on your sheet a variable or value you are wanting to trigger the notification. This data will need a VLOOKUP formula to link to the person you want notified’s phone number and phone carrier, so when the vlaue on the sheet is found using VLOOKUP it will display next to it the phone number and carrier. A text message can be sent using email addresses as long as you know the carrier email setup. I will list these at the end of this so you know how to setup your VLOOKUP to find the right one. Next to these cells you need a cell that combines the 2 cells(ex. [5551234567@txt.att.net](mailto:5551234567@txt.att.net)). Second link the data to another Google Sheet using IMPORTRANGE. the data you link is going to be the variable(s) you are wanting notifications to be triggered by. On this same sheet you will have the above mentioned combined email address displayed (when its really a text address). Now that we isolated the person we wanted to send a message to we can setup a message in the same manner using VLOOKUP or we can setup a default message in the Google Script. Open up Scripts and use this script. Now keep in mind you can customize this to work on the same Google Sheet you App resides in but I chose not to because google limits 500 emails per day per account…so I made 4 dummy accounts for 2k notifications per day /\*\* - Sends emails with data from the current spreadsheet. \*/ function sendEmails() { var sheet = SpreadsheetApp.getActiveSheet(); var startRow = 2; // First row of data to process var numRows = 2; // Number of rows to process // Fetch the range of cells A2:B3 var dataRange = sheet.getRange(startRow, 1, numRows, 2); // Fetch values for each row in the Range. var data = dataRange.getValues(); for (var i in data) { var row = data[i]; var emailAddress = row[0]; // First column var message = row[1]; // Second column var subject = ‘Sending emails from a Spreadsheet’; MailApp.sendEmail(emailAddress, subject, message); } } With a few modifications you can set it up anyway you want really. Here is the carrier list I have compiled so far. |ALLTELL| @txt.att.net| |ATT| @tmomail.net| |BOOST| @vtext.com| |C-SPIRE| @messaging.sprintpcs.com| |CINGULAR (ATT)| @vtext.com| |CONSUMER CELLULAR| @vmobl.com| |CRICKET| @mmst5.tracfone.com| |GOOGLE FI| @smtext.com| |METRO| @mailmymobile.net| |MINT| @vtext.com| |PAGE| @mymetropcs.com| |RED POCKET| @sms.myboostmobile.com| |REPUBLIC WIRELESS| @txt.att.net| |SIMPLE| @text.republicwireless.com| |SPRINT| @msg.fi.google.com| |STRAIGHT TALK| @email.uscc.net| |TING| @message.ting.com| |TMOBILE| @mailmymobile.net| |TRACFONE| @cspire1.com| |US CELLULAR| @vtext.com| |VERIZON| @message.Alltel.com| |VIRGIN| @vtext.com| |XFINITY| @cingularme.com| And there you have it. Free notifications for anything in your app you need them for ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [March 31, 2020, 3:49am UTC](https://community.glideapps.com/t/free-push-notifications-workaround/6183/2 "2020-03-31T03:49:43Z")
> [@Notification push](https://community.glideapps.com/t/notification-push/856/9): > > Thanks for the tip. Just one thing on your carrier list. Is everything aligned properly? Just spot checking a few and it seems like the carrier doesn’t always match the text domain. For example, I’m pretty sure Verizon is vtext, but it’s showing as Alltel. I could be wrong, but it looked odd to me. ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [March 31, 2020, 1:28pm UTC](https://community.glideapps.com/t/free-push-notifications-workaround/6183/3 "2020-03-31T13:28:31Z")
Yes, I’m sorry. A few are misaligned. I copied them out of my excel document and they didnt format correctly. Heres the list fixed: |ALLTELL| @message.Alltel.com| |ATT| @txt.att.net| |BOOST| @sms.myboostmobile.com| |C-SPIRE| @cspire1.com| |CINGULAR (ATT)| @cingularme.com| |CONSUMER CELLULAR| @mailmymobile.net| |CRICKET| @txt.att.net| |GOOGLE FI| @msg.fi.google.com| |METRO| @mymetropcs.com| |MINT| @mailmymobile.net| |PAGE| @vtext.com| |RED POCKET| @vtext.com| |REPUBLIC WIRELESS| @text.republicwireless.com| |SIMPLE| @smtext.com| |SPRINT| @messaging.sprintpcs.com| |STRAIGHT TALK| @vtext.com| |TING| @message.ting.com| |TMOBILE| @tmomail.net| |TRACFONE| @mmst5.tracfone.com| |US CELLULAR| @email.uscc.net| |VERIZON| @vtext.com| |VIRGIN| @vmobl.com| |XFINITY| @vtext.com| Thanks for the heads up. ---
**Author:** ![Hemmings](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hemmings/32/3799_2.png) [@Hemmings](https://community.glideapps.com/u/Hemmings)\ **Post date:** [March 31, 2020, 4:22pm UTC](https://community.glideapps.com/t/free-push-notifications-workaround/6183/4 "2020-03-31T16:22:02Z")
@Drearystate awesome stuff! how did you get the carrier information? I’m based in the UK and would like to get this started with our carriers over here. Any thoughts? Thanks in advance ---
**Author:** ![Avery\_Rawlek](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/avery_rawlek/32/1694_2.png) [@Avery\_Rawlek](https://community.glideapps.com/u/Avery_Rawlek)\ **Post date:** [March 31, 2020, 6:31pm UTC](https://community.glideapps.com/t/free-push-notifications-workaround/6183/5 "2020-03-31T18:31:46Z")
Google search to find the sms-email address locally Couple things to remember. 1. Apps script limit of emails per day is 100 for basic Gmail. 2. You can send emails to all the local carriers for each number if you prefer, without knowing the person’s specific carrier. You may have to weed down the list of carriers a bit to find the main ones. (Example. In Canada, Telus owns Koodo, so the sms-to-email for either of these will work if you’re with Koodo or Telus. So only need to include Telus email address, if that makes sense) ---
**Author:** ![Hemmings](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hemmings/32/3799_2.png) [@Hemmings](https://community.glideapps.com/u/Hemmings)\ **Post date:** [April 3, 2020, 7:09pm UTC](https://community.glideapps.com/t/free-push-notifications-workaround/6183/6 "2020-04-03T19:09:56Z")
Great thanks! Will look into it ---
**Author:** ![onepixelman](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/onepixelman/32/130_2.png) [@onepixelman](https://community.glideapps.com/u/onepixelman)\ **Post date:** [April 14, 2020, 12:37am UTC](https://community.glideapps.com/t/free-push-notifications-workaround/6183/7 "2020-04-14T00:37:19Z")
This is super cool. Is there any way you could make a screen recording of how you set it up? That would make it so much easier for us to implement. Thanks! ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [April 14, 2020, 12:58am UTC](https://community.glideapps.com/t/free-push-notifications-workaround/6183/8 "2020-04-14T00:58:28Z")
Great stuff. Very creative. Tx. ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [April 14, 2020, 9:55pm UTC](https://community.glideapps.com/t/free-push-notifications-workaround/6183/9 "2020-04-14T21:55:28Z")
I’m sorry. I’ve been away for a little bit. I will make a video here within the next couple of days. ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [April 14, 2020, 9:57pm UTC](https://community.glideapps.com/t/free-push-notifications-workaround/6183/10 "2020-04-14T21:57:37Z")
Yes, GMAIL does limit the amount of email that can be sent out per account per day. I took this into consideration and created multiple accounts and just used google sheets IMPORTRANGE function on all accounts to account for as many notifications I may need per day. I will also update my carrier list if anyone has additional carriers to list in here. I am from the states and do not know of many other carriers butwould be happy to add them. ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [April 14, 2020, 9:58pm UTC](https://community.glideapps.com/t/free-push-notifications-workaround/6183/11 "2020-04-14T21:58:44Z")
I will look up UK carriers for you and add them to this list. Sorry for the delay, this Virus has taken people from me and I have yet to jump back into Glide, but I will be back on here soon. ---
**Author:** ![Sandro\_Brito](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sandro_brito/32/552_2.png) [@Sandro\_Brito](https://community.glideapps.com/u/Sandro_Brito)\ **Post date:** [April 15, 2020, 4:28pm UTC](https://community.glideapps.com/t/free-push-notifications-workaround/6183/13 "2020-04-15T16:28:15Z")
This is amazing. Looking forward to the video. ---
**Author:** ![Hemmings](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hemmings/32/3799_2.png) [@Hemmings](https://community.glideapps.com/u/Hemmings)\ **Post date:** [April 16, 2020, 4:57pm UTC](https://community.glideapps.com/t/free-push-notifications-workaround/6183/14 "2020-04-16T16:57:51Z")
> [@Drearystate](#): > > I will look up UK carriers for you and add them to this list. Sorry for the delay, this Virus has taken people from me and I have yet to jump back into Glide, but I will be back on here soon. sorry to hear. there’s no rush I myself haven’t been able to get on to glide. thanks for list. let me know if you need anything. ---
**Author:** ![Ken](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ken/32/4483_2.png) [@Ken](https://community.glideapps.com/u/Ken)\ **Post date:** [April 16, 2020, 10:43pm UTC](https://community.glideapps.com/t/free-push-notifications-workaround/6183/15 "2020-04-16T22:43:31Z")
Thanks for sharing this. Very helpful ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [April 19, 2020, 3:48am UTC](https://community.glideapps.com/t/free-push-notifications-workaround/6183/16 "2020-04-19T03:48:56Z")
FYI…this is a functional on iOS. Building this into my next app using VLookups to merge phonenumber/carrier data and Zapier (new Row -\> Email). Thanks for the idea! ![ScreenFlow](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/1/1c274ecb550e70e69a3de1270ee318ac5ceb252e.gif) ---
**Author:** ![ivan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ivan/32/4057_2.png) [@ivan](https://community.glideapps.com/u/ivan)\ **Post date:** [April 20, 2020, 1:27pm UTC](https://community.glideapps.com/t/free-push-notifications-workaround/6183/17 "2020-04-20T13:27:10Z")
Wow, its awesome, how to do that? ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [April 20, 2020, 1:44pm UTC](https://community.glideapps.com/t/free-push-notifications-workaround/6183/18 "2020-04-20T13:44:12Z")
All you need to do is concatenate the phone number (prefix) with the carrier address (suffix) in the sheet (not data editor). Create a new Zapier zap that sends an email to that concatenation when a new row is added to the sheet. ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [April 30, 2020, 3:00am UTC](https://community.glideapps.com/t/free-push-notifications-workaround/6183/19 "2020-04-30T03:00:51Z")
You can do this without getting zapier involved and prevent thje additional coding. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [April 30, 2020, 4:49am UTC](https://community.glideapps.com/t/free-push-notifications-workaround/6183/20 "2020-04-30T04:49:46Z")
Care to explain? ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [April 30, 2020, 6:04am UTC](https://community.glideapps.com/t/free-push-notifications-workaround/6183/21 "2020-04-30T06:04:18Z")
the same way i did above [Next page](https://community.glideapps.com/t/free-push-notifications-workaround/6183.md?page=2)