WEBVTT 00:00.120 --> 00:06.840 Okay, it's now time for the big integration of the day, which is with Google, a full oath to integration 00:06.840 --> 00:10.920 with Google so that we can do things like scan the Google Drive. 00:10.920 --> 00:14.320 And this is taking us beyond the Google Sheets integration we did before. 00:14.720 --> 00:21.640 And it all begins in this website, cloud.google.com, which is the GCP landing page for Google Cloud 00:21.640 --> 00:22.320 Platform. 00:22.320 --> 00:23.480 Cloud.google.com. 00:23.480 --> 00:27.960 So if you go there and at the top here, if you don't even have a Google account, but you do have a 00:27.960 --> 00:31.080 Google account, but if you didn't, then you might have to go to start free. 00:31.120 --> 00:32.320 But I assume you do. 00:32.360 --> 00:36.360 And so you can go to sign in and a free Google account like Gmail will do. 00:36.400 --> 00:41.880 Or I've also got like a, like a paid Google Apps one here to uh, so anything you want. 00:41.920 --> 00:42.920 Come on in. 00:43.120 --> 00:47.440 Then you'll have to give your password and I will see you once you've signed up. 00:47.440 --> 00:52.200 Now, if it's your first time coming into GCP, you've never done it before with your Google ID, then 00:52.200 --> 00:53.960 you probably have to answer a few questions. 00:53.960 --> 00:58.760 You probably have to get something about free credits, all sorts of other stuff it will tell you about 00:58.760 --> 01:00.560 which you can all happily accept. 01:00.560 --> 01:04.940 But we're not going to do anything that's paid at this point and so everything should be fine. 01:04.980 --> 01:08.420 You should reach this point and then you're going to press the console button here. 01:08.460 --> 01:14.620 So you're now going to be going to Console.cloud.google.com, which is where our adventure begins. 01:14.740 --> 01:18.780 The first thing we're going to do is create a Google project. 01:18.980 --> 01:20.740 And I already have some projects. 01:20.740 --> 01:22.700 So I've got this project selector up here. 01:22.700 --> 01:24.940 I could click here and then press New Project. 01:24.980 --> 01:29.420 You may either click there and press New Project, or you might just have a create project or new project 01:29.420 --> 01:30.340 button up there. 01:30.340 --> 01:31.380 But this is what you do. 01:31.420 --> 01:34.820 You come on in here so that you can have new projects. 01:34.860 --> 01:35.700 Here we are. 01:35.940 --> 01:40.340 And the name of your project is going to be amplify. 01:40.500 --> 01:42.940 That's going to be this week is all about amplifying your business. 01:42.940 --> 01:46.500 And amplify will be the name of our project. 01:46.700 --> 01:49.100 Um, project ID cannot be changed later. 01:49.100 --> 01:52.380 So we can also edit the project ID and make it amplify. 01:52.700 --> 01:55.300 It's entirely possible this has to be unique across. 01:55.340 --> 01:56.140 Uh, yeah. 01:56.180 --> 01:56.660 There you go. 01:56.700 --> 01:57.740 That's not available. 01:57.900 --> 02:00.780 Uh, amplify is already a popular project ID. 02:00.820 --> 02:01.860 The ID doesn't matter. 02:01.980 --> 02:05.410 Uh, so we'll leave that as our project ID, uh. 02:05.530 --> 02:06.850 Or I can make it. 02:06.850 --> 02:10.570 I can make it like like amplify dash add, I imagine. 02:10.570 --> 02:11.730 No, that's not available. 02:11.770 --> 02:13.290 Amplify dash add. 02:13.330 --> 02:13.810 Donna. 02:15.090 --> 02:15.610 There we go. 02:15.650 --> 02:16.650 That's available. 02:16.690 --> 02:20.410 Ah, so you can make an amplify dash, your name or a number or whatever you want. 02:20.450 --> 02:21.370 Let Google choose that. 02:21.410 --> 02:24.450 What matters is the name has to be amplified. 02:24.690 --> 02:27.370 And now we're going to say create. 02:27.650 --> 02:29.530 And that has been created. 02:29.530 --> 02:30.490 It's happening over here. 02:30.490 --> 02:37.130 It's going to spend a minute creating it while you're brand new GCP project is created. 02:37.210 --> 02:38.490 And I'll see you when it's done. 02:38.610 --> 02:39.250 Okay. 02:39.530 --> 02:43.090 Now I'm going to press Select Project right here. 02:43.170 --> 02:44.850 Uh it's changed this to amplify. 02:44.850 --> 02:52.410 I could equally well have clicked on here and ticked amplify like that and amplify is the current project 02:52.610 --> 02:53.450 okay. 02:53.770 --> 02:59.410 Now go to this menu bar up here, the navigation menu, which is where all this stuff appears that you 02:59.410 --> 03:00.370 could do a GCP. 03:00.410 --> 03:02.130 GCP is enormous, of course. 03:02.170 --> 03:08.510 And we're we're not going to do very much uh, go to APIs and services and to library. 03:09.190 --> 03:11.230 Uh, and again, there's a lot here. 03:11.270 --> 03:16.270 There's obviously people have built entire professions around knowing how to work GCP, and we're going 03:16.270 --> 03:17.710 to only do a few small things. 03:17.710 --> 03:22.790 We're going to find the Google Drive API, Google Drive API. 03:22.830 --> 03:23.590 There it is. 03:24.230 --> 03:25.710 Uh, it's right there. 03:26.110 --> 03:28.950 And the Google Drive API. 03:29.390 --> 03:31.630 And we are going to enable it. 03:31.630 --> 03:36.030 So we click on it and we press enable. 03:37.350 --> 03:38.350 And it thinks. 03:41.430 --> 03:44.230 And this will hopefully be enabled in just one second. 03:44.510 --> 03:45.230 There we go. 03:45.310 --> 03:47.110 It's enabled okay. 03:47.390 --> 03:48.630 Now it gets real. 03:48.630 --> 03:49.950 Now it gets real. 03:49.950 --> 03:54.790 We're going to go to this screen here the OAuth consent screen. 03:54.990 --> 03:57.430 Select this option right here. 03:57.430 --> 03:59.150 This is this is where the action happens. 03:59.190 --> 04:04.430 Now it's not as grueling as it could be because we're going to be doing this for internal only. 04:04.470 --> 04:10.420 We're going to be telling Google that the only people that can have access to do this is people that 04:10.420 --> 04:12.580 are in this Google organization. 04:12.580 --> 04:14.500 In other words, us, you and me. 04:14.740 --> 04:17.580 And because of that, that makes this all a bit easier. 04:17.700 --> 04:20.940 Uh, but, uh, you'll say you'll you'll see. 04:21.060 --> 04:24.340 So, uh, we have to, to press, uh, get started. 04:25.740 --> 04:26.340 Okay. 04:26.660 --> 04:30.500 Uh, the name of the app asking for consent. 04:30.660 --> 04:32.540 So this we will call amplify. 04:36.060 --> 04:39.940 Uh, for users to ask questions about their consent. 04:39.980 --> 04:42.260 My email address coming in right there. 04:42.380 --> 04:43.620 And now press next. 04:44.140 --> 04:44.900 All right. 04:45.140 --> 04:46.900 Here is a fork in the road. 04:47.220 --> 04:54.020 If you are a Gmail user, if you're a Gmail user, you want to do external at this point. 04:54.020 --> 04:59.660 And this is something that that uh, because because you're just, you're external to, uh, to, to, 04:59.860 --> 05:01.180 to Gmail itself. 05:01.500 --> 05:08.220 But because I am here in my own workspace, I say internal, it's only people within my organization. 05:08.220 --> 05:13.000 And this is particularly easy because you don't need to submit your app for verification. 05:13.000 --> 05:17.360 For people over here, you stay in testing mode, which makes it very, very easy. 05:17.360 --> 05:19.440 So either way, this is going to be easy. 05:19.440 --> 05:26.360 If you've also got your own Google Apps account like me or Google Workspace, then you keep it internal 05:26.360 --> 05:33.720 like this and then you press next, okay, contact email addresses for Google to notify you. 05:33.720 --> 05:37.360 That can just simply be same email address. 05:37.360 --> 05:38.160 There we go. 05:38.880 --> 05:40.320 Add a Madonna.com. 05:40.680 --> 05:42.080 Feel free to email me and say hi. 05:42.480 --> 05:44.920 Uh, finish I agree. 05:45.080 --> 05:47.600 Yes, I agree, of course I agree. 05:47.920 --> 05:57.160 Uh, and then we are going to create this and this is now creating, uh, the OAuth overview that we've 05:57.160 --> 05:59.560 built and all is good. 05:59.720 --> 06:02.360 Uh, we, we are in uh, we're in good shape. 06:02.400 --> 06:03.040 Onwards. 06:03.200 --> 06:03.760 Okay. 06:04.320 --> 06:11.510 Next, the big step, we go back here, we go down to API and services and we go to credentials. 06:11.950 --> 06:13.710 Last time we were in OAuth consent screen. 06:13.710 --> 06:15.950 Now we're in credentials here. 06:16.230 --> 06:17.470 Here is where it happens. 06:17.470 --> 06:18.870 This is action time. 06:18.990 --> 06:22.070 It is time for us to create credentials. 06:22.270 --> 06:23.670 Oh hang on, let me just, uh. 06:24.150 --> 06:24.750 Okay. 06:24.790 --> 06:25.470 Got it. 06:25.670 --> 06:27.390 Uh, create credentials up here. 06:27.430 --> 06:27.950 All right. 06:27.990 --> 06:28.830 Press that. 06:28.870 --> 06:32.390 We are going to create an OAuth client ID. 06:32.830 --> 06:38.950 This is something that will allow us to to get consent so that something can, can access our account. 06:39.350 --> 06:39.990 Okay. 06:40.230 --> 06:45.510 And now this is the part where you have to be super careful to fill in everything, right. 06:45.630 --> 06:46.190 Okay. 06:46.350 --> 06:50.150 First up, application type is a web application. 06:50.150 --> 06:52.350 The first option web application. 06:52.830 --> 06:56.390 All right then the name we need to give it a name. 06:56.390 --> 06:59.750 So this is the name of the the of the auth to client. 06:59.790 --> 07:04.190 It's used to identify it for us here in the console. 07:04.190 --> 07:06.750 It's not something that's going to end users. 07:06.750 --> 07:12.570 So we call it something like uh an For amplify. 07:12.970 --> 07:14.170 That's that's what this is. 07:14.170 --> 07:15.290 This is all about. 07:15.890 --> 07:16.610 Okay? 07:17.170 --> 07:17.930 And now. 07:18.170 --> 07:19.690 And now this is where. 07:19.690 --> 07:21.170 This is where things get hairy. 07:21.410 --> 07:26.970 Uh, we need to add an authorized redirect URI. 07:27.130 --> 07:31.690 And this this is the part where, uh, where things often go wrong. 07:31.690 --> 07:33.250 This redirect URI. 07:33.410 --> 07:40.450 So I'm opening this, and I'm saying, uh, this is this is a you are a URI URL that needs to be pasted 07:40.450 --> 07:47.930 in here, which is where, um, where, where Google will redirect to when there's been a successful 07:47.930 --> 07:49.090 authentication. 07:49.090 --> 07:51.210 And so what is it that we're going to put in here? 07:51.410 --> 07:52.890 Well, here's the thing. 07:53.130 --> 07:59.130 This is a moment when we put this screen on pause for a second and we go back to N810. 07:59.450 --> 08:00.090 N810. 08:00.130 --> 08:00.690 Yes. 08:00.890 --> 08:01.370 Here we go. 08:01.410 --> 08:02.890 I'm flipping over to Nan. 08:02.930 --> 08:05.650 This is me logged in to my workflow screen. 08:05.890 --> 08:06.250 All right. 08:06.250 --> 08:07.850 Let's go back to our project. 08:07.850 --> 08:11.050 Here's my project right here with my first folder in there. 08:11.130 --> 08:17.880 Go to credentials The credentials tab where we've set up our credentials and press Create Credential. 08:18.160 --> 08:21.400 And now we're trying to find a credential we're trying to connect to. 08:21.440 --> 08:27.600 Well we want the Google Drive Google Drive OAuth two API. 08:27.800 --> 08:30.120 Select that and press continue. 08:30.360 --> 08:32.160 And up comes this screen. 08:32.520 --> 08:34.560 And why do we have to go through this rigmarole. 08:34.600 --> 08:36.440 Because check that out. 08:36.480 --> 08:37.240 Look at that. 08:37.280 --> 08:40.760 The OAuth redirect URL right there. 08:40.800 --> 08:42.040 Click to copy. 08:42.280 --> 08:44.280 Go back to Google. 08:44.400 --> 08:46.560 Click here and paste. 08:46.760 --> 08:48.920 And this has to be right. 08:49.240 --> 08:49.480 Ha. 08:49.640 --> 08:52.000 If you get this wrong it's not going to work. 08:52.000 --> 08:54.160 And it's going to be really hard to figure out why. 08:54.480 --> 08:57.560 So you just have to follow this precisely. 08:57.600 --> 09:00.480 You've got to go to and you've got to pick the right API. 09:00.520 --> 09:04.480 You've got to get the right callback and put the right callback in there. 09:04.520 --> 09:08.040 It's part of the fiddling ness of OAuth two. 09:08.160 --> 09:11.200 You need to get this callback right. 09:11.240 --> 09:13.880 Okay, hopefully you're not feeling fried by this point. 09:13.960 --> 09:15.540 There are 1 or 2 steps. 09:15.540 --> 09:17.380 I did warn you, it was a little bit hairy. 09:17.540 --> 09:19.980 You now press create notes. 09:19.980 --> 09:23.260 It might take a few minutes for your setup to be complete. 09:23.500 --> 09:25.300 And here now we have the result. 09:25.300 --> 09:26.180 It didn't take a few minutes. 09:26.180 --> 09:27.020 It was instant. 09:27.020 --> 09:28.180 It's being created. 09:28.180 --> 09:30.980 There is a client ID and a client secret. 09:30.980 --> 09:32.860 And I shouldn't be sharing it like this to you. 09:32.860 --> 09:35.300 But don't worry, I'll delete it before you get your hands on it. 09:35.500 --> 09:38.220 Uh, but here we have our client ID and the client secret. 09:38.220 --> 09:39.940 These are two very important things. 09:39.940 --> 09:42.020 And now don't get rid of this screen yet. 09:42.060 --> 09:47.620 Now you have to be super careful, because these two things need to be taken across to N810. 09:47.620 --> 09:49.100 And you have to do it correctly. 09:49.300 --> 09:52.260 The client ID, I copy that to the clipboard. 09:52.260 --> 09:57.620 I flip over to n810 the client id, I paste it, you see it there? 09:57.660 --> 10:00.940 It's there, I was careful, I go back over here. 10:00.940 --> 10:02.020 That was the client ID. 10:02.020 --> 10:03.980 I'm now looking at the client secret. 10:03.980 --> 10:05.140 I click to copy. 10:05.140 --> 10:10.340 I go over here, I click in the client secret, I paste and it's in there. 10:10.460 --> 10:11.500 I've been careful. 10:11.780 --> 10:12.460 Okay. 10:12.500 --> 10:13.780 You've been careful too. 10:14.020 --> 10:16.900 And now we're almost ready to try this.