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.
Comments