How to: Connect Open AI (GPT-3) to Google Sheets

Build your own AI content generator inside Google Sheets. Connect OpenAI's GPT-3 natural language processing algorithms directly into your spreadsheet.

#ai #chatgpt #openai

Table of Contents:
0:28 What you'll need to start
1:30 Steps to setup Gpt-3 in a Google Sheet
1:42 Create your spreadsheet
2:05 Copy the API connector code
2:19 Add the App Script code to your sheet
3:09 Update the API Secret Key
3:30 Create a new OpenAI key
4:23 The function to access GpT-3
4:42 How much will this cost?
5:03 What is the temperature?
5:39 Generating content in the spreadsheet
6:29 Improving your AI generated content
7:24 Closing thoughts and notes

[davischr]

Hey, for what it's worth, I'm just some random dude on the Internet, but I wanted to let you know that your content is really good. You have a good style. You're easy to listen to, and it's easy to follow. Thanks for putting this together and sharing it.

[Ezkanohra]

I know this is not actually the point, but I love how it uses 'revolutionising' even though you prompted for the perspective of a baseball coach (which is an American sport).

[spicer]

I Sub'd & 👍. Cause you're the 1st YTuber who didn't Sugarcoat the fact you need to spend $$ to use GPT-3.
Many countless YTbrs doesn't even mentioned this fact as they're all going for clickBait.

[tijarabilali]

Great stuff. I tried to follow other's directions to make this happen. They failed. You succeeded! Thank you.

[elmago]

Before I go any further: "I wasn't popular in high school, so i need your approval to keep going"....had me in stitches! You got my like 👍 Now DANCE MONKEY to earn my sub!!

[amir.rodz]

Well… that was amazing! Thanks for the simplicity of your explanations and taking time to put this up.

[HC-xlen]

Very clear and simple instructions for non-coders.

[ssartworks]

i find this very useful, if i update my spread sheet weekly and ask AI to output an analysis of the weekly data and also make a 5-week analysis along with a worded description and graphs.

[michaelpeters]

This is great, I thought I was missing something. So much better than using "API connector" for this purpose, which just glitches out with the formatting.

[TharinduGunawardana]

Thanks, it worked. Is it possible to give a prompt to read the cell in Google Sheets and get an out come. For an example read the keyword and suggest blog topics ...

[cherrlyn]

Helpful instructions. Thanks. I look forward to future videos.

[scenicnomad]

Great video! Endless possibilities with this.. Any security concerns with providing my API code to this script? For example, can the author of the script see it or export it?

[enricoraffaelli]

That's GREAT but... can you improve the language to gpt-3.5-turbo ?

[BrianBlairTV]

I am here to give you the approval you so desperately require. Awesome video, very useful. It would be cool to take it one step further and be able to make up the prompt out of several cells for keyword > title > meta > content outline creation. When I figure it out Ill let you know.

[kevinsozanski]

Anyway I can dynamically import value from a cell to use with the prompt?

[adz]

Why are you inserting "1" after the prompt? Mine works without inserting the number "1". Thanks!

[HamsterMazeAdventure]

Whoaaaa! Thanks a lot!
I learned something really cool today!

[dieforla]

Is it possible to replace davinci model with text-curie-001? If yes, how?

[PascalCoulier]

Nice, very good explanation, you rock, thanks. now, same comment as one of the comment I have read, not sure how to use this, i would rather try to connect my spreadsheet data and give me insights and create additional info, or maybe do infography from it.

[Sebastin]

Great video. A quick question tho. I'm confused as to why you would do this? Why would you pay for those functions when you get them for free at the openAI homepage? I might have missed it, but those examples you provided aren't any different from doing it at the homepage.