Pie in this picture, I'm going to show you how to install and set up the sheet node, which does not
come with the need for the installation of note.
So we're going to have to install it separately now because I want to show you exactly how to add to
the existing version to flow that we created in the previous section.
I'm going to clean up my version three flow here and then copied version two into version three and
continue building it from that point.
So I'm going to do select everything and just hit the delete key to clean up this flow and deploy my
empty flow now.
And as you can see, my node read dashboard is now totally empty.
And let's go ahead and have a look at how to install the sheet node or any new node.
The 20 story from the available nodes that node read provides.
So to do that, go to the top right menu that the Berga menus is called and open up the managed permit
window.
And you can see here I've got the node read Google Sheets already installed.
So if it was not installed, what you would do would be to go into the install tab and then search for
a cheat sheet.
As you can see here, because I've already installed the sheet mode in my note read instance, it's
marked this installed.
But instead, in your case, you have a button here saying install, just click on it.
To have this new node installed.
I show you how to install a node that is not already on my instance of node red.
So, for example, let's search for nodes relevant to if this and that.
So just search for if this and that and this one, PTB, if this and that is known about the user to
use the channel, make a trigger of if this, then that.
And there's another one down here, the alerted to connect to the if this doesn't that make a channel.
I don't know exactly what these nodes would do, but I'm just going to store them anyway and do some
exploration.
I don't want to click on Install and wait for a few seconds.
OK, so now we've got two new notes, if this and that key and the other one that it didn't have a chance
to see.
So we can go back into the nodes tab and have a look for if this and that can see this is the brand
new node and it comes with two components.
If this is that key and then if they send that out, we may have a chance to play around with this one
later on.
For now, let's have a look at the sheet nodes.
I'm going to search for it and then drop it onto my version.
Three, Slow Convis and double click to have a look at what it's like.
So what this node requires for you to operate is the credentials from Google Drive or actually the Google
APIs will be using two Google APIs, one for Google Drive and one for Google Sheet.
And I'll show you how to set those up in the next lecture.
Then we need a method for interacting with a Google sheet.
Whether we want to read a Google sheet or append Uru data clear cells.
We'll be going with a pen here.
So I'm going to set that now like that.
Then we need a spreadsheet ID not the name but a spreadsheet ID.
We can grab that once we have created a new sheet and then we need the location where the append will
begin.
So the first cell from where the node will append its data and then from then onwards it will be using
the next available row.
And then we give this note a name.
I'll do that now and not call it the log cheat sheet.
All right.
So in order to actually make this work, we need to go to the Google API dashboard and create the necessary
credentials for this node and she can say we need to apply them up here in the first dropdown.
I already have some credentials, but I'm going to create brand new ones, demonstrate the process.
But before we move on to the next lecture to do that, what I want to do is to import my existing version
to flow into version three.
So to do that, I will go and first select the version to Node Tab and then click on Export from the
burger menu.
And I want to export the current flow that I'm looking at right here.
So it's selected, say, copied to clipboard.
So now I'm going to import this flow that I've got in the clipboard, back in the burger menu, select
import, click on paste and I'm going to put this in the new flow.
Just a quick note here.
I have tried to import the flow that I've got in a clipboard.
I've just pasted here in the current flow.
And that actually has failed.
Every time that I've selected the current flow option, it actually created a new flow anyway.
So I think there's a small bug here.
Just to keep in mind, if you are trying to paste in an existing flow, so just got into new flow and
import.
And there is the new slogan, I'm going to make a few changes with a name so you can make this one old
so there's no conflict and rename.
The new version 2.0, version three, so I can start making modifications to it and I'm going to try
and copy my Google Sheet nerved.
Like this to my nephew posted in here and here it is, so I can just delete the old photos.
So there's my version three, I'm going to enable it.
And we'll continue my work here to extend it.
But first, as I said, let's go over to the next lecture and create the credentials for the Google
sheet and of course, a new Google sheet to knock out.