# 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:** 5
**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:** [October 29, 2020, 2:55pm UTC](https://community.glideapps.com/t/free-push-notifications-workaround/6183/83 "2020-10-29T14:55:53Z")
Glad I could help. ---
**Author:** ![kingzy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kingzy/32/15690_2.png) [@kingzy](https://community.glideapps.com/u/kingzy)\ **Post date:** [November 4, 2020, 4:00pm UTC](https://community.glideapps.com/t/free-push-notifications-workaround/6183/84 "2020-11-04T16:00:19Z")
This is amazing, any idea how to obtain a similar list for Carriers from South East Asia? ---
**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:** [November 5, 2020, 2:48pm UTC](https://community.glideapps.com/t/free-push-notifications-workaround/6183/85 "2020-11-05T14:48:03Z")
I looked previously for carriers outside of the ones listed but I have had little luck. Using Google and a couple of hours of searches allowed me to make the current list we have. If anyone else has any additional carriers that they are aware of please let me know. I would love to make this list as complete as possible. ---
**Author:** ![Daniel\_Jimenez\_Peral](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/daniel_jimenez_peral/32/15655_2.png) [@Daniel\_Jimenez\_Peral](https://community.glideapps.com/u/Daniel_Jimenez_Peral)\ **Post date:** [November 5, 2020, 4:37pm UTC](https://community.glideapps.com/t/free-push-notifications-workaround/6183/86 "2020-11-05T16:37:00Z")
Thanks for this Drearystate! I’m spain, does this work here? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [November 5, 2020, 4:57pm UTC](https://community.glideapps.com/t/free-push-notifications-workaround/6183/87 "2020-11-05T16:57:36Z")
As long as you find the email format of carriers I think you’re good to go. ---
**Author:** ![alfonso\_ayala](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alfonso_ayala/32/10862_2.png) [@alfonso\_ayala](https://community.glideapps.com/u/alfonso_ayala)\ **Post date:** [November 5, 2020, 6:40pm UTC](https://community.glideapps.com/t/free-push-notifications-workaround/6183/88 "2020-11-05T18:40:34Z")
alguien sabe los de mexico o donde buscarlos?? ---
**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:** [November 5, 2020, 9:45pm UTC](https://community.glideapps.com/t/free-push-notifications-workaround/6183/89 "2020-11-05T21:45:04Z")
Would you believe this post has more views than any other user post and only falls short as the most views behind just 4 other posts on this community that are Glide announcements 🙂 I am glad I have been able to help as many of you as I have . ---
**Author:** ![PabloMFalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablomfalero/32/31166_2.png) [@PabloMFalero](https://community.glideapps.com/u/PabloMFalero)\ **Post date:** [November 15, 2020, 9:46pm UTC](https://community.glideapps.com/t/free-push-notifications-workaround/6183/90 "2020-11-15T21:46:26Z")
Hey @Robert_Petitto and @Drearystate, for either of your solutions, I’m guessing that you need to know each number’s carrier, i.e. it won’t be detected automatically, right? or am I wrong? Cuz if it doesn’t detect the carrier automatically, this would mean that the user would have to let you know their carrier…?? Thank you both! ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [November 15, 2020, 10:44pm UTC](https://community.glideapps.com/t/free-push-notifications-workaround/6183/91 "2020-11-15T22:44:24Z")
Yeah, there are few services out there to detect a number’s carrier though. ---
**Author:** ![PabloMFalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablomfalero/32/31166_2.png) [@PabloMFalero](https://community.glideapps.com/u/PabloMFalero)\ **Post date:** [November 15, 2020, 11:12pm UTC](https://community.glideapps.com/t/free-push-notifications-workaround/6183/92 "2020-11-15T23:12:25Z")
Cool, I’ll look that up. Thanks for the info ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [November 15, 2020, 11:32pm UTC](https://community.glideapps.com/t/free-push-notifications-workaround/6183/93 "2020-11-15T23:32:14Z")
One example is [https://freecarrierlookup.com/'s](https://freecarrierlookup.com/'s) API but not sure it supports all countries. ---
**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:** [November 15, 2020, 11:51pm UTC](https://community.glideapps.com/t/free-push-notifications-workaround/6183/94 "2020-11-15T23:51:37Z")
Yup! Didn’t you write an API script for me at one point @ThinhDinh ? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [November 15, 2020, 11:54pm UTC](https://community.glideapps.com/t/free-push-notifications-workaround/6183/95 "2020-11-15T23:54:02Z")
Yeah true Bob, @PabloMFalero here’s what numverify’s API returned fyi. > [@Free push notifications Workaround](https://community.glideapps.com/t/free-push-notifications-solved/6183/76): > > Quick look for people on what it can return. ---
**Author:** ![PabloMFalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablomfalero/32/31166_2.png) [@PabloMFalero](https://community.glideapps.com/u/PabloMFalero)\ **Post date:** [November 16, 2020, 7:43pm UTC](https://community.glideapps.com/t/free-push-notifications-workaround/6183/96 "2020-11-16T19:43:37Z")
For now I only need the US, so as long as it works there I’m cool ---
**Author:** ![PabloMFalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablomfalero/32/31166_2.png) [@PabloMFalero](https://community.glideapps.com/u/PabloMFalero)\ **Post date:** [November 16, 2020, 7:46pm UTC](https://community.glideapps.com/t/free-push-notifications-workaround/6183/97 "2020-11-16T19:46:09Z")
I saw this, but as Robert says: > [@Robert\_Petitto](#): > > How in the world did you do that so fast?! You are a wizard 😂 😂 Thanks again to both of you!! ---
**Author:** ![PabloMFalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablomfalero/32/31166_2.png) [@PabloMFalero](https://community.glideapps.com/u/PabloMFalero)\ **Post date:** [November 17, 2020, 2:50pm UTC](https://community.glideapps.com/t/free-push-notifications-workaround/6183/98 "2020-11-17T14:50:16Z")
=ImportJSON(“[http://apilayer.net/api/validate?access\_key=MY\_API\_KEY&number=14158586273&format=1](http://apilayer.net/api/validate?access_key=MY_API_KEY&number=14158586273&format=1)”) Hey guys, so I’ve created the script, and it all works fine. I get various options for IMPORTJSON, this is the one I’m using, but I guess is not the correct one. I do get a return with this formula, however, what I want to do is, instead of entering the number manually, select the cells where the phone numbers are, but if I do that, it returns an error. Unfortunately, I’m not a wizard, like @ThinhDinh, What am I doing wrong? Am I choosing the incorrect ImportJSON? These are the options I have: ImportJSON ImportJSONViaPost ImportJSONBasicAuth ImportJSONFromSheet ImportJSONAdvanced Once again, thank you so much, and sorry for asking too many questions ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [November 17, 2020, 2:58pm UTC](https://community.glideapps.com/t/free-push-notifications-workaround/6183/99 "2020-11-17T14:58:37Z")
`=ImportJSON("http://apilayer.net/api/validate?access_key=MY_API_KEY&number="&A2&"format=1”)` Assuming you store your number in column A. ---
**Author:** ![PabloMFalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablomfalero/32/31166_2.png) [@PabloMFalero](https://community.glideapps.com/u/PabloMFalero)\ **Post date:** [November 17, 2020, 3:01pm UTC](https://community.glideapps.com/t/free-push-notifications-workaround/6183/100 "2020-11-17T15:01:12Z")
Thank you so much @ThinhDinh. You are a true wizard and a greater helper!!! 😀 😀 ---
**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:** [December 10, 2020, 3:00pm UTC](https://community.glideapps.com/t/free-push-notifications-workaround/6183/102 "2020-12-10T15:00:43Z")
@ThinhDinh, I am grateful you have continued to help to improve on this thread long after it’s original post. ---
**Author:** ![gp9293](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gp9293/32/16743_2.png) [@gp9293](https://community.glideapps.com/u/gp9293)\ **Post date:** [December 16, 2020, 12:02pm UTC](https://community.glideapps.com/t/free-push-notifications-workaround/6183/103 "2020-12-16T12:02:08Z")
Great stuff you post, thank you. My problem is that Zapier does not see vlookup fields. I am creating a transaction record and want the phone numbers of the buyer and seller to be included. Setting a relation to Profiles and pulling the phone numbers in with vlookups works fine. But Zapier does not see the vlookup fields. Any ideas are appreciated. [Previous page](https://community.glideapps.com/t/free-push-notifications-workaround/6183.md?page=4) [Next page](https://community.glideapps.com/t/free-push-notifications-workaround/6183.md?page=6)