How to Use ChatGPT in Google Sheets

?For a limited time, you can get access to my mini-course on How to Source Candidates with ChatGPT for the low price of $99. Click here to claim this offer.?

One thing about me, I don't gate-keep the fundamentals behind a paywall or email opt-in.

In this tutorial, we will explore the integration of OpenAI's GPT-3 with Google Sheets.

This simple guide will provide detailed instructions to successfully integrate these powerful tools to create your own low-code tools.

It took me less than 10 minutes to get this going.

What you'll need:

1. A credit/debit card - OpenAI requires a payment method to access their free credits.?
2. An OpenAI account - This is where you will use your credit card.
3. A Google account - You will need this to create the Google Sheet where the content will be generated.
4. Willingness to copy and paste code - No in-depth coding knowledge is necessary for this tutorial.

Step-by-Step Instructions to connect GPT technologies to Google Sheets in 10-minutes or less:

Step 1: Create a Google Sheet

Start by creating a new Google Sheet. You can name it anything you want, but for this tutorial, let's call it "[Test] OpenAI and Sheets"

Step 2: Copy the App Script Code

The next step is to copy the app script code. This code was created by a developer named Abi Raja, and can be found in the GitHub link provided. You can download the code as a zip file or simply copy it.

Step 3: Paste the App Script Code

Go back to your Google Sheet and paste the copied code into the App Script area, which can be found under "Extensions" > "App Script."?

Step 4: Update Your Secret Key

In your App Script, update the secret key on line one with your API key from OpenAI. You can obtain this API key from your OpenAI account under "View API Keys". After copying the key, paste it into the App Script window.

Step 5: Save and Run a Test Query

Once your key is pasted and saved, you're ready to run a test query. Try out the function `=ai("write a tweet about how cool AI is", 1)` to see the AI in action.

Now, you have a fully functional connection between Google Sheets and OpenAI's GPT-3. Feel free to experiment with different prompts and observe the AI's responses.

While it's a powerful tool, remember it's not perfect and you may need to do some editing. It's also important to note that GPT-3's knowledge base ends in 2020, so it may not provide accurate responses for current events.

Enjoy experimenting with your new AI tool and look forward to future tutorials on generating specific types of content drafts.

As always, feel free to ask questions or leave comments below. Happy recruiting!

??About Recruiting School

Recruiting School offers recruiting training for recruiters by recruiters.

?For a limited time, you can get access to my mini-course on How to Source Candidates with ChatGPT for the low price of $99.?Click here to claim this offer.?

For more hiring tips, subscribe to the Recruiting School Newsletter on Linkedin and for a more exclusive experience, you can sign up for?A Safe Space??, my private recruiting newsletter.

Reach out at [email protected] to learn more about our Recruiting School training program and Recruiting Playbooks designed to help build and scale your recruiting function from the ground up.