Lesson 44: Push Notifications (zapier)

hello guys it's jesus from low code agency and today i want to show you or i'm making this tutorial on how to set up notifications uh it's a recurring issue that you want to send notifications when you have some app or you have service providers and customers and maybe they are interacting with each other inside the app or you set up messages so they can send each other messages in the app but you want both parties to receive a either a text notification in their phones or an email when something happens inside of the app and since we don't have native notifications right now for glide apps then using zapier there is a pretty straightforward and easy way to set up your notifications so that either you as owner of the app or your users like service providers customers whatever will be able to get an email every time something happens inside of the app so let's jump right in what you need is your glide app your google sheet and either a zapier account which is the easiest or an integromet account so what we are looking at right now is at the uber like template uh that we built so in this case we have two types of users either let me show you click here we have either drivers or users right so right now i am logged in as a user then i'm looking at available drivers here so when i click on this driver i see their profile picture their car type their car caller and i can request a service and what that does is we have a form here on the right side with a bunch of information and what that does is it creates a new row in our spreadsheet in our rights tab okay so if we look at this tab at the right step we have the comments here so pick me up whatever then we have the location of the driver we have a unique id we have a timestamp then we have a created by email and we also have the driver's email right because we want to link those two users so in this case let me be somebody else i'm a driver as well so let's choose somebody who is a user now we can have this user so here we go preview s okay so now i am a user and then i look at drivers that are available right now and i found this robert guy right so then i request a service and then we create a form so in this form we have several components we have a comments component we have a location component so when that service goes through the driver knows where he or she has to pick up the user and then we have a bunch of columns here we're bringing over to the forums tab the driver emails email and timestamp unique id and then a created by which is my email as a user and then a couple of other columns so if i remember correctly this guy was robert okay so let's say robert i am at the corner of this location and then i'm sharing my current location and then i click submit so on the back end on our data editor or uh in our google sheet we created just this row okay so now we have to go and set up our zap so what we want to do is we want to connect since we are doing email notifications right now we want to connect our google sheet to a emailing tool so google sheets here two we can choose either yeah let's choose gmail here we go and then what is a trigger when this happens then do this so when something happens in our google sheet then we want to send an email right so the trigger is when there is a new row so we'll look for that new or updated spreadsheet row then send an email so when there is a new row because every time here in our client every time a user asks for a service from one of the drivers it creates a row in our goal sheet right so that's the the trigger and then what we want to do is send an email so then we use this app you have to create a zap your free account for this so first thing is when we have a new or updated spreadsheet row in our goal sheet so now we have to tell zapier which google sheet we're talking about so first you have to connect your gmail or google drive account to zapier and then i'm gonna look for the spreadsheet so the spreadsheet's name is uberish so here we have it and then i want to tell zapier on which tab of my google sheet it should look for that new row and the worksheet is the rights tab right the right tab here this tab in my google sheet is where zapier will be looking for new rows and then the trigger yeah any column is fine trigger column yeah it doesn't even matter because all of them are updated but let's choose let's not choose the comments because maybe they might not share something but we have always somebody's emails now zapier wants to test the trigger so it brings over in this case the sixth row which is the one we just created right so we are looking here at the column a all the way to column j same thing we are looking at here right a b c d e f g h i j right so zapier is looking at this and it's bringing over so we can play around with this information in our email okay so since that is working then we will we will connect our already have we already chose our gmail account then the action will be to send an email so i'll use my personal account to send those emails so you'll probably have to set up that as well connect your gmail account or your hotmail yahoo whatever account and then we'll customize the email so who do we want to send that email to we want to send that email to the driver in this case right because the user is requesting a service and unless that driver is already logged into the app and looking or refreshing the app to see who has requested for their service since we're going to assume that the driver is not checking the app all the time we want to send them an email or a text reminder that we'll go over that later we want to send them right now an email to the driver that there's a new service request so the tool i mean we'll we'll that that email will go to the column email driver right so every time we have a new row a new row here the email will go to this value to the value we have on the email driver column that way you don't have to set multiple zaps you just set one zap pointing to the right column so in this case we want to send an email to this guy to the driver right so we choose the value from our spreadsheet which is email driver then you can like cc or bcc somebody else maybe yourself you want to know who is emailing or how's it working on the back end and then from your own email account you can either choose your name or not you can add a reply to so maybe in this case we want the um driver in case he he or she replies back maybe we want them to reply to the user so the user is the created by column so if that driver answers that email that email will go back to the user then for subject so with zapier we can use two things either text so hello here or we can choose any of those values from that row we're looking at so let's say driver you have a new service and then on the body we'll say hey there someone requested a service from you and then we can tell them location so we'll use the user's location which in this case is the latitude and the longitude the coordinates we can also let them know the comments so message from from customer then we'll add the comments column we can also share the timestamp requested at timestamp and for more information open your app and then we're going to add the link which is uberiche.collidab so now we have the body of our mess of our email so this value will be specific for every new row right then we can either choose a signature or not or an attachment whatever it doesn't matter for this case so now we do a test and continue so a test email was sent to gmail just now in this case it doesn't matter because we don't have that email but now let's let me sign in so that i will get an email right so let's look at our user profiles tab so we have okay so my own personal email has [Music] yeah so let's change actually this way since i already have this here we go so if i log in as this user and this user is a driver so the first thing i have to do here is update my location so that i can pick someone up so i'm available now and don't worry about what's going on here the only thing that i'm doing is in this case allowing users to be able to book this driver so that we'll get a test email and now i will log in as any other user so let's choose user number one so george is a user so he looks at his right step and he's looking at these two drivers we have okay so i want to contact this guy because this guy is my other email right so i want to request the service from jesus so asus notifications work now and then i click i share my current location with him and i click submit so on the back end in our google sheet and our data editor what we created is a new row now this zap is already on so let's see if we got that email let me refresh this and here we go so look at i mean don't worry about this because this is the dummy email from the user right so i am getting an email as if i was the driver hey there someone request so driver you have a new service remember we added that to the subject of our email location so you can add this i mean in this case you can add this this text to your google maps and then it'll show up where the user is and then we have a message from the customer hey i am this corner i am at this location for more information open up your app so that's a very easy way to set up your notifications in your app and you can use them for pretty much anything every time you create a new row you can set up notifications the important thing for that is to bring over to that form that you are creating every time someone clicks this button it's creating a form and you are bringing over so in this case i'm looking at his profile as a driver right so when i request a service from him i am bringing over the column that has this driver's email and i am also adding a special value which is the email of the user requesting that the service from this driver so that's really important because now you have both values in your tab you have customers and you have the service providers and this is the way we set up all apps and templates when we have either one-on-one chats or these kind of forms where you want users to interact between each other either in the app or in this case i mean i get asked a lot why am i always using the created by the the either i mean both the timestamp the unique id and the special value which is the user's email because now we can do these cool things we can get notifications now the other thing that you could do is instead of when there's a new row send an email you could also instead of this second step being email you could send a text notification for that you would do exactly the same thing but instead of bringing over or on top of bringing over the driver's email you would also bring over into a new column his or her phone now for that you would use a tool called twilio sms or sms by zapier or twilio right so twilio it's pretty much as straightforward as um it's an email so we have just a couple options you connect your twilio account i have already done that then send us a mess and then the only thing you'll do is point your zap so from number i already have a number and you have to set that up when you create your twilio account and then the two number will be the column where you bring over using a column component like as a special value where you bring over the driver's phone or the user's phone and then the message again same thing with email you can add whatever components whatever columns from that row from that new row so whatever i just send by email you could also be able to send this as a text and then it's enlarged message so you'll mark this as yes in case it goes over the character limits and that's it so you can do this by email or by text as easy as that using zapier so i hope this works for you if you have questions you can let me know thanks for watching

Channel: Jesus Vargas

Views: 2,146

Keywords: glide apps, no code, low code

Id: tqc0zRO5pDk

Length: 18min 7sec (1087 seconds)

Published: Wed Dec 16 2020