Hi Spreadsheeters!

Andrew from Better Sheets here with a very simple, and quick thing for you.

I say thing because it's just a piece of code but it can help you in an infinite number of ways.

Want to integrate AI?

You can use the OpenAI API. and I made a 2 minute video to show you how.

and... you can copy the code from here, or from Better Sheets.

Now do you want to be able to read the code?

Basically the function is named "ai" and then a text variable is used to fill in for the prompt you can enter in the function in sheets. Any text you add in the function in side of your cell will be used as "prompt" inside the function.

We'll get the apikey for the API call from the cell A1 in the tab named "apikey"

Then we'll add the settings like max_tokens and top_p as data. Then we'll create the payload and the headers for the API call. In this case we're using a POST api call to essentially add the prompt text to OpenAI and we'll end up getting a response that's text.

We execute the API call with UrlFetchApp.fetch() along with the options we stated earlier.

Then we'll get the response, get the text, and parse it with JSON.

Finally we'll return just the message content from the JSON we get back to we can read the text the AI gives us back.

Now do you want to be able to Master the code?

Master Spreadsheet Automation on Udemy is the course that includes learning apps script AND the OpenAI Api.

If you're already a Better Sheets member, I'd recommend Spreadsheet Automation 101 and Adventures in AI, so that you can both understand the apps script and fully use AI to it's greatest potential inside of Google Sheets.

Both of these courses are available in the one course on Udemy.

-Andrew

Your resident Google Sheets wizard at Better Sheets