WEBVTT 00:00.120 --> 00:06.880 Okay, now I press the plus button here by tool, and I'm going to search for sheets and open the Google 00:06.880 --> 00:09.440 Sheets tool like so. 00:09.680 --> 00:10.560 Here it is. 00:10.760 --> 00:15.640 This is how we give our LLM the ability to access a Google Sheet. 00:15.640 --> 00:18.080 So it starts by saying credential to connect with. 00:18.120 --> 00:20.040 We're going to say create new credential. 00:20.040 --> 00:25.840 And this is where we're going to hook up our n810 running the cloud with our Google Sheets. 00:26.040 --> 00:29.160 And this is something which could be really really challenging. 00:29.160 --> 00:32.400 Sometimes some of the integrations we do this step is going to be challenging. 00:32.640 --> 00:36.880 In the case of Google Sheets in particular, it's actually really simple. 00:36.880 --> 00:41.760 There's just a sign in with Google button right here and ignore any of this stuff. 00:41.760 --> 00:44.240 Just press the sign in with Google button. 00:44.240 --> 00:46.840 If you're doing this on the self-hosted version, it's a bit more involved. 00:46.840 --> 00:51.960 But for now, we're just going to press this sign in with Google button, and up comes like a Google 00:51.960 --> 00:53.280 auth screen like this. 00:53.280 --> 01:01.080 And I'm just going to press my Google auth like so I'm going to say continue and connection successful 01:01.160 --> 01:01.800 appears. 01:01.800 --> 01:03.520 I'm going to close this down. 01:03.520 --> 01:06.320 And there's a green box that says Account connected. 01:06.320 --> 01:07.200 Come on. 01:07.240 --> 01:08.880 It could be much simpler than that. 01:08.920 --> 01:13.200 We are connected and cloud is connected to our Google Sheet. 01:13.240 --> 01:16.480 Well, it's connected to our Google Sheets for our account. 01:16.480 --> 01:19.280 We haven't connected it to a specific sheet yet. 01:19.520 --> 01:19.840 All right. 01:19.840 --> 01:22.600 So now press the X button here to come back to this screen. 01:22.600 --> 01:25.000 So this is now saying it's connected. 01:25.040 --> 01:27.960 The tool description will leave it set automatically. 01:27.960 --> 01:31.560 The resource we're going to say sheet within a document. 01:31.720 --> 01:34.520 Operations for this one is going to be like get rows. 01:34.560 --> 01:40.560 And now we choose the document and the sheet from this drop down uh, of of all of the Google Docs, 01:40.680 --> 01:42.960 uh, that it has access to all of the sheets. 01:42.960 --> 01:49.000 So I've just selected portfolio from, from this list right here, which is the one that we just created. 01:49.160 --> 01:53.760 And now the sheet there only is one sheet in here I'm selecting sheet one. 01:53.760 --> 01:54.640 And here it is. 01:54.680 --> 01:57.320 And there's there's ability to add filters and things. 01:57.320 --> 01:59.480 But we're going to leave all of that as it is. 01:59.680 --> 02:03.770 Um and so this is our tool that is is available now. 02:04.050 --> 02:06.210 So we now go back to this screen we've got. 02:06.250 --> 02:06.810 We've got this. 02:06.850 --> 02:10.930 We'll clear this chat and we're going to have a quick chat with our sheet. 02:10.970 --> 02:11.290 Okay. 02:11.330 --> 02:12.370 So I'm going to clear the chat. 02:12.410 --> 02:14.170 Let's let's say uh hi there. 02:16.090 --> 02:16.490 All right. 02:16.490 --> 02:17.330 It's thinking about that. 02:17.330 --> 02:17.690 Hello. 02:17.690 --> 02:18.770 How can I assist you today. 02:18.810 --> 02:26.610 All right I'm going to say please describe the sheet that you have access to read. 02:28.170 --> 02:29.130 We'll see what it tells us. 02:29.130 --> 02:32.290 It's going to connect hopefully to Google Sheets. 02:32.490 --> 02:34.130 And it's doing some stuff. 02:34.650 --> 02:39.250 And it's saying the sheet contains stock information with the following columns and data ticker quantity 02:39.290 --> 02:39.770 price. 02:40.050 --> 02:42.250 And then it says Google quantity three. 02:42.290 --> 02:44.490 Apple quantity two Tesla quantity three. 02:44.930 --> 02:45.850 There we have it. 02:45.890 --> 02:50.850 We have successfully connected our Naa10 agent to a Google sheet. 02:50.850 --> 02:56.370 And it took minutes, maybe even seconds if you were following along fast if you sped me up. 02:56.530 --> 02:57.050 All right. 02:57.090 --> 02:58.610 Now let's make it do something. 02:58.610 --> 03:00.050 I'm sure you can guess what we're gonna do. 03:00.090 --> 03:01.210 I'm going to move this over here. 03:01.210 --> 03:02.810 I'm going to add in another tool. 03:02.930 --> 03:05.090 The tool I'm going to add is called Market Stack. 03:05.090 --> 03:06.770 Remember that we did that yesterday. 03:07.010 --> 03:07.890 Select that. 03:07.890 --> 03:09.610 Now we're getting faster at this point. 03:09.610 --> 03:10.490 You know what we're doing. 03:10.490 --> 03:12.330 We've got the credential right here. 03:12.330 --> 03:16.010 We're going to say uh the tool description is automatic resources. 03:16.010 --> 03:16.970 End of day data. 03:17.130 --> 03:18.690 The operations get many. 03:18.730 --> 03:20.810 The ticker is to be set by the model. 03:20.810 --> 03:22.290 You click that purple button. 03:22.530 --> 03:28.210 Uh, we will say um, that we want to add a filter, the latest turn that on. 03:28.490 --> 03:32.890 And that I believe is all we need for getting stock data. 03:32.930 --> 03:34.530 Now we're going to add another tool. 03:34.530 --> 03:35.970 Let's just rearrange this a little bit. 03:36.010 --> 03:36.970 Let's put that there. 03:37.130 --> 03:38.810 Let's move the market data there. 03:38.850 --> 03:40.050 Let's press the plus button. 03:40.050 --> 03:40.970 That's just to tidy up. 03:40.970 --> 03:41.770 It doesn't matter. 03:42.010 --> 03:45.690 And now we're going to go and have another sheet a Google Sheets tool. 03:45.930 --> 03:48.810 This time it's going to be a resource. 03:48.970 --> 03:49.890 It's going to be sheets. 03:49.890 --> 03:51.930 The operation is not going to be get row. 03:52.290 --> 03:54.770 It's going to be update row. 03:55.010 --> 03:56.090 Uh okay. 03:56.290 --> 03:58.730 Uh let's select the document. 03:58.730 --> 04:03.650 And so I just gone to this from list and I chose the portfolio document, which is the sheet that we 04:03.650 --> 04:04.730 want to update. 04:04.770 --> 04:08.250 The sheet itself we're going to choose will of course be sheet one. 04:08.610 --> 04:09.170 Okay. 04:09.370 --> 04:10.530 This is important. 04:10.570 --> 04:15.170 This is when we tell what is it that we want to update in this sheet. 04:15.210 --> 04:17.730 And it knows about the the columns in our table. 04:17.730 --> 04:18.450 Let's read the sheet. 04:18.450 --> 04:21.370 And it sees it's got a ticker a quantity and a price. 04:21.530 --> 04:25.170 And the first thing we say is what column do we want to match on. 04:25.170 --> 04:30.450 So when it's picking what row to update, which column should it use to decide which is the row that 04:30.450 --> 04:31.450 I care about. 04:31.450 --> 04:33.330 And we want it to do it based on the ticker. 04:33.330 --> 04:40.090 We want to be able to our our LLM to say, I want to update Google's stock price based on the Google 04:40.130 --> 04:40.810 ticker. 04:40.810 --> 04:42.930 So that's the column to match on. 04:43.210 --> 04:49.690 And now in terms of the values to get updated, the actual fields that the LLM can specify, we don't 04:49.690 --> 04:50.530 care about quantity. 04:50.530 --> 04:51.650 I'm removing that. 04:51.690 --> 04:56.410 We want it to be able to to specify a ticker and a price. 04:56.450 --> 04:58.170 The ticker is the one that gets matched. 04:58.210 --> 05:00.490 The price is what it changes the price to. 05:00.690 --> 05:06.900 So I press this button here to say the model gets to define what ticker, and the model gets to define 05:06.900 --> 05:08.180 what price to set. 05:08.220 --> 05:11.540 And this has now defined what we want this tool to do. 05:11.580 --> 05:17.020 We want this tool to match on a ticker, to specify the ticker and to specify the price. 05:17.020 --> 05:19.060 And that price will be updated. 05:19.060 --> 05:21.220 So hopefully this makes this makes sense to you. 05:21.220 --> 05:27.340 This is how you go about telling Nan that the purpose of this tool is to be able to match on a ticker, 05:27.380 --> 05:28.700 set a price. 05:28.740 --> 05:29.540 We're done. 05:29.540 --> 05:31.460 We've created our update row. 05:31.540 --> 05:32.500 It looks a little bit messy. 05:32.500 --> 05:33.420 Let's move that over there. 05:33.420 --> 05:34.780 So now we have three tools. 05:35.260 --> 05:36.900 We've got one that gets a row. 05:36.940 --> 05:41.980 We've got one that gets market data, and we've got one that updates the row in the sheet. 05:42.020 --> 05:42.700 Okay. 05:42.740 --> 05:46.740 What I'm now going to do is I'm going to switch over to my portfolio as we have it right here. 05:46.740 --> 05:53.740 And I'm just going to detach this window like that and then just shrink it over and put it over here 05:53.740 --> 05:58.180 so we can, we can just keep an eye on the spreadsheet over here, the Google sheet. 05:58.380 --> 06:04.100 And I'm going to come back here, uh, to this screen, go back to our integrations, and I'm gonna 06:04.140 --> 06:10.580 move this cunningly over like this so we can be looking at our chats here, but also keeping a healthy 06:10.580 --> 06:14.580 eye over on the right at our Google Sheets. 06:14.780 --> 06:15.540 All right. 06:15.540 --> 06:17.460 And now I'm going to say hi there. 06:19.740 --> 06:20.340 Okay. 06:20.380 --> 06:21.140 It says hello. 06:21.140 --> 06:32.060 How may I assist you today I'm going to say please update the prices in my, uh, equity portfolio sheet 06:32.100 --> 06:37.540 to reflect the latest market prices. 06:38.180 --> 06:39.420 There's my instruction. 06:39.460 --> 06:40.340 Off it goes. 06:40.340 --> 06:40.980 Things happen. 06:40.980 --> 06:42.060 Keep your eye on the right. 06:42.100 --> 06:45.100 Keep an eye on the right hand side of the screen, please. 06:45.260 --> 06:46.260 Things are happening. 06:46.260 --> 06:47.580 Stuff is going on. 06:47.780 --> 06:49.420 Messages are spinning. 06:50.780 --> 06:51.300 Bam! 06:51.340 --> 06:52.300 You see that? 06:52.340 --> 06:53.900 The Tesla price just appeared. 06:53.980 --> 06:55.340 Apple price just appeared. 06:55.380 --> 06:57.180 Google price just appeared. 06:57.180 --> 06:58.340 It all happened. 06:58.340 --> 07:00.660 Workflow executed successfully. 07:00.740 --> 07:08.510 We just saw an agent in action, reading a sheet, collecting market data, writing the prices to our 07:08.510 --> 07:09.390 Google Sheet. 07:09.430 --> 07:10.630 Wasn't that fabulous? 07:10.830 --> 07:16.470 So what I love about this example is it feels so tangible to be able to see the stock prices change 07:16.470 --> 07:19.510 like that as we as we run it and see the spreadsheet changing. 07:19.510 --> 07:20.590 So it's really, really cool. 07:20.630 --> 07:25.750 What I want you to do now, though, is just dig in a bit more into these tools themselves to get a 07:25.750 --> 07:27.390 better sense for what was going on. 07:27.390 --> 07:28.470 And what do I mean by that? 07:28.510 --> 07:31.350 Well, you can double click on a tool like this update tool. 07:31.350 --> 07:34.710 You double click on it and it comes up with the details. 07:34.710 --> 07:37.110 And we already set this part here so we know it well. 07:37.110 --> 07:39.310 But let me show you what's on the left and the right. 07:39.310 --> 07:42.030 This is showing you the inputs and outputs. 07:42.030 --> 07:47.070 When this tool was actually called a moment ago and it was called three times. 07:47.070 --> 07:52.470 And you can tell because there's this drop down here run where there's one, two and three out of three. 07:52.710 --> 07:57.910 And if you pick something like two, then it updates on the left and the right to show you the inputs 07:57.910 --> 07:58.670 and outputs. 07:58.670 --> 08:05.430 The second time this tool was called and the inputs are shown in this this stuff on the left, which 08:05.430 --> 08:08.350 is in fact you're seeing JSON here. 08:08.350 --> 08:12.510 And some of you probably know JSON very well, but for those that don't, you will get comfortable with 08:12.510 --> 08:12.750 this. 08:12.750 --> 08:16.310 This is just a way of showing structured data like this. 08:16.430 --> 08:22.190 Um, and as it happens, anytime you see JSON like this, you can choose to either see it as JSON or 08:22.230 --> 08:24.950 say, hey, I don't want to see it as JSON, I just want to see it in a normal table. 08:24.950 --> 08:29.070 I'm more comfortable with tables, or you can see it in something called schema when you see the sort 08:29.070 --> 08:30.390 of structure of the data. 08:30.390 --> 08:32.750 But we're going to stick with JSON for now. 08:32.870 --> 08:37.350 You can see that this tool was called to update a row. 08:37.390 --> 08:40.830 It was saying please use this ticker to match Apple. 08:40.950 --> 08:43.390 And this is the thing to update the row with. 08:43.390 --> 08:48.270 And that's why on the right you can see we got back an output showing that that ticker was updated with 08:48.270 --> 08:49.070 that price. 08:49.070 --> 08:54.710 And you can flip between the three tool calls to see that it was updating each of the stock prices in 08:54.750 --> 08:55.510 that table. 08:55.510 --> 08:57.270 It all did just what we were expecting. 08:57.310 --> 08:59.990 And now I'm going to press escape click and press escape. 08:59.990 --> 09:04.150 And I'm going to show you the the Market Stack tool. 09:04.190 --> 09:04.990 Here it is. 09:05.110 --> 09:10.670 It was also called three times, shockingly, and it was called three times because it was called for 09:10.670 --> 09:11.710 the ticker Google. 09:11.710 --> 09:15.310 It was called for the ticker Apple, and it was called for the ticker Tesla. 09:15.430 --> 09:17.790 And over here on the right you can see what came back. 09:17.790 --> 09:24.670 And again you can see it in the form of JSON like this, this long bit of structured data or in a table 09:24.670 --> 09:25.310 format. 09:25.310 --> 09:30.030 And we'll see that there is an open high and low that came back for Tesla's price. 09:30.190 --> 09:34.710 And we can also flip that to to Apple and flip it to Google. 09:34.710 --> 09:38.590 And you're seeing over on the right what came back when the tool was called. 09:38.790 --> 09:41.310 And then press escape or click and press escape. 09:41.590 --> 09:43.870 And then let's go and look at this tool. 09:43.870 --> 09:45.430 Was this one called three times? 09:45.470 --> 09:46.510 No, it was not. 09:46.550 --> 09:48.510 This was only called once. 09:48.510 --> 09:50.110 This was called once. 09:50.110 --> 09:54.390 And it was just just just called with no inputs particularly. 09:54.390 --> 09:58.110 And what came back was the the table itself. 09:58.230 --> 09:59.950 I've got it selected on the table version. 09:59.950 --> 10:02.230 This is it in JSON style. 10:02.230 --> 10:04.320 You can see the JSON structure. 10:04.320 --> 10:06.880 It has this very recognizable look to it. 10:06.920 --> 10:08.760 We can look at it in a table form. 10:08.960 --> 10:11.360 And what came back is basically the table itself. 10:11.360 --> 10:15.080 The Excel spreadsheet had come back, but it came back in the form of JSON. 10:15.160 --> 10:19.600 It came back showing that we had three rows Google, Apple, Tesla and that these were the quantities, 10:19.600 --> 10:26.000 but the price was empty, which was before our our LLM decided to set the price. 10:26.200 --> 10:29.320 So this shows you the three tool calls. 10:29.600 --> 10:33.600 And I want you now to go in, dig in, have a look at this. 10:33.640 --> 10:35.000 Get a sense of what was called. 10:35.000 --> 10:35.880 Look at the JSON. 10:35.880 --> 10:36.840 Look at the table. 10:36.880 --> 10:42.600 Start to get more familiar with this build up a little bit of experience with this and you should also 10:42.640 --> 10:44.200 take this project in a new direction. 10:44.240 --> 10:46.520 Add another column, add some more information. 10:46.560 --> 10:48.760 Try try maybe adding the highs and the lows or whatever. 10:48.960 --> 10:55.200 Uh, figure out what more information you could get the LLM to set in that table and enjoy it. 10:55.240 --> 10:57.200 Watch it updating while you watch. 10:57.240 --> 10:59.080 It's such a spooky experience. 10:59.200 --> 11:04.320 Uh, and get a good sense of what it's like to use an AI agent that's hooked up to Google Sheets.