1
00:00:00,660 --> 00:00:07,710
Pie in this picture, I'm going to show you how to install and set up the sheet node, which does not

2
00:00:07,710 --> 00:00:11,720
come with the need for the installation of note.

3
00:00:12,000 --> 00:00:19,440
So we're going to have to install it separately now because I want to show you exactly how to add to

4
00:00:19,440 --> 00:00:23,020
the existing version to flow that we created in the previous section.

5
00:00:23,370 --> 00:00:31,040
I'm going to clean up my version three flow here and then copied version two into version three and

6
00:00:31,230 --> 00:00:33,000
continue building it from that point.

7
00:00:33,210 --> 00:00:42,000
So I'm going to do select everything and just hit the delete key to clean up this flow and deploy my

8
00:00:42,030 --> 00:00:43,220
empty flow now.

9
00:00:43,530 --> 00:00:48,360
And as you can see, my node read dashboard is now totally empty.

10
00:00:48,810 --> 00:00:55,030
And let's go ahead and have a look at how to install the sheet node or any new node.

11
00:00:55,030 --> 00:00:59,490
The 20 story from the available nodes that node read provides.

12
00:00:59,910 --> 00:01:06,990
So to do that, go to the top right menu that the Berga menus is called and open up the managed permit

13
00:01:07,500 --> 00:01:08,100
window.

14
00:01:08,430 --> 00:01:14,200
And you can see here I've got the node read Google Sheets already installed.

15
00:01:14,670 --> 00:01:23,250
So if it was not installed, what you would do would be to go into the install tab and then search for

16
00:01:23,250 --> 00:01:24,570
a cheat sheet.

17
00:01:24,820 --> 00:01:31,980
As you can see here, because I've already installed the sheet mode in my note read instance, it's

18
00:01:31,980 --> 00:01:33,300
marked this installed.

19
00:01:33,300 --> 00:01:39,270
But instead, in your case, you have a button here saying install, just click on it.

20
00:01:39,270 --> 00:01:41,700
To have this new node installed.

21
00:01:42,090 --> 00:01:48,420
I show you how to install a node that is not already on my instance of node red.

22
00:01:48,660 --> 00:01:53,400
So, for example, let's search for nodes relevant to if this and that.

23
00:01:53,940 --> 00:01:59,910
So just search for if this and that and this one, PTB, if this and that is known about the user to

24
00:01:59,910 --> 00:02:03,900
use the channel, make a trigger of if this, then that.

25
00:02:04,230 --> 00:02:09,000
And there's another one down here, the alerted to connect to the if this doesn't that make a channel.

26
00:02:09,040 --> 00:02:14,730
I don't know exactly what these nodes would do, but I'm just going to store them anyway and do some

27
00:02:14,730 --> 00:02:15,350
exploration.

28
00:02:15,400 --> 00:02:20,490
I don't want to click on Install and wait for a few seconds.

29
00:02:31,500 --> 00:02:38,040
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

30
00:02:38,040 --> 00:02:38,480
to see.

31
00:02:38,760 --> 00:02:44,880
So we can go back into the nodes tab and have a look for if this and that can see this is the brand

32
00:02:44,880 --> 00:02:47,580
new node and it comes with two components.

33
00:02:47,890 --> 00:02:53,400
If this is that key and then if they send that out, we may have a chance to play around with this one

34
00:02:53,400 --> 00:02:54,010
later on.

35
00:02:54,540 --> 00:02:59,800
For now, let's have a look at the sheet nodes.

36
00:02:59,820 --> 00:03:05,760
I'm going to search for it and then drop it onto my version.

37
00:03:05,760 --> 00:03:10,660
Three, Slow Convis and double click to have a look at what it's like.

38
00:03:10,680 --> 00:03:20,580
So what this node requires for you to operate is the credentials from Google Drive or actually the Google

39
00:03:20,580 --> 00:03:26,460
APIs will be using two Google APIs, one for Google Drive and one for Google Sheet.

40
00:03:26,460 --> 00:03:29,360
And I'll show you how to set those up in the next lecture.

41
00:03:30,000 --> 00:03:33,960
Then we need a method for interacting with a Google sheet.

42
00:03:33,960 --> 00:03:38,930
Whether we want to read a Google sheet or append Uru data clear cells.

43
00:03:39,540 --> 00:03:42,200
We'll be going with a pen here.

44
00:03:42,480 --> 00:03:44,160
So I'm going to set that now like that.

45
00:03:44,700 --> 00:03:49,440
Then we need a spreadsheet ID not the name but a spreadsheet ID.

46
00:03:49,440 --> 00:03:56,280
We can grab that once we have created a new sheet and then we need the location where the append will

47
00:03:56,280 --> 00:03:56,790
begin.

48
00:03:57,000 --> 00:04:06,150
So the first cell from where the node will append its data and then from then onwards it will be using

49
00:04:06,150 --> 00:04:07,800
the next available row.

50
00:04:08,010 --> 00:04:09,800
And then we give this note a name.

51
00:04:09,810 --> 00:04:17,040
I'll do that now and not call it the log cheat sheet.

52
00:04:18,860 --> 00:04:19,460
All right.

53
00:04:21,040 --> 00:04:28,900
So in order to actually make this work, we need to go to the Google API dashboard and create the necessary

54
00:04:28,900 --> 00:04:35,580
credentials for this node and she can say we need to apply them up here in the first dropdown.

55
00:04:36,100 --> 00:04:40,650
I already have some credentials, but I'm going to create brand new ones, demonstrate the process.

56
00:04:41,050 --> 00:04:48,820
But before we move on to the next lecture to do that, what I want to do is to import my existing version

57
00:04:48,820 --> 00:04:51,460
to flow into version three.

58
00:04:51,880 --> 00:05:00,550
So to do that, I will go and first select the version to Node Tab and then click on Export from the

59
00:05:00,550 --> 00:05:01,390
burger menu.

60
00:05:01,840 --> 00:05:06,320
And I want to export the current flow that I'm looking at right here.

61
00:05:06,340 --> 00:05:10,120
So it's selected, say, copied to clipboard.

62
00:05:10,960 --> 00:05:17,500
So now I'm going to import this flow that I've got in the clipboard, back in the burger menu, select

63
00:05:17,500 --> 00:05:22,030
import, click on paste and I'm going to put this in the new flow.

64
00:05:22,690 --> 00:05:23,970
Just a quick note here.

65
00:05:24,160 --> 00:05:29,890
I have tried to import the flow that I've got in a clipboard.

66
00:05:29,890 --> 00:05:32,320
I've just pasted here in the current flow.

67
00:05:32,890 --> 00:05:34,990
And that actually has failed.

68
00:05:34,990 --> 00:05:40,330
Every time that I've selected the current flow option, it actually created a new flow anyway.

69
00:05:40,330 --> 00:05:42,490
So I think there's a small bug here.

70
00:05:42,490 --> 00:05:49,750
Just to keep in mind, if you are trying to paste in an existing flow, so just got into new flow and

71
00:05:49,750 --> 00:05:50,290
import.

72
00:05:53,520 --> 00:06:01,260
And there is the new slogan, I'm going to make a few changes with a name so you can make this one old

73
00:06:01,350 --> 00:06:03,480
so there's no conflict and rename.

74
00:06:04,720 --> 00:06:12,970
The new version 2.0, version three, so I can start making modifications to it and I'm going to try

75
00:06:12,970 --> 00:06:15,580
and copy my Google Sheet nerved.

76
00:06:17,800 --> 00:06:27,200
Like this to my nephew posted in here and here it is, so I can just delete the old photos.

77
00:06:28,660 --> 00:06:31,660
So there's my version three, I'm going to enable it.

78
00:06:33,020 --> 00:06:36,440
And we'll continue my work here to extend it.

79
00:06:36,740 --> 00:06:42,530
But first, as I said, let's go over to the next lecture and create the credentials for the Google

80
00:06:42,530 --> 00:06:45,140
sheet and of course, a new Google sheet to knock out.