GPT-3 (Generative Pre-trained Transformer 3) is an advanced natural language processing tool developed by OpenAI that can generate human-like text. It can be used for various tasks, including language translation, text summarization, and even creative writing. In this article, we will learn how to set up GPT-3 for Google Sheets and Google Docs.
Here are the steps featured in this video.
Add ChatGPT Google Sheet Extension
1) Extension
2) Add-On
3) Get add-ons
4) Search for ChatGPT
5) Install "GPT For Google Sheet and Docs"
Set ChatGPT API Key
1) Extension
2) GPT for Sheets and Docs
2) Set API key
3) Click on OpenAI hyperlink
4) Create new secret key
5) Copy API key
6) OK
7) Paste the key.
8) Save API key
ChatGPT Usage
=GPT("What state is this phone number from?",A2)
This is the hyperlink to get your ChatGPT API key.
https://platform.openai.com/account/api-keys
OpenAI, ChatGPT, GPT, AI,
How to use ChatGPT with Google Sheets,
chatgpt google sheet extension how to set api key and use it =gpt(), chatgpt google sheet extension how to set api key and use,
google gpt chat,google gpt bard,
Here are the steps featured in this video.
Add ChatGPT Google Sheet Extension
1) Extension
2) Add-On
3) Get add-ons
4) Search for ChatGPT
5) Install "GPT For Google Sheet and Docs"
Set ChatGPT API Key
1) Extension
2) GPT for Sheets and Docs
2) Set API key
3) Click on OpenAI hyperlink
4) Create new secret key
5) Copy API key
6) OK
7) Paste the key.
8) Save API key
ChatGPT Usage
=GPT("What state is this phone number from?",A2)
This is the hyperlink to get your ChatGPT API key.
https://platform.openai.com/account/api-keys
OpenAI, ChatGPT, GPT, AI,
How to use ChatGPT with Google Sheets,
chatgpt google sheet extension how to set api key and use it =gpt(), chatgpt google sheet extension how to set api key and use,
google gpt chat,google gpt bard,
Category
📚
LearningTranscript
00:00If you want to add some AI to your spreadsheet like this where you have a phone number and you want the AI to find which territory or state it belongs to, like this, this is how you do it.
00:11First, you're going to go to extension and then you're going to click on add-on, get add-ons.
00:17This pop-up window comes up.
00:18On your search field, you're going to type chat GPT like this.
00:22And you're going to select chat GPT in Sheets and Dockings.
00:25Click on it and install this one here.
00:28I've already installed mine, so I'm not going to install.
00:30Once the installation is complete, I'm going to close this.
00:33Next thing you're going to have to do is to set your API key.
00:36Go extension and then go GPT for Sheet and set API key.
00:42Click on this guy here and then a pop-up window will appear.
00:46Click on this hyperlink here.
00:47It will open up the OpenAI API key management tool.
00:51In here, you're going to create a new secret key.
00:54Copy this secret key and click OK.
00:56And then after that, go to your Google Sheet, go here, and you're going to paste that secret key.
01:03And then click on save API.
01:05You can check if you like.
01:06It will come back obviously as good because I just generated the API key and save API key.
01:11Once that's done, you can enter the GPT formula by typing equal GPT and in open parenthesis, double quote.
01:22And in here, you're going to ask the question, what state is this phone number from?
01:30Question mark, close parenthesis.
01:33And the second argument would be the phone number.
01:36This guy here, which is A2 and you close parenthesis and hit enter.
01:41What it does is that it goes into OpenAI and try to find out what the phone number is.
01:46And this is from Alberta, Canada.
01:48So you can copy the same formula and apply the same formula the rest of your rows like this.