1 00:00:01,080 --> 00:00:07,800 In this lecture, I'm going to show you how to set up your Google sheet, plus create the necessary 2 00:00:07,800 --> 00:00:15,750 Google Drive and Google Sheet credentials so that your no red sheet noad can actually interact with 3 00:00:15,750 --> 00:00:16,950 your Google sheet. 4 00:00:17,910 --> 00:00:19,080 OK, so let's begin. 5 00:00:19,290 --> 00:00:27,780 You need to first go to commercial dot cloud, dot, Google dot com and access your cloud platform dashboard. 6 00:00:27,820 --> 00:00:30,920 Of course, you need to have a Google account to do this. 7 00:00:31,650 --> 00:00:38,080 The product that you'll be accessing is free, so that's not going to be an expense attached to it. 8 00:00:38,670 --> 00:00:42,140 So the first thing that you need to do is to create a new project. 9 00:00:42,180 --> 00:00:48,330 I've got my terrorism trial project here, but I'm going to create a totally new project for the purposes 10 00:00:48,330 --> 00:00:49,320 of this demo. 11 00:00:49,950 --> 00:00:53,770 So you can do that from the dashboard and then give it a reasonable name. 12 00:00:53,800 --> 00:00:56,040 So let's call it terrorism 13 00:00:58,230 --> 00:01:04,950 version three, which is the third time I'm doing this for billing account I'm going to use to select 14 00:01:04,950 --> 00:01:10,560 my default billing account, even though, as I said, there is not going to be any billing and your 15 00:01:10,590 --> 00:01:18,210 organization, your default organization and select allocation as well, depending on how you've set 16 00:01:18,210 --> 00:01:18,880 up your account. 17 00:01:18,900 --> 00:01:21,410 These options are going to be different for you. 18 00:01:21,930 --> 00:01:26,720 Click on Create and then just give it a little bit of time. 19 00:01:26,730 --> 00:01:32,290 It takes a few seconds for the new project to be created are actually know that it's ready. 20 00:01:32,820 --> 00:01:36,140 See if you can select it again from the menu here. 21 00:01:36,150 --> 00:01:40,360 So it's take a little bit longer to complete its creation process. 22 00:01:40,380 --> 00:01:48,180 Now it's available out of selected and make sure that before you continue your new project name appears 23 00:01:48,180 --> 00:01:52,290 up here right now that you have a new project. 24 00:01:52,290 --> 00:02:00,030 What you want to do is to install the necessary APIs and services to go into API and Services Dashboard. 25 00:02:04,010 --> 00:02:11,210 And then click on this button up here to enable APIs and services and the first one that we need is 26 00:02:11,210 --> 00:02:20,810 the drive API to search for drive, even if you misspell it, it still comes up and then enable it. 27 00:02:24,170 --> 00:02:27,870 OK, so your Google Drive API is enabled. 28 00:02:27,920 --> 00:02:28,430 Awesome. 29 00:02:28,760 --> 00:02:32,990 Let's go back to apps and services and enable. 30 00:02:34,680 --> 00:02:42,240 This sheet of paper, a search for the sheet API, then click on the box and enable it. 31 00:02:45,930 --> 00:02:53,730 OK, let's go back to apps and services, and now that you've got the two APIs enabled for your Tyrolean 32 00:02:53,730 --> 00:02:58,920 project, click on credentials to create the API credentials. 33 00:02:59,140 --> 00:03:01,490 It's going to be adjacent file that we need to create. 34 00:03:01,500 --> 00:03:05,820 So click on create credentials and then go for service account. 35 00:03:07,820 --> 00:03:12,350 And then give you a service account to name such as terrarium. 36 00:03:14,580 --> 00:03:15,480 Controller. 37 00:03:17,530 --> 00:03:18,370 Service. 38 00:03:21,950 --> 00:03:28,450 And as you're typing this, you can see that there is a new service account idea created down here and 39 00:03:28,610 --> 00:03:32,300 you can give it a description if you want, but I'm going to create a set of descriptions. 40 00:03:32,300 --> 00:03:33,580 Yes, I know what it is about. 41 00:03:33,590 --> 00:03:37,040 I know it's got a service account. 42 00:03:37,040 --> 00:03:39,170 I want to also give it a role. 43 00:03:39,200 --> 00:03:46,520 So this is going to be an editor so that we can actually edit and make changes to our Google sheet and 44 00:03:46,520 --> 00:03:47,690 click on CONTINUE. 45 00:03:50,220 --> 00:03:55,340 And this step here is optional, so I'm going to leave these options blank and click on Don. 46 00:03:57,870 --> 00:04:01,990 All right, so now we've got our service account down here. 47 00:04:02,550 --> 00:04:04,050 So click on it. 48 00:04:07,530 --> 00:04:14,240 And the first thing you want to do is to copy this e-mail address and store it somewhere safe. 49 00:04:14,260 --> 00:04:21,630 So in my case, I'm going to put it in a document, in a text editor, because I'm going to need this 50 00:04:21,630 --> 00:04:29,160 email address essentially later on when I configure my Google sheet and it gives access a permission 51 00:04:29,490 --> 00:04:32,160 to access sheet to this account. 52 00:04:33,980 --> 00:04:41,020 And still in the terrorism patrol service dashboard, click on the ad key option or drop down and create 53 00:04:41,030 --> 00:04:41,710 a new key. 54 00:04:42,500 --> 00:04:44,200 And do you want this to be of type? 55 00:04:44,210 --> 00:04:46,070 Jason, click on CREATE. 56 00:04:48,410 --> 00:04:55,510 And as you see here, there's a new file that was just downloaded by my browser with Jason Extension, 57 00:04:56,000 --> 00:05:03,460 so you need to grab that and this is what my credentials Jason file looks like. 58 00:05:03,470 --> 00:05:10,790 And you'll notice in here as well that the e-mail address, which is created as part of this certification 59 00:05:10,790 --> 00:05:15,000 process, is also present inside the Jason file. 60 00:05:15,530 --> 00:05:21,290 So keep this handy and put it aside for now, and I'm going to use it in the next lecture where we'll 61 00:05:21,290 --> 00:05:23,690 configure the exhibit A.. 62 00:05:24,130 --> 00:05:26,180 OK, so now we've got the credentials. 63 00:05:26,180 --> 00:05:27,470 You can see that they're active. 64 00:05:27,480 --> 00:05:29,630 Here's the key and everything is set. 65 00:05:29,990 --> 00:05:36,860 So I can leave this at that and continue to create a Google sheet file like this one. 66 00:05:37,730 --> 00:05:41,090 So this is the demonstration file that I showed you in the previous lecture. 67 00:05:41,090 --> 00:05:46,750 But I'm going to create a new one and show you how to configure it within your service account. 68 00:05:47,180 --> 00:05:53,000 So let's go into Google Drive and I've got a folder here called Google Sheets, and I'm going to create 69 00:05:53,360 --> 00:05:54,470 a new sheet. 70 00:05:56,280 --> 00:05:58,710 In this folder, I'll give it a name. 71 00:06:07,340 --> 00:06:13,460 Like this, and while I'm at it, I'm just going to copy the header across so I don't have to type it 72 00:06:13,460 --> 00:06:20,420 in from my demonstration file, so there is my header and there are two things to notice here. 73 00:06:20,420 --> 00:06:30,100 First is that up in the real this segment of the URL is the Google Sheet ID, so we're going to use 74 00:06:30,110 --> 00:06:33,160 it in the next lecture when we configure the Google sheet. 75 00:06:33,440 --> 00:06:35,000 No, no red. 76 00:06:36,480 --> 00:06:43,830 But anything that you need to do here is to click on the share button and give access to the security 77 00:06:44,670 --> 00:06:48,190 account or to the new security account, which you created earlier. 78 00:06:48,390 --> 00:06:50,540 That is also in the Jason file. 79 00:06:50,820 --> 00:06:56,480 But perhaps you also have saved it in a separate text editor page. 80 00:06:56,940 --> 00:07:01,170 So take that and insert it and paste it in. 81 00:07:03,230 --> 00:07:04,370 They share. 82 00:07:05,470 --> 00:07:14,620 People within groups window like this and make sure that this user has got editing permissions and don't 83 00:07:14,620 --> 00:07:19,630 worry about notification to receive this e-mail address is not attended by anyone, simply would share. 84 00:07:21,200 --> 00:07:23,420 And so, yes, share anyway. 85 00:07:24,440 --> 00:07:30,060 All right, so this is ready now to be used by our note, read slow. 86 00:07:30,080 --> 00:07:33,140 So we have created a new Google sheet. 87 00:07:33,590 --> 00:07:38,080 We have provided the appropriate permissions to it, to the appropriate user. 88 00:07:38,330 --> 00:07:44,970 And we also have our security credentials that are ready to be used with our note rates. 89 00:07:45,740 --> 00:07:49,730 So let's move on to the next lecture and set up the flow.