WEBVTT 00:00.280 --> 00:06.240 In the previous lesson, we created our fully functional telegram chatbot and now is the time for another 00:06.240 --> 00:10.120 exercise, which will be simple and relatively easy to accomplish. 00:10.360 --> 00:15.000 So we'll create a system that synchronizes new files from Google Drive to our table. 00:15.200 --> 00:19.600 And as usual in this chapter, I prepared for you the file that explains everything. 00:19.760 --> 00:24.080 So in this exercise, you will build an automation that helps you organize and share files. 00:24.080 --> 00:29.840 When a new file is added to a specific Google Drive folder, your workflow will detect the new file 00:29.840 --> 00:31.040 from Google Drive. 00:31.240 --> 00:34.080 Send the file by email to a recipient. 00:34.320 --> 00:37.400 Save file details into Airtable. 00:37.720 --> 00:41.440 So here again, I can say it's relatively easy to create. 00:41.560 --> 00:47.120 However, the most common problem can be with, you know, connecting creating credentials for Google 00:47.120 --> 00:47.720 Drive. 00:47.960 --> 00:53.880 However, remember Damien explained everything step by step how to do this in the section about creating 00:53.880 --> 00:54.920 credentials. 00:54.920 --> 00:56.160 So now you can stop the video. 00:56.160 --> 01:02.930 Go over here and you know like connect your Google Drive to And then as you can see, the automation 01:02.930 --> 01:06.250 you will build in this material contains only three nodes. 01:06.250 --> 01:08.290 So first things first we've got Google Drive. 01:08.450 --> 01:14.210 So whenever a new file appears inside some folder inside Google Drive we would like to trigger this 01:14.250 --> 01:15.010 automation. 01:15.210 --> 01:19.730 Then what we do we share the file with the recipient that we provide right here. 01:19.850 --> 01:23.130 And at the end we log the data inside Airtable. 01:23.330 --> 01:25.050 And that's simple as that. 01:25.130 --> 01:27.530 So we've got only three different nodes. 01:27.570 --> 01:30.010 And now with all that being said let's create that. 01:31.050 --> 01:34.450 So to begin with the automation let's add our trigger. 01:34.650 --> 01:37.730 So firstly we've got here Google Drive. 01:38.650 --> 01:40.210 And let's pick that. 01:40.210 --> 01:45.850 And now we've got a trigger which is on changes involving a specific folder not the file however however 01:45.850 --> 01:46.450 folder. 01:46.970 --> 01:51.770 And then what's very important actually you need to create a credential for Google Drive. 01:51.970 --> 01:56.570 Again actually I refer to the section where Damian explains that step by step. 01:56.690 --> 02:01.540 So if you haven't done it yet, actually I'll go over it there and set up a credential. 02:01.780 --> 02:03.220 So I've got my account. 02:03.340 --> 02:08.060 And here I need to set up a specific actually choose the specific folder. 02:08.060 --> 02:10.580 I can choose either from list URL or ID. 02:10.860 --> 02:12.780 So let me pick from list. 02:12.820 --> 02:17.500 However, for now I need to create my very own folder for this project. 02:17.660 --> 02:20.940 So let's go over there and create my folder. 02:20.940 --> 02:23.860 So new folder and let's name it as demo. 02:24.180 --> 02:24.860 All right. 02:25.300 --> 02:30.820 And inside let's add some file as a file to base on. 02:31.180 --> 02:32.180 Let me add that. 02:32.180 --> 02:34.620 So Q&A for my company. 02:34.820 --> 02:35.420 All right. 02:35.700 --> 02:39.140 And now let's click here and refresh the list. 02:39.620 --> 02:41.420 So we should see demo. 02:41.460 --> 02:42.140 All right. 02:42.500 --> 02:45.940 And watch for a file created. 02:45.940 --> 02:46.380 All right. 02:46.420 --> 02:47.620 File created. 02:47.940 --> 02:48.460 Uh yeah. 02:48.500 --> 02:49.620 File created. 02:49.660 --> 02:54.900 Now I can fetch test event and wait for my file. 02:54.900 --> 02:56.100 It's nice. 02:56.140 --> 02:57.180 We've got it. 02:57.180 --> 02:59.060 Now let's go back to our canvas. 02:59.060 --> 03:03.900 And here set up the second node which will be again Google Drive. 03:03.900 --> 03:05.420 So we can search for drive. 03:06.380 --> 03:10.100 And here we want to share the file with our recipient. 03:10.260 --> 03:13.860 And right there again we need to actually connect our account. 03:13.860 --> 03:15.180 So we've got our credential. 03:15.180 --> 03:17.660 We've got the resource which is file operations. 03:17.660 --> 03:18.940 So we want to share that. 03:19.180 --> 03:21.740 And here we want to choose the file. 03:21.940 --> 03:26.980 And we do this by providing here the ID and there let's search for that. 03:26.980 --> 03:29.100 We've got ID that's perfect. 03:29.300 --> 03:35.020 We can provide it actually here the ID and also enable the permissions. 03:35.140 --> 03:36.660 So we can add the permission. 03:36.900 --> 03:44.100 And there let's provide actually maybe the right error there the type which is the user and the email. 03:44.420 --> 03:51.020 So actually let me go over there and you know actually provide my email. 03:51.140 --> 03:53.620 And now that's all we can actually test the step. 03:53.620 --> 03:56.900 So see if we have an access. 03:56.900 --> 03:57.700 All right. 03:57.700 --> 04:00.790 So actually now let me go over to my email and check it out. 04:01.230 --> 04:04.350 So as you can see, this file is shared on my email. 04:04.830 --> 04:11.670 And there what we can do, we can go back here and set up the last actually output node, which is um, 04:11.710 --> 04:12.630 an Airtable. 04:12.670 --> 04:13.110 All right. 04:13.110 --> 04:14.750 So we can pick Airtable. 04:15.310 --> 04:18.950 And here I create a record okay. 04:19.350 --> 04:23.230 And right there we've got the resource which is record Operation Create. 04:23.230 --> 04:27.750 And here we need to choose our base, which is for me the untitled base. 04:27.910 --> 04:29.790 And here I created the one. 04:29.790 --> 04:33.870 So as you can see we've got the file ID creation time and recipient email. 04:34.310 --> 04:35.030 All right. 04:35.030 --> 04:37.590 So again I can pick that the table. 04:37.950 --> 04:39.270 So I've got the table one. 04:39.270 --> 04:41.910 And here I've got the fields to fulfill. 04:42.230 --> 04:48.310 Let's go over there and provide the ID um creation time. 04:48.990 --> 04:51.270 And lastly we've got the recipient email. 04:51.430 --> 04:52.590 And this is the static value. 04:52.590 --> 04:56.390 So we can provide the email we typed previously. 04:56.950 --> 04:57.750 All right. 04:57.750 --> 04:59.800 And now let's test the step. 05:00.600 --> 05:01.520 So we've got a problem. 05:01.520 --> 05:03.680 File ID expects a number but we've got. 05:03.680 --> 05:07.520 All right so we've got the wrong field type. 05:07.640 --> 05:11.680 Let's click here and there and provide the long text. 05:11.720 --> 05:12.360 That's cool. 05:13.160 --> 05:15.840 And right there let's refresh. 05:16.360 --> 05:17.120 Um there. 05:17.160 --> 05:17.560 Yeah. 05:18.440 --> 05:20.720 Um the columns and let's test the step. 05:20.960 --> 05:21.520 So let's see. 05:21.560 --> 05:22.120 All right. 05:22.120 --> 05:22.960 It works. 05:23.240 --> 05:24.320 And we've got it. 05:24.320 --> 05:24.640 All right. 05:24.640 --> 05:28.440 So we've got our file ID creation time recipient email. 05:28.600 --> 05:31.600 So everything works perfectly. 05:31.800 --> 05:36.600 So in general I hope you enjoyed I'm creating um this entire system. 05:36.600 --> 05:39.440 So synchronizing our Google Drive files. 05:39.440 --> 05:43.280 So whenever we've got the new file here it's shared our recipient. 05:43.400 --> 05:46.640 And then like the data is stored in Airtable. 05:46.640 --> 05:48.200 So for tracking purposes. 05:48.560 --> 05:52.080 So thank you for watching again this video for now that's everything. 05:52.080 --> 05:57.920 And in the next materials we are going further and further into more advanced and projects A agents 05:57.920 --> 05:59.360 and a automations.