1
00:00:02,360 --> 00:00:02,960
Hi guys.

2
00:00:02,960 --> 00:00:03,880
Welcome to this session.

3
00:00:03,880 --> 00:00:10,200
So in this session we'll see how you can also integrate GPT ChatGPT into Google Sheets and use it from

4
00:00:10,200 --> 00:00:13,000
there in a much more seamless easy manner.

5
00:00:13,360 --> 00:00:14,800
So let's have a look at this.

6
00:00:14,960 --> 00:00:18,160
So once you're on Google Sheets you can add it like an add ons.

7
00:00:18,160 --> 00:00:22,600
So for that you can go to extensions add ons get add ons.

8
00:00:23,240 --> 00:00:26,600
And over here you can search for GPT.

9
00:00:29,040 --> 00:00:29,920
For sheets.

10
00:00:30,080 --> 00:00:32,480
So this is what we're looking for GPT for sheets.

11
00:00:34,080 --> 00:00:38,880
And now you can install this particular add on over here.

12
00:00:38,880 --> 00:00:43,120
So once you do that okay you will be able to do a lot of things.

13
00:00:43,120 --> 00:00:49,080
As you can see out here, you will be able to go ahead and apply the formulas over here okay.

14
00:00:49,120 --> 00:00:51,880
There are a lot of different ways you can have the use cases.

15
00:00:51,880 --> 00:00:58,080
So you can give the prompt specifically, and then it can give you the outputs in this particular manner.

16
00:00:58,440 --> 00:01:01,160
So you can see it will be able to give us the output.

17
00:01:01,160 --> 00:01:02,520
The results will be here.

18
00:01:02,640 --> 00:01:04,960
Specifically you can give the GPT prompt.

19
00:01:05,090 --> 00:01:07,690
you can give it generate a tagline for this product.

20
00:01:07,730 --> 00:01:09,130
Okay, you can give the value.

21
00:01:11,330 --> 00:01:16,170
In this particular way, and automatically it is going to generate the description for us.

22
00:01:16,290 --> 00:01:20,970
So you can see this is the capability of the add ons which you will get out here.

23
00:01:21,250 --> 00:01:26,930
So once you have this once you install it you will have the extension right out here.

24
00:01:26,930 --> 00:01:31,850
As you can see Google Sheets, GPT four slides or sheets which you can use.

25
00:01:31,890 --> 00:01:33,410
Let's say we are opening this.

26
00:01:33,650 --> 00:01:38,170
And then a particular prompt area will you will get on the right hand side.

27
00:01:43,010 --> 00:01:48,650
As you can see over here and from here you can give the prompt and you can get the output from here.

28
00:01:48,730 --> 00:01:52,690
So this is how GPT can be integrated into Google Sheets.

29
00:01:52,690 --> 00:01:54,850
And you can easily use it from here.

30
00:01:55,050 --> 00:01:55,850
Give it the prompt.

31
00:01:55,890 --> 00:01:57,970
Get the result on the sheet itself.

32
00:01:58,050 --> 00:02:04,090
You can also apply formula as a sheet formula which you can give as a function GPT as you saw in the

33
00:02:04,090 --> 00:02:04,850
example.

34
00:02:05,010 --> 00:02:08,650
And from there also you can get your desired outputs.