WEBVTT 00:00.320 --> 00:04.600 So now I hope you accomplish two previous exercises we had in this section. 00:04.600 --> 00:09.760 So we were creating a chatbot for telegram, and also the system to synchronize files from Google Drive 00:09.800 --> 00:10.800 to Airtable. 00:11.080 --> 00:13.720 Now let's go ahead with another project. 00:13.920 --> 00:19.680 So in this video I have for you something a little bit more complex because we'll create audio transcription 00:19.680 --> 00:20.640 and summary. 00:20.640 --> 00:26.760 And here we've got the trigger which is the new audio file, um, inside a specific Google Drive folder. 00:27.080 --> 00:29.160 Then we've got some automation steps. 00:29.200 --> 00:33.280 And by the way remember you can download this file in the resources of this material. 00:33.280 --> 00:38.120 So here whenever you are creating this automation actually you can go over there open it. 00:38.120 --> 00:40.360 And you know like know all of the details. 00:40.360 --> 00:43.840 However we've got the step one with inside automation steps. 00:43.840 --> 00:46.440 So here detect new audio file in Google Drive. 00:46.600 --> 00:49.520 So use a Google Drive trigger to watch the folder. 00:50.200 --> 00:53.080 Then we've got the step to transcribe audio to text. 00:53.080 --> 00:55.120 And for that we'll be using OpenAI. 00:55.680 --> 00:59.440 And the step three is to summarize um actually using GPT four. 00:59.720 --> 01:05.190 Um so we'll be using our, um, you know, LLM to actually summarize for us this content, and at the 01:05.190 --> 01:11.070 end we save the data inside notion and our system that will build in a moment looks like this. 01:11.190 --> 01:13.550 So first we've got Google Drive trigger again. 01:13.590 --> 01:16.750 Then we've got the step for Google Drive to download the file. 01:16.910 --> 01:20.430 We've got OpenAI to transcribe the recording here. 01:20.670 --> 01:23.550 This actual step actually summarizes that. 01:23.550 --> 01:25.510 And then at the end we've got notion. 01:25.750 --> 01:26.950 So we save that. 01:26.950 --> 01:27.870 Now for an example. 01:27.870 --> 01:29.470 Let me show you how it works. 01:29.470 --> 01:35.910 So here inside my folder inside Google Drive I have the file which is uploaded and everything is set 01:35.950 --> 01:36.950 up right there. 01:37.310 --> 01:39.790 So let's click on Test Workflow. 01:39.950 --> 01:44.310 And actually you can see firstly we've got the file which is this one. 01:44.590 --> 01:48.630 Afterwards it downloaded our content from here. 01:48.950 --> 01:51.830 Now it's transcribing that with using AI. 01:52.670 --> 01:54.230 So let's wait a while. 01:54.630 --> 01:56.830 Actually it may take a several seconds. 01:56.870 --> 01:57.390 Nice. 01:57.430 --> 01:57.710 All right. 01:57.710 --> 01:59.950 So we've got our transcription right there. 02:00.630 --> 02:01.230 Let's see. 02:01.270 --> 02:08.940 We've got the text and we are waiting for yeah the response from our OpenAI. 02:09.580 --> 02:10.500 And at the end. 02:10.540 --> 02:10.900 Yeah. 02:10.900 --> 02:11.620 It's cool. 02:11.620 --> 02:13.380 We should have here a transcript. 02:13.580 --> 02:18.780 So as you can see right there, we've got here the transcript and it works. 02:18.780 --> 02:25.220 So we've got a main point action items, follow up stories, references arguments and more. 02:25.420 --> 02:26.540 So so nice. 02:26.580 --> 02:28.060 It works for sure. 02:29.180 --> 02:31.660 So with all that being said, let's build it from scratch. 02:31.820 --> 02:34.660 However, before that, I've got for you a very small request. 02:34.700 --> 02:39.700 Actually, please accomplish this exercise along with other exercises from this chapter. 02:39.860 --> 02:45.020 Actually, by that, by doing that, you get familiar with and then you practice, um, and you are 02:45.060 --> 02:46.380 better at using that. 02:46.420 --> 02:47.740 It's very, very important. 02:47.900 --> 02:50.820 Nevertheless, let's start with the trigger, which is the drive. 02:51.140 --> 02:51.460 All right. 02:51.460 --> 02:52.780 So we've got Google Drive. 02:52.940 --> 02:57.980 And here we want to trigger that on changes involving a specific a specific folder. 02:58.140 --> 03:00.540 So here we can select from list. 03:00.740 --> 03:02.660 And we've got our recordings. 03:02.700 --> 03:03.300 All right. 03:03.580 --> 03:05.260 I prepared a folder right there. 03:05.260 --> 03:07.420 As you can see I've got my recordings. 03:08.140 --> 03:09.860 So we need to prepare your own. 03:10.220 --> 03:15.700 I'm also, again, if you don't have actually drive connected to an addon, and feel free to check out 03:15.700 --> 03:18.540 our section and the video about how to do this. 03:18.580 --> 03:19.700 It's very important. 03:19.900 --> 03:23.100 And here we watch for file created. 03:23.860 --> 03:24.820 Um, right there. 03:24.860 --> 03:25.700 What I can do. 03:25.740 --> 03:29.100 Let me actually go over here and provide my podcast. 03:29.260 --> 03:29.860 All right. 03:29.860 --> 03:35.820 Right here I would like to based on that I've got productivity. 03:36.540 --> 03:37.620 It's not that long. 03:38.540 --> 03:40.100 And all right it works. 03:40.140 --> 03:41.340 Now let's go over here. 03:42.020 --> 03:44.620 File created fetch test event. 03:45.220 --> 03:46.940 So we've got it. 03:46.980 --> 03:49.340 Let's search for the name. 03:49.900 --> 03:50.700 All right. 03:50.740 --> 03:52.180 And we've got productivity. 03:52.220 --> 03:52.740 Nice. 03:53.460 --> 03:54.140 It's cool. 03:54.420 --> 03:56.220 Um, let's go back to canvas. 03:56.220 --> 04:02.740 And here, um, add the step for drive because we want to download a file. 04:02.980 --> 04:03.660 All right. 04:03.900 --> 04:06.740 You want to take this file and download that. 04:07.220 --> 04:11.260 Now what we can do, um, we can provide the ID. 04:12.050 --> 04:12.610 That's right. 04:12.610 --> 04:15.530 We want to pick the variable based on that. 04:15.530 --> 04:18.250 We want to download this file. 04:18.250 --> 04:20.210 We've got the id so JSON id. 04:20.530 --> 04:21.930 Let's test the step. 04:23.330 --> 04:24.890 Um yeah it should work. 04:24.890 --> 04:25.410 Nice. 04:25.410 --> 04:30.650 So we've got here this file the name productivity file extension. 04:30.690 --> 04:31.530 Nice. 04:31.570 --> 04:32.250 It's cool. 04:32.890 --> 04:41.930 The next step what we want to do is actually to use open AI um to get the transcription for this audio. 04:42.210 --> 04:49.250 So transcribe a recording as you can see right there and here what's very important um, we test this 04:49.250 --> 04:53.250 step because actually previously we had this step and we've got this input. 04:53.610 --> 04:57.610 We need to test the step and wait a few seconds. 04:58.690 --> 05:01.130 So after a while we've got our transcription. 05:01.130 --> 05:06.290 And then we need to go ahead and choose actually message. 05:06.610 --> 05:08.370 Um actually no open AI. 05:09.250 --> 05:10.570 We need to choose open AI. 05:10.690 --> 05:13.530 And here a message a model. 05:13.800 --> 05:14.440 Right. 05:14.760 --> 05:15.960 We need to choose that. 05:15.960 --> 05:20.480 And there we need to pick our model, which is GPT four. 05:20.520 --> 05:26.160 Oh actually let's search for that for oh yeah I recommend you to pick that. 05:26.240 --> 05:27.000 All right. 05:27.040 --> 05:33.200 And here we've got um, actually our messages that we want to send to our, um. 05:33.200 --> 05:33.960 Yeah, I. 05:34.200 --> 05:35.360 Transcript. 05:35.400 --> 05:37.280 Transcript. 05:37.320 --> 05:37.760 Yeah. 05:38.000 --> 05:40.400 Let's provide the variable for the transcript. 05:40.560 --> 05:43.280 So here we've got from the OpenAI. 05:43.320 --> 05:44.680 We've got here the text. 05:45.440 --> 05:45.960 That's perfect. 05:45.960 --> 05:47.040 So JSON text. 05:47.080 --> 05:50.880 And there we can add new message for instructions. 05:51.120 --> 05:56.640 And now actually I created some instructions that you can copy um actually from the resources of this 05:56.640 --> 05:57.480 material. 05:58.560 --> 05:59.880 So they are not complicated. 05:59.880 --> 06:02.200 However you've got something like that instruction. 06:02.200 --> 06:04.360 Summarize the audio content into plain text. 06:04.360 --> 06:12.000 Following the structure below, we've got the rules, so the entire summary must not exceed 1500 characters. 06:12.040 --> 06:14.040 Include the label all of the following sections. 06:14.040 --> 06:14.720 Title summary. 06:14.720 --> 06:15.240 Main points. 06:15.240 --> 06:16.080 Action items. 06:16.120 --> 06:18.390 Follow up stories, references and so on. 06:18.390 --> 06:20.910 And we've got the example structure. 06:21.350 --> 06:24.390 And that's something not very complicated however still. 06:24.590 --> 06:25.750 Yeah it's nice. 06:25.790 --> 06:26.110 All right. 06:26.110 --> 06:27.350 We can test the step. 06:28.230 --> 06:29.790 Let's wait a while. 06:32.150 --> 06:38.430 Um, so in general, when you learn how to use an addon later on, you actually speedrun the entire 06:38.430 --> 06:44.110 process because you know how to use, for example, nodes and different actually actions, you're more 06:44.110 --> 06:45.870 familiar, you get experience. 06:46.430 --> 06:48.670 Um, so it's very quick, I can say. 06:48.670 --> 06:49.190 Right. 06:49.430 --> 06:54.030 And the last output node, um, is actually our um, notion. 06:54.070 --> 06:54.590 All right. 06:54.670 --> 06:59.750 So here we choose notion and there we append a block. 07:00.190 --> 07:04.430 So here actually no no the block we create the page. 07:04.550 --> 07:05.270 That's right. 07:05.710 --> 07:07.470 And now there is the point. 07:07.510 --> 07:09.590 Um actually we need to create our credential. 07:09.630 --> 07:11.310 I've got my own hover actually. 07:11.310 --> 07:13.390 Let me show you how you can do this. 07:13.990 --> 07:16.030 So you need to provide your secret key. 07:16.310 --> 07:19.390 And now actually let me show you how how how you can do this. 07:19.500 --> 07:19.940 All right. 07:20.180 --> 07:22.620 So let's go over to notion Dot. 07:22.820 --> 07:29.860 So and here provide slash profile and their integrations. 07:30.740 --> 07:31.460 All right. 07:31.460 --> 07:32.820 In integrations. 07:33.060 --> 07:35.100 Um yeah that's bad. 07:35.300 --> 07:36.540 All right let's go again. 07:36.540 --> 07:39.100 Notion profile. 07:39.620 --> 07:42.780 I had the misspelling integrations. 07:43.420 --> 07:43.980 Okay. 07:44.460 --> 07:45.300 Hopefully it works. 07:45.340 --> 07:45.660 Yeah. 07:45.700 --> 07:46.180 Nice. 07:46.500 --> 07:48.740 And here we've got this entire page. 07:48.740 --> 07:55.140 So we need to create the new integration and their provide the associated workspace. 07:55.660 --> 07:58.940 Choose the type which is internal and click on save. 07:58.980 --> 07:59.260 All right. 07:59.260 --> 08:00.660 We've got also the name. 08:00.660 --> 08:02.340 So let's name it as demo. 08:03.380 --> 08:03.940 Okay. 08:03.980 --> 08:04.620 Save it. 08:05.220 --> 08:07.500 And we need to configure this integration. 08:07.500 --> 08:11.820 And here um actually take our secret key. 08:11.860 --> 08:12.660 That's right. 08:12.700 --> 08:16.820 Also we need to enable actually we can enable read comments and insert comments. 08:16.940 --> 08:19.820 So it's very nice actually to always enable that. 08:19.860 --> 08:20.860 Let's click on save. 08:21.060 --> 08:25.370 And here let's go back to our, um. 08:25.370 --> 08:25.690 Yeah. 08:25.810 --> 08:26.690 Our profile. 08:26.930 --> 08:28.050 Let's save it. 08:28.050 --> 08:29.610 So we've got our credential. 08:30.010 --> 08:35.730 And now what's very, very important when we are here we need to click there actually. 08:36.130 --> 08:44.930 And on connections right here you should see na den actually na den and testing this is my previous 08:45.370 --> 08:46.730 credential I created. 08:47.250 --> 08:52.010 And when I refresh that um, let me show you I've got the connection. 08:52.010 --> 08:53.250 I've got a demo. 08:53.370 --> 08:53.970 All right. 08:53.970 --> 08:55.330 It's very, very important. 08:55.530 --> 08:59.210 We need to click on that and click on confirm. 09:00.170 --> 09:03.170 After we do this we've got our two connections. 09:03.370 --> 09:06.810 And from now we can work on our page. 09:07.370 --> 09:13.050 So let's go back here and I provide the URL of the page simply. 09:13.170 --> 09:14.490 And we can go over. 09:14.530 --> 09:20.450 We can go over right there to the URL, paste it here, or even choose from the URL. 09:20.490 --> 09:22.250 Next we need to provide a title. 09:22.410 --> 09:27.970 So for example let's search for the name of the file from Google Drive. 09:28.450 --> 09:30.650 We've got Google Drive productivity. 09:30.690 --> 09:31.250 All right. 09:31.610 --> 09:34.210 And then we need to add some blocks. 09:34.410 --> 09:40.170 So firstly we want to pick the heading and provide a heading for that. 09:40.170 --> 09:40.730 Right. 09:41.090 --> 09:44.370 So maybe let's provide a static text which is a summary. 09:45.170 --> 09:49.970 And then also let's provide another block which will be for the text. 09:50.130 --> 09:53.890 So we've got the message from our model. 09:54.250 --> 09:54.890 Okay. 09:55.130 --> 09:56.890 This is probably this one. 09:56.890 --> 09:57.050 Yeah. 09:57.050 --> 09:59.490 We've got the title the podcast episodes. 09:59.530 --> 09:59.850 Yeah. 09:59.890 --> 10:00.370 Okay. 10:00.370 --> 10:01.850 We've got this content. 10:02.250 --> 10:04.890 And now we can test the step. 10:05.410 --> 10:06.250 That's correct. 10:07.690 --> 10:09.170 Hopefully it works. 10:10.970 --> 10:11.770 Let's see. 10:12.730 --> 10:13.290 All right. 10:13.290 --> 10:16.330 So we've got API token is invalid. 10:16.330 --> 10:18.570 So we've got some problem here. 10:18.610 --> 10:22.610 Actually let's maybe refresh that try again. 10:24.850 --> 10:28.240 Um or we've got some problem with our credential. 10:30.600 --> 10:31.160 All right. 10:31.160 --> 10:32.760 So we've got here some problem. 10:33.720 --> 10:35.480 So in general as I noticed. 10:35.480 --> 10:42.680 And it was weird actually my secret key inside and then was very long and I didn't probably like copied 10:42.720 --> 10:45.040 this entire secret key or I don't know. 10:45.200 --> 10:47.000 However, here, um, yeah. 10:47.040 --> 10:49.120 You know, I've got my secret key right there. 10:49.280 --> 10:50.400 Let's save it. 10:50.560 --> 10:53.200 And now set up everything right there. 10:53.320 --> 10:56.680 All right, um, we've got our, um, connection. 10:56.680 --> 10:58.080 Let's test the step. 10:58.480 --> 10:59.200 Hopefully. 10:59.240 --> 10:59.600 Yeah. 10:59.640 --> 11:00.960 All right, it works. 11:00.960 --> 11:02.040 It's simple as that. 11:02.400 --> 11:04.280 And we've got our productivity. 11:04.600 --> 11:09.440 Um, yeah, we've got our productivity podcast summarized inside our file. 11:09.640 --> 11:10.760 It's so, so nice. 11:10.760 --> 11:11.680 It works. 11:11.840 --> 11:16.680 And now, with all that being said, let's test out the entire automation how it works. 11:17.120 --> 11:19.760 So now actually let's make this automation active. 11:20.320 --> 11:23.200 And right now I had to prepare some recording. 11:23.240 --> 11:24.160 However I've got it. 11:24.160 --> 11:26.760 So there we've got uh where is that? 11:26.760 --> 11:27.120 All right. 11:27.160 --> 11:32.750 Cooking cooking podcast Um, it's being uploaded and for sure. 11:32.790 --> 11:35.030 Now everything you know should work. 11:35.070 --> 11:36.390 You should get here. 11:36.430 --> 11:38.230 Um, the file with the transcript. 11:38.230 --> 11:39.030 So right there. 11:39.350 --> 11:42.110 Um, the file, um, yeah, again with the transcript. 11:42.830 --> 11:48.990 After one minute or so, we've cut our cooking podcast transcribed, summarized here inside. 11:49.430 --> 11:51.110 And it's totally nice, actually. 11:51.110 --> 11:54.750 Remember, you can take any file actually audio file. 11:54.750 --> 11:59.350 And here without you doing anything create perfect summary. 11:59.390 --> 12:04.510 It's also nice actually it took a one minute because here let me actually show you. 12:04.550 --> 12:08.630 And the Google Drive we've got um pull times which is every minute. 12:08.630 --> 12:11.070 So we need to actually wait some time. 12:11.230 --> 12:12.950 However, it's very, very fast still. 12:12.990 --> 12:19.990 And after, um, you know, let's say 80s, I had my summary created, which is so, so nice. 12:20.190 --> 12:22.350 And for this video, this is everything. 12:22.350 --> 12:28.230 I hope you created this entire project and you didn't have any problems here for now. 12:28.230 --> 12:29.270 Thank you for watching. 12:29.270 --> 12:33.110 I hope you enjoyed it and I will see you in the next material.