In this lecture, I'm going to show you how to set up your Google sheet, plus create the necessary
Google Drive and Google Sheet credentials so that your no red sheet noad can actually interact with
your Google sheet.
OK, so let's begin.
You need to first go to commercial dot cloud, dot, Google dot com and access your cloud platform dashboard.
Of course, you need to have a Google account to do this.
The product that you'll be accessing is free, so that's not going to be an expense attached to it.
So the first thing that you need to do is to create a new project.
I've got my terrorism trial project here, but I'm going to create a totally new project for the purposes
of this demo.
So you can do that from the dashboard and then give it a reasonable name.
So let's call it terrorism
version three, which is the third time I'm doing this for billing account I'm going to use to select
my default billing account, even though, as I said, there is not going to be any billing and your
organization, your default organization and select allocation as well, depending on how you've set
up your account.
These options are going to be different for you.
Click on Create and then just give it a little bit of time.
It takes a few seconds for the new project to be created are actually know that it's ready.
See if you can select it again from the menu here.
So it's take a little bit longer to complete its creation process.
Now it's available out of selected and make sure that before you continue your new project name appears
up here right now that you have a new project.
What you want to do is to install the necessary APIs and services to go into API and Services Dashboard.
And then click on this button up here to enable APIs and services and the first one that we need is
the drive API to search for drive, even if you misspell it, it still comes up and then enable it.
OK, so your Google Drive API is enabled.
Awesome.
Let's go back to apps and services and enable.
This sheet of paper, a search for the sheet API, then click on the box and enable it.
OK, let's go back to apps and services, and now that you've got the two APIs enabled for your Tyrolean
project, click on credentials to create the API credentials.
It's going to be adjacent file that we need to create.
So click on create credentials and then go for service account.
And then give you a service account to name such as terrarium.
Controller.
Service.
And as you're typing this, you can see that there is a new service account idea created down here and
you can give it a description if you want, but I'm going to create a set of descriptions.
Yes, I know what it is about.
I know it's got a service account.
I want to also give it a role.
So this is going to be an editor so that we can actually edit and make changes to our Google sheet and
click on CONTINUE.
And this step here is optional, so I'm going to leave these options blank and click on Don.
All right, so now we've got our service account down here.
So click on it.
And the first thing you want to do is to copy this e-mail address and store it somewhere safe.
So in my case, I'm going to put it in a document, in a text editor, because I'm going to need this
email address essentially later on when I configure my Google sheet and it gives access a permission
to access sheet to this account.
And still in the terrorism patrol service dashboard, click on the ad key option or drop down and create
a new key.
And do you want this to be of type?
Jason, click on CREATE.
And as you see here, there's a new file that was just downloaded by my browser with Jason Extension,
so you need to grab that and this is what my credentials Jason file looks like.
And you'll notice in here as well that the e-mail address, which is created as part of this certification
process, is also present inside the Jason file.
So keep this handy and put it aside for now, and I'm going to use it in the next lecture where we'll
configure the exhibit A..
OK, so now we've got the credentials.
You can see that they're active.
Here's the key and everything is set.
So I can leave this at that and continue to create a Google sheet file like this one.
So this is the demonstration file that I showed you in the previous lecture.
But I'm going to create a new one and show you how to configure it within your service account.
So let's go into Google Drive and I've got a folder here called Google Sheets, and I'm going to create
a new sheet.
In this folder, I'll give it a name.
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
in from my demonstration file, so there is my header and there are two things to notice here.
First is that up in the real this segment of the URL is the Google Sheet ID, so we're going to use
it in the next lecture when we configure the Google sheet.
No, no red.
But anything that you need to do here is to click on the share button and give access to the security
account or to the new security account, which you created earlier.
That is also in the Jason file.
But perhaps you also have saved it in a separate text editor page.
So take that and insert it and paste it in.
They share.
People within groups window like this and make sure that this user has got editing permissions and don't
worry about notification to receive this e-mail address is not attended by anyone, simply would share.
And so, yes, share anyway.
All right, so this is ready now to be used by our note, read slow.
So we have created a new Google sheet.
We have provided the appropriate permissions to it, to the appropriate user.
And we also have our security credentials that are ready to be used with our note rates.
So let's move on to the next lecture and set up the flow.