A beginner’s step-by-step guide to leveraging the power of GPT (3.5) within Google Sheets

In this article, I will walk you through a step-by-step process on how to leverage the power of GPT 3.5 through OpenAI’s ChatGPT APIs, using a very simple Google Sheets interface. We will use ChatGPT APIs to create a list of top technology trends, provide a brief overview of the technology and its benefits and also generate a list of technology providers for each of these technologies. This process can be applied to a number of other use cases such as lead generation, job search and more.

• Step 1: Login to your Google Sheets page to start a new worksheet. Use your own Google account to sign in.

• Step 2: Once you are in your Google Sheet, Click Extensions -> Add-ons -> Get add-ons as shown below:

• Step 3: in the Google Workspace Marketplace, search for “GPT for Google Sheets and Docs” and download the add-on shown above.

• Step 4: Now that we have installed the add-on, click on Extensions -> GPT for Sheets and Docs -> Enable GPT Functions

Once you do that, it will prompt you to add your API key from OpenAI. Leave this tab open. We will return to this in a moment, once we have generated and fetched the API key.

• Step 5: Create an OpenAI account by following the following steps: https://notroop.com/create-chat-gpt-account/. Once your account is created, go to https://platform.openai.com/account/api-keys and click on this button “+ Create new secret key” as shown in the screen below:

That will create an API key to link your OpenAI ChatGPT account to our sheet, and it will look like this:

Click on the green button on the right to copy that API key. Once that’s done, go back to our Google Sheets and paste that API key in the field shown below

• Step 6: The fun part! Now we have finished setting up a Google Sheet linked to Chat GPT and ready to use its functions. Let’s start with something simple:

I simply typed =GPT_List(“List the 20 top trends in tech today”) in cell A2, asking Chat GPT to spit out a table of the top 20 technology trends.

Now I typed in =GPT(concat(“write a quick overview of each technology and its benefits under 200 characters”, A2) in cell B2, requesting chat GPT to describe each one of those technology trends and provide an overview of their benefits in this spreadsheet for us.

The results will look similar to below:

Now, lets find out some more extra information.

In the next column, I wrote =GPT(concat(“name the leading providers on this technology”, A2)). This will request ChatGPT to provide an entire list of each providers for the respective technologies, listed in the previous cells.

As a side note, remember to click the small square in the right and drag down the formula to cover all the rows we want analyzed, as shown below:

And there you have it. You just created your first A.I. Chat GPT integration with a Worksheet you can use for your day-to-day tasks. Keep in mind you can customise the outputs you would like by editing the formulas we entered earlier to seek required information.

The final result from today’s exercise should look something like this:

I hope this article will help GPT and AI enthusiasts alike. Curiosity is always the driver for innovation. Keep innovating!