WEBVTT 00:00.280 --> 00:00.960 All right. 00:00.960 --> 00:06.600 So welcome everyone in this video which is dedicated for an exercise of this section. 00:06.640 --> 00:09.840 Overall so far we discovered the basics. 00:09.840 --> 00:13.080 I showed you how to create our first ever automation. 00:13.240 --> 00:20.000 And now is the time to practice, to take your actual skills and create a very nice workflow and automation. 00:20.000 --> 00:23.280 And then so with all that being said, let's dive in. 00:23.640 --> 00:28.560 And in general, first of all, let me actually explain you what you need to do in this exercise. 00:28.560 --> 00:33.480 So here I prepared for you the file that you can download in the resources of this material. 00:33.600 --> 00:37.480 And afterwards I will do the entire exercise on my own. 00:37.480 --> 00:42.960 So you can go over there and whenever you have any problem and this automation and you can check it 00:42.960 --> 00:43.960 together with me. 00:44.120 --> 00:47.080 However, let's cover what we have inside our file. 00:47.080 --> 00:51.120 So here you will create your very first, you know, automation. 00:51.120 --> 00:56.320 And then you will practice building an automation that helps you process new client requests. 00:56.480 --> 00:58.880 And here you've got everything explained. 00:58.880 --> 01:03.560 So we've got the trigger which is Google Sheets, set up the workflow to start automatically whenever 01:03.560 --> 01:09.400 a new row is added to your Google Sheet, and the sheet should include name, email, and phone number 01:09.400 --> 01:10.320 and description. 01:10.960 --> 01:12.160 Then we've got the slack. 01:12.400 --> 01:16.000 And right there with this step, we actually notify our team that. 01:16.000 --> 01:16.400 All right. 01:16.440 --> 01:19.320 Hey, um, new client is here. 01:19.600 --> 01:25.360 So we've got add a slack node to send a message to your teams channel asking to handle the client's 01:25.400 --> 01:26.240 request. 01:26.280 --> 01:30.280 The message should should show name, email phone number, description. 01:30.880 --> 01:32.680 And the first step is our Gmail. 01:32.680 --> 01:38.000 So we send thank you email to our client at a Gmail node to send a thank you email to our client. 01:38.000 --> 01:38.640 All right. 01:38.840 --> 01:42.360 And the last step is to add the contact to Google Contacts. 01:42.720 --> 01:49.360 And I need to mention like the purpose of this exercise is to get familiar with how to use it. 01:49.360 --> 01:55.080 And for sure, if you've never created any automation before, it will be very, very helpful because 01:55.120 --> 01:58.200 again, you will see how all of the options work. 01:58.400 --> 02:01.930 So I really encourage you to accomplish this entire exercise. 02:01.930 --> 02:03.370 It's very, very important. 02:03.410 --> 02:04.050 Like this. 02:04.050 --> 02:07.450 Automation and workflow is not sophisticated in the course. 02:07.450 --> 02:15.050 We've got a lot of tons of very complex, very professional business examples that will take for an 02:15.050 --> 02:21.050 example, let's say even like 30 minutes or even 1 hour or 2 hours to set up. 02:21.050 --> 02:24.090 However, um, you know, we need to start with the basics. 02:24.290 --> 02:30.610 If you are new to Nar Den, um, it's great, um, to practice our knowledge and how to use it. 02:30.610 --> 02:33.690 On the most simple example you need to remember. 02:33.690 --> 02:35.530 This course is a masterclass. 02:35.530 --> 02:41.890 So we go just from the basics to the most advanced and, you know, again, and project workflows and 02:41.890 --> 02:42.450 so on. 02:42.890 --> 02:48.290 Um, however, for now, actually, um, you can go over, stop the video, do the entire workflow and 02:48.290 --> 02:51.770 automation on your own and afterwards check it together with me. 02:51.930 --> 02:57.170 So I really encourage you to follow this entire approach, because by this way, you practice and you 02:57.170 --> 03:02.770 get familiar with an AI then and again, um, you just get better with this application? 03:02.930 --> 03:07.730 And with all that being said, let's dive in and let me actually show you how I create this automation 03:07.730 --> 03:08.650 on my own. 03:09.050 --> 03:12.090 So as usual, to begin with, let's start with our trigger. 03:12.090 --> 03:14.410 So we can click here on Add first step. 03:14.690 --> 03:18.650 And right there let's go ahead and we've got application. 03:18.810 --> 03:21.330 So here we've got on app event. 03:21.730 --> 03:28.370 And there you can search for Google Sheets or right away like go over there and search here Google Sheets. 03:29.290 --> 03:30.610 And we've got Google Sheets. 03:30.610 --> 03:34.810 And we would like to trigger this automation whenever we have a new row added. 03:34.810 --> 03:38.090 Also you've got new row added or updated. 03:38.090 --> 03:40.410 So you've got different triggers actions and so on. 03:40.730 --> 03:42.890 However, for now we would like to stick with that. 03:43.850 --> 03:44.490 All right. 03:44.810 --> 03:52.850 And here what's very important we need to create our new Google Sheets inside our Google Sheets. 03:52.970 --> 03:55.530 So here I can provide the following fields. 03:56.050 --> 03:59.370 So I have here the name email phone number and description. 03:59.530 --> 04:00.610 Let me expand that. 04:00.660 --> 04:06.980 And now, even for tracking purposes, let's name it as the customer requests. 04:07.020 --> 04:07.660 All right. 04:07.900 --> 04:09.900 Now let's go ahead to an editor. 04:10.140 --> 04:13.060 And here search for the customer request. 04:13.100 --> 04:13.500 All right. 04:13.500 --> 04:14.260 We've got it. 04:14.740 --> 04:16.340 Let's pick our sheet. 04:16.380 --> 04:17.380 So sheet one. 04:17.660 --> 04:22.980 And here what's very important we need to fulfill our Google Sheets with our data. 04:23.020 --> 04:28.580 Firstly because we need to have, you know, again as we've done it in the previous video with, you 04:28.580 --> 04:34.900 know, forms that are that, that were created with and with the help of an ID then also there we need 04:34.900 --> 04:37.620 to fulfill our Google Sheets. 04:37.620 --> 04:42.700 So here the name, let's say let me provide my data name email. 04:44.300 --> 04:44.780 All right. 04:44.820 --> 04:47.820 Let's provide an email okay. 04:48.220 --> 04:49.260 Phone number. 04:49.620 --> 04:51.260 Let's provide the following format. 04:51.540 --> 04:52.500 So here. 04:53.740 --> 04:54.540 All right. 04:55.820 --> 04:56.660 Um okay. 04:57.100 --> 05:06.540 And then let's provide a description I want to talk about sales and my company and my company. 05:06.620 --> 05:07.260 All right. 05:07.660 --> 05:11.660 Now, what we can do, we can click on the fetch test event. 05:12.220 --> 05:14.500 And this data should appear right here. 05:14.620 --> 05:14.940 All right. 05:14.940 --> 05:17.580 So we've got a name email phone number description. 05:17.580 --> 05:19.740 So we've got our trigger which is set up. 05:20.100 --> 05:21.700 We can go right away. 05:21.700 --> 05:24.060 And what we can do we can click here. 05:24.460 --> 05:27.460 And right now add the slack step. 05:28.100 --> 05:33.500 So here we want to just send um a um a message to our channel. 05:34.500 --> 05:36.300 Um so here we pick the channel. 05:36.780 --> 05:42.900 Um, and there we have our channel which is I of course, remember you need to create the channel previously 05:42.900 --> 05:45.620 and set up the entire, you know, slack channel. 05:45.700 --> 05:50.860 However, this is the disclaimer we've got here, the message and what we need to type inside. 05:50.900 --> 05:51.340 All right. 05:51.340 --> 05:53.420 We need to type the message to our team. 05:53.860 --> 05:55.700 I'm actually new client. 05:55.740 --> 05:58.660 New client is here. 05:59.380 --> 06:00.270 Please This. 06:00.310 --> 06:01.270 Handle that. 06:01.310 --> 06:01.990 All right. 06:02.310 --> 06:03.350 Handle that. 06:04.470 --> 06:06.070 And right there what we need to provide. 06:06.070 --> 06:07.470 Let's go over to expression. 06:07.630 --> 06:10.110 So there I can go over to new to new line. 06:10.550 --> 06:14.910 And right now the name what we have ls the email. 06:15.870 --> 06:22.990 We have the phone number phone number and what we have the description. 06:23.030 --> 06:23.710 All right. 06:24.030 --> 06:24.910 The description. 06:25.350 --> 06:33.950 And again what we can do we can take our data from Google Sheets and fit slack with this data literally 06:33.950 --> 06:35.630 because we take this data. 06:35.630 --> 06:44.350 So this variable and we put it here again we provide an email then the phone number right there and 06:44.390 --> 06:45.350 the description. 06:45.870 --> 06:49.070 After we do this we can test out if this note works. 06:49.070 --> 06:50.510 So we can test the step. 06:51.470 --> 06:56.990 And at the right side you can see we've got our response which is not that clear because this is a schema. 06:57.030 --> 07:00.350 However when we click on table view actually let me show you I. 07:00.350 --> 07:01.310 I don't know if you see that. 07:01.310 --> 07:01.990 All right. 07:01.990 --> 07:03.230 Let me actually show you. 07:03.430 --> 07:10.270 So here you've got in the right top corner, you've got different views, the table JSON schema. 07:10.630 --> 07:12.230 And it works by this way. 07:12.230 --> 07:15.830 And here on the table, you know, looks like this. 07:16.270 --> 07:16.950 All right. 07:17.590 --> 07:20.470 Now what we can do, we can go over right there. 07:20.710 --> 07:21.550 Um yeah. 07:21.670 --> 07:24.830 And create another step which is our Gmail. 07:25.910 --> 07:31.990 Um, and here I can send um, yeah, I can send a message. 07:32.030 --> 07:33.110 Where do we have that? 07:33.990 --> 07:35.910 Um, do we have here? 07:35.950 --> 07:36.470 All right. 07:36.470 --> 07:37.150 We've got here. 07:37.190 --> 07:38.110 Send a message. 07:38.910 --> 07:41.990 Um, I can say send a message to my client. 07:42.270 --> 07:47.310 And right here, um, let me pick the value from, um, there from Google Sheets. 07:47.310 --> 07:48.190 So the email. 07:48.510 --> 07:49.710 So this is the variable. 07:49.710 --> 07:53.030 It changes every time whenever we have our email. 07:53.430 --> 07:53.990 New email. 07:54.030 --> 07:54.470 Yeah. 07:54.510 --> 07:59.110 So here the subject thank you for contacting us. 08:00.910 --> 08:07.950 And there and we've got email type so HTML or either text and we can choose the text like this is only 08:07.950 --> 08:08.510 the form. 08:08.510 --> 08:10.070 So here I can type the message. 08:10.670 --> 08:16.790 Um hey um here and we can type, we can go ahead with the variable which is the name. 08:17.150 --> 08:20.910 So it's great to go and greet the customer, um, with the name. 08:21.350 --> 08:23.750 Thank you for contacting us. 08:24.430 --> 08:29.870 Um, we will share more details with you soon. 08:30.590 --> 08:33.270 Details with you soon. 08:33.270 --> 08:34.350 So just the message. 08:34.350 --> 08:34.790 All right. 08:34.790 --> 08:35.950 It's very simple. 08:36.710 --> 08:38.070 Um, yeah. 08:39.310 --> 08:44.030 Because also we need to remember that, um, like it depends. 08:44.030 --> 08:44.310 Right. 08:44.310 --> 08:50.230 Because we've got this Google Sheets form, which is especially for, um, you know, records from our 08:50.230 --> 08:52.750 clients that contacted us somewhere. 08:52.750 --> 08:59.470 So it could have been the type form, Google Forms, even here, you know, any call or just, you know, 08:59.510 --> 09:01.640 any other circumstances. 09:01.760 --> 09:06.160 So there what we do and we provide this data right here in the Google Sheets. 09:06.200 --> 09:10.080 And there this automation fulfills and we send this entire email. 09:10.080 --> 09:10.520 Right. 09:10.920 --> 09:17.360 And the last step for now, um, is our what we had Google and contacts. 09:17.400 --> 09:17.800 Yeah. 09:17.840 --> 09:18.840 Contacts. 09:18.880 --> 09:19.360 Yeah. 09:19.400 --> 09:20.040 All right. 09:20.080 --> 09:21.720 We can create a new contact. 09:21.920 --> 09:25.080 And here what's very important we've got the given name. 09:25.440 --> 09:27.000 So let's, um. 09:27.040 --> 09:27.440 Yeah. 09:27.600 --> 09:28.240 Close it. 09:28.240 --> 09:30.400 And here get the name. 09:30.640 --> 09:32.080 So you've got given name. 09:32.840 --> 09:38.320 Um, also, I could have, um, actually fulfilled the name with my name and last name. 09:38.320 --> 09:43.960 However, for now, I've got the name and whatever, I can provide the additional fields because I need 09:43.960 --> 09:45.920 to provide the phone number. 09:46.040 --> 09:50.480 So here we've got the phone add phone and then choose the choose the type. 09:50.480 --> 09:54.200 So we've got the mobile and the value which is a variable here. 09:54.880 --> 09:59.320 All right I can test the step and see if that works. 10:00.280 --> 10:00.920 Nice. 10:00.920 --> 10:03.200 So yeah, this is how it should be done. 10:03.600 --> 10:09.360 And now what we can do, let's actually test it out so we can switch actually the active mode. 10:09.720 --> 10:17.720 And here whenever we fulfill any new role like inside our you know Google Sheets it should work. 10:17.720 --> 10:21.240 So let's see we've got here for an example John. 10:21.560 --> 10:23.040 And now let's provide the last name. 10:23.040 --> 10:29.760 So John three here let's provide the email I provide my email actually to see if I receive an email 10:29.800 --> 10:30.920 to my inbox. 10:31.720 --> 10:35.640 Uh, because we are testing that, let's provide a phone number and description. 10:36.280 --> 10:40.880 I want to talk about the cooperation. 10:41.360 --> 10:42.960 Yeah, about the cooperation. 10:42.960 --> 10:43.640 All right. 10:43.680 --> 10:45.000 Now it's fulfilled. 10:45.280 --> 10:47.600 So what we can do, we can wait a while. 10:47.720 --> 10:52.040 And in the executions we should see if that worked. 10:52.040 --> 10:53.600 So we need to wait a while. 10:54.040 --> 10:58.760 Um, until, you know, actually, even we can refresh the page and right here. 10:58.800 --> 10:59.200 See? 10:59.240 --> 11:01.010 All right, so we need to wait a while. 11:02.730 --> 11:05.970 And now there is a notification that this is running. 11:05.970 --> 11:06.650 You saw that. 11:06.690 --> 11:07.050 All right. 11:07.050 --> 11:08.130 So it succeeded. 11:08.290 --> 11:11.170 And here everything is performed. 11:11.170 --> 11:14.930 So slack channel message Gmail Google contacts. 11:15.290 --> 11:18.290 Um so even we can we can check it out. 11:18.730 --> 11:22.010 So as you can see the contact was created right there. 11:22.010 --> 11:25.570 We received the email for the John three name. 11:25.730 --> 11:28.970 And at the end we have, um, you know, our slack channel message. 11:28.970 --> 11:31.850 So name, email, phone number and everything works. 11:32.170 --> 11:34.650 So for this video I can say this is everything. 11:34.690 --> 11:37.130 I actually hope I accomplished the entire exercise. 11:37.130 --> 11:40.090 And your automation performed without any issues. 11:40.490 --> 11:45.450 And in general, in the next videos of the course will go more in depth when it comes to the theory. 11:45.730 --> 11:52.130 Um, covering complex workflows, agents, a voice agents, and a lot of more automations. 11:52.130 --> 11:56.770 So remember, this class is all about teaching you how to become a an expert. 11:56.970 --> 12:00.730 So again, thank you for watching and I will see you in the next materials.