WEBVTT 00:00.280 --> 00:07.040 So far in this chapter, we had four different projects and now let's build a Summarizer actually a 00:07.040 --> 00:12.680 document Summarizer that actually triggers whenever the new file is uploaded to Google Drive. 00:12.960 --> 00:20.080 Then it gets the content from this exact file, and it uses AI to generate a summary, and also the 00:20.080 --> 00:22.000 Wikipedia as the extension. 00:22.000 --> 00:25.120 And at the end it saves the data inside Google Sheets. 00:25.560 --> 00:30.240 If you want to get more advanced description for this project and the resources of this material, I 00:30.240 --> 00:34.880 prepared for you the file you can download and here read everything about it. 00:35.320 --> 00:38.920 But now, without speaking too much, let's create this automation. 00:38.920 --> 00:43.280 So let's start with the trigger which is drive Google Drive. 00:43.440 --> 00:49.440 And here on changes involving a specific folder we want to trigger this automation. 00:49.440 --> 00:52.760 So here I've got my folder which is named and testing. 00:53.240 --> 00:56.880 And there we are searching for file created. 00:58.040 --> 01:02.720 Now what we can do actually we can fetch test event. 01:02.760 --> 01:06.200 However we need to add some specific file before. 01:06.520 --> 01:08.400 So right there let's create. 01:08.440 --> 01:13.960 Actually it's also very important this automation actually works on Docker extension. 01:13.960 --> 01:17.440 So here we are providing only doc documents. 01:17.680 --> 01:19.720 Let me actually create some file. 01:19.960 --> 01:23.560 I've got a data prepared for that actually here as you can see. 01:23.920 --> 01:24.440 All right. 01:24.480 --> 01:26.880 So um let me actually take it here. 01:27.280 --> 01:27.880 All right. 01:28.520 --> 01:36.120 Um, and there let's provide um, there the title for this document and also, um, the content. 01:36.280 --> 01:36.720 Yeah. 01:37.200 --> 01:37.920 That's right. 01:38.320 --> 01:41.040 And now, um, we are done. 01:41.400 --> 01:45.920 Let's go over here, click on file created and fetch test event. 01:46.600 --> 01:47.600 We've got our file. 01:47.600 --> 01:48.720 As you can notice. 01:48.840 --> 01:50.640 Um, can we search for the name. 01:51.160 --> 01:51.840 Name? 01:52.240 --> 01:52.800 Um, yeah. 01:52.840 --> 01:55.080 The surprising benefits of doing nothing. 01:55.200 --> 01:55.520 Yeah. 01:55.560 --> 01:56.560 Very surprising. 01:56.840 --> 02:01.920 Um, now what we can do, we can provide the next node, which is docs. 02:02.040 --> 02:03.400 Um, actually Google Docs. 02:03.880 --> 02:07.800 And here we want to get a document, so get the content actually. 02:08.040 --> 02:08.600 All right. 02:08.600 --> 02:16.470 And now what we can do, um, we can actually take, um, the link or ID maybe. 02:16.470 --> 02:21.830 Let's take ID, um, from our Google Drive. 02:21.870 --> 02:22.070 Yeah. 02:22.110 --> 02:23.390 From our Google drive. 02:23.750 --> 02:24.270 Step. 02:24.430 --> 02:27.230 So the trigger, let's see if that works. 02:27.230 --> 02:29.230 So we've got a content by this way. 02:29.510 --> 02:30.910 Um, as simple as that. 02:30.910 --> 02:34.350 We actually extracted the content from our Google Drive file. 02:34.990 --> 02:36.110 Let's go ahead. 02:36.270 --> 02:44.070 And we've got now the a actually model OpenAI model that uses Wikipedia. 02:44.270 --> 02:48.390 So here we can message a model and we've got the prompt. 02:48.390 --> 02:55.990 So let's actually choose the model which is um let's pick for GPT four. 02:56.030 --> 02:57.070 Oh yeah. 02:57.790 --> 03:00.190 And here I've got the following prompt. 03:00.270 --> 03:05.950 Either you can type or write, take the content and summarize it in a few sentences. 03:06.230 --> 03:16.270 However, I can type something like this, summarize this content into let's say 3 to 5 sentences. 03:16.830 --> 03:17.470 All right. 03:17.910 --> 03:22.830 Let's take the content from Google Docs right here. 03:23.550 --> 03:26.790 And what's actually what's actually very important. 03:27.430 --> 03:28.750 Let's add the tools. 03:28.750 --> 03:32.550 Either we can click here or just click here. 03:32.990 --> 03:36.310 And now let's provide the Wikipedia extension. 03:36.310 --> 03:44.070 So what we do we we enable our OpenAI model to search the Wikipedia which is truly nice. 03:44.910 --> 03:47.910 And the last step for now is Google Sheets. 03:48.430 --> 03:53.110 So as you can notice, these exercises don't take a lot of time. 03:53.150 --> 03:54.990 They are very simple in general. 03:55.150 --> 04:00.550 And the main point is you're getting familiar with Nadine like getting familiar with the software, 04:00.590 --> 04:03.270 how to use it, all of the options and so on. 04:03.910 --> 04:04.950 What we can do now. 04:04.990 --> 04:08.950 All right we've got Google Sheets and we need to append row and sheet. 04:09.910 --> 04:11.350 We've got the document. 04:11.510 --> 04:14.390 And what's very important we need to create some document. 04:14.390 --> 04:15.670 So blank spreadsheet. 04:15.990 --> 04:19.070 And now what we can provide here the name. 04:19.910 --> 04:23.030 Um all right there the summary. 04:24.150 --> 04:26.190 So this is the name of the file summary. 04:26.190 --> 04:33.390 we and what we can type here the link to the Google Drive file. 04:33.510 --> 04:36.670 So link let's say URL. 04:37.350 --> 04:37.550 Yeah. 04:37.590 --> 04:38.190 URL. 04:38.430 --> 04:38.950 All right. 04:39.350 --> 04:41.950 Let's make it like this. 04:41.950 --> 04:49.350 Also I can go over here, select the entire document and um change actually to wrap. 04:49.990 --> 04:50.630 That's cool. 04:50.950 --> 04:53.510 Let's pick the document from the list. 04:53.550 --> 04:55.710 We've got untitled spreadsheet. 04:55.750 --> 04:56.590 Spreadsheet. 04:56.870 --> 04:58.550 We could have and change that. 04:58.550 --> 04:59.910 So for example demo. 05:01.470 --> 05:02.750 Let's do it by this way. 05:02.950 --> 05:04.470 Let's refresh the list. 05:04.710 --> 05:05.470 Do we have the demo? 05:05.510 --> 05:05.910 Yeah. 05:07.230 --> 05:08.270 Choose the sheet. 05:08.630 --> 05:12.630 And here let's provide our name. 05:12.950 --> 05:18.150 Let's let's actually execute the previous notes to have the inputs. 05:18.190 --> 05:18.790 All right. 05:18.790 --> 05:19.950 We've got our name. 05:20.550 --> 05:22.270 Let's search for the name. 05:23.110 --> 05:26.150 Um, we've got the surprising benefits of doing nothing. 05:26.190 --> 05:26.710 Yes. 05:27.270 --> 05:28.110 Um, here. 05:28.150 --> 05:29.350 The contents. 05:29.710 --> 05:34.540 Um, so we have the content from, So where do we have that? 05:34.700 --> 05:36.900 We have the content from OpenAI. 05:37.060 --> 05:39.300 We want to get this summary. 05:39.980 --> 05:44.980 And at the end let's, um, take the link. 05:45.020 --> 05:45.860 That's right. 05:45.900 --> 05:47.220 Let's take the link. 05:47.620 --> 05:49.300 Um, where do we have that? 05:50.220 --> 05:51.700 Probably right here. 05:51.860 --> 05:53.820 Web view link URL. 05:54.220 --> 05:54.820 Nice. 05:54.980 --> 05:58.420 So we've got everything name, summary and URL. 05:58.660 --> 06:01.580 Let's test it and see how it works. 06:02.180 --> 06:05.220 So here it should appear in a matter of seconds. 06:05.260 --> 06:05.780 Nice. 06:05.820 --> 06:08.100 We've got a name summary URL. 06:08.140 --> 06:10.460 Of course, we could have formatted that previously. 06:10.460 --> 06:14.340 So this entire file still, it's really enough. 06:14.540 --> 06:19.580 We created our workflow, which is which contains actually four different nodes. 06:19.580 --> 06:24.820 So we've got first the input which is Google Drive, Google Docs, OpenAI and at the end and at the 06:24.820 --> 06:26.340 end output node. 06:26.900 --> 06:30.780 So that's everything I hope you actually accomplish this exercise. 06:30.780 --> 06:35.180 You had a lot of fun meanwhile doing that and you didn't have any problems. 06:35.260 --> 06:36.820 Meanwhile the entire process. 06:37.060 --> 06:40.220 Thank you for watching and I will see you in the next lesson.