How to use GPT in Google Sheets and increase your productivity

This content is generated from the audio voiceover so it may contain errors.

Transcript:
Hello, I’m Stan from GPT for Sheets and Docs, and today I’m going to teach you how to set up your API key once you’ve installed the GPT for Sheets and Docs add-on. So, first things first, make sure you’ve installed the add-on. Go to extensions, and you should see GPT for Sheets and Docs. Or from the Google Docs extensions, you should see it here. If you don’t see it, watch my video where I teach you how to install it.

Let’s get back to the API key. Before trying to set it up, and I repeat, this is just a one-time operation, you don’t need to do it every time you want to use the add-on in a new spreadsheet or document, you need to make sure you’re in a dedicated Chrome profile with only one Google account logged in. What does this mean? It means that if you click on your avatar in the upper right corner, you should only see one account here. If you see more accounts, unfortunately, you risk running into a multi-account issue that affects all Google add-ons. So, you’ll need to create a new Chrome profile just for that account. It only takes a minute. I can put a link in the video description with clear instructions on how to do it. And then you need to make sure you have an active OpenAI account. Be careful with expired or inactive free trials. What does this mean? It means that, first of all, you need an OpenAI account.

So, if you go to platform.openai.com/overview and you don’t have an account, you’ll need to sign up. I’ll log in, and I’ll use my Google account. I’m logged in, and now, to make sure my account is active, I’ll go to the “playground” and type “hello” here, click “submit,” and I get a response. This means my account is active. If you get an error, it will appear here instead of finding “10gbt,” and you’ll get a red banner telling you that you have a billing problem. If you run into that issue, it’s very easy to solve. You can go to your account here and then manage your account, go to billing, and if you’re the owner of your account, you’ll be able to click a button to set a payment method. So, you’ll be able to do this, then go back to the “playground,” test it again, and once it works, you can move on to the next steps.

The next step is to create an API key. For this, go again, click on the top right, click on “view API keys,” and then “create a new secret key.” By the way, I’ll delete this key at the end of the video. So, copy it, and then you can either go to extensions here in a spreadsheet and then “set API key,” and here you can check, “it’s valid.” This means there are no typos. However, it doesn’t mean the API key is active. You need to make sure of that by going to the “playground” to ensure your account is active, and then I’ll save. I could have done exactly the same thing from Google Docs here, “set API key,” and here, since I’ve just set one, it tells me an API key has already been set.

Now I’ll test that it works. For this, it’s very easy. In a spreadsheet, I need to enable GPT functions first, and this enabling needs to be done on every new spreadsheet you want to use the add-on in. And then I’ll type “gbt” and simply say “hello.” If the API key is correctly set, it will respond, and now I can ask it anything. So, GPT, write a tagline for a car shop, for example, and there we go. Okay, thank you for listening. I hope this small procedure is easy enough to follow for you. Don’t hesitate to ask questions in the comments if you have any. Thank you for listening.