-: In this lesson we're gonna be talking about
integrating ChatGPT into your Google Sheets
with a simple extension.
So when you're here in Sheets, you want to go to extensions,
add-ons, get add-ons, we will search GPT.
GPT for Sheets, and here it is. Now we click install.
So if you want a step-by-step guide on how to install this,
please click the complete additional setup now.
But I will walk you through the steps
that I'm gonna take to get this to work,
so we're gonna hit done.
Now we go to extensions, GPT for Sheets. Set API key.
So now you can click this link here,
which takes you to this page,
and we are going to create new secret key,
and I obviously will not show you my key.
It will auto generate a key for you.
You can click the copy button and now we will paste it here.
Hit check and save API key.
So now you go to extensions, go here
and we want to enable GPT functions.
So we have to just type in this =GPT,
"say hi" in a cell, and we are ready to go.
So now that you've downloaded
and installed ChatGPT into your Google Sheets,
here are some really interesting use cases.
You can extract data, extract country from address,
so we have this address here,
and it knows that this is Belgium,
extract email from this text, boom, we have the email.
You can analyze sentiments,
classify the sentiment in one word.
So this is like a customer review here.
This is a really good tool for quickly synthesizing
different customer reviews.
Here we can summarize big texts of information.
This can just clean up your list,
as you can see here, removing the emoji,
removing the legal entity.
Here it added a .com.
Here it organizes an address properly.
It can help you brainstorm right here in Sheets.
You can also use this for Google Docs.
Here we can write emails.
You can change the style of the writing
that you just created.
You could translate if you're working
with multiple languages,
and you can summarize large notes
and just have ChatGPT there to help you
with creative brainstorming
if you're working on a creative project.
You only need to install the add-on once,
and then it's ready to go in both Sheets and Google Docs.
So I hope that you use this to 10x your productivity.