Using chatGPT / GPT / GPT-3 in Google Sheets can make some of your spreadsheets tasks faster and easier.
Here is a step-wise guide on how to use chatGPT / GPT-3 in Google Sheets.
Table of Contents
Requirements for using chatGPT / GPT / GPT-3 in Google Sheets
- First things first – you need to have a Google Account with the ability to Google Sheets.
- You need an OpenAI.com account for the purpose of getting the GPT-3 API key.
If you don’t have either or both of these currently, first go ahead and get those and then return to this article.
Setup for using chatGPT / GPT / GPT-3 in Google Sheets
- Open this Google Sheet.
- In the above opened Google sheet, from the menu bar, Click on File and then click on ‘Make a copy.
- You can close the above original Sheet and make sure you are in the copy you made for the below steps onwards.
- In your copy of Google Sheets, from the menu bar, Click on Extensions and then Apps Script. This will open a new tab or window with a Apps Script code.
- Now you need to get your GPT-3 API ket. For this log in to your OpenAI Account. Click on your profile image on the right-hand top side and choose View API Keys from the drop-down. Click on ‘create new secret ket’. Copy the secret key and save it somewhere safe.
- Go back to the App Scripts from Step 4 above and paste your GPT-3 secret in the first line between the quotes. Save the changes.
- You can go ahead and close the App Scripts tab/window.
Now you are ready to use chatGPT / GPT-3 in Google Sheets.
Using chatGPT / GPT / GPT-3 in Google Sheets
Let’s start with the two examples from the above Google sheet you copied and set it up in the previous steps.
The main thing to remember is you use it like a formula.
For example, look at the Nickname example.
Input =GPT3(“What is a nickname for the full name “&A17&”?”) in the nickname column and press enter
You will see it writes the nickname for the name next to it.
Try various examples, like city names and zip codes, translation, etc.