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.

Watch on YouTube

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

Here's the Code (on Better Sheets)

function ai(prompt) {

var apikey = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("apikey").getRange("A1").getValue();

var role = ""

var data = {

"model": "gpt-3.5-turbo",

"messages": [{"role": "system", "content": role},

{"role": "user", "content": prompt }],

"temperature": 1,

"max_tokens": 500,

"top_p": 1,

"frequency_penalty": 0,

"presence_penalty": 0

}

var options = {

'method': 'POST',

'contentType': 'application/json',

'headers': {

'Authorization' : 'Bearer ' + apikey

},

'payload': JSON.stringify(data)

}

var answer = UrlFetchApp.fetch("https://api.openai.com/v1/chat/completions",options)

var response = answer.getContentText()

var json = JSON.parse(response)

return json.choices[0].message.content

}

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.

Master Spreadsheet Automation (on Udemy)

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.

Spreadsheet Automation 101

Adventures in AI

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

-Andrew

Your resident Google Sheets wizard at Better Sheets

Better Sheets - Free AI Integration

Want to integrate AI?

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

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

Older messages

If you want to sell a spreadsheets, you have to write a sales page

Free Course

You Can Build Web Apps with Google Sheets

How to Make a Sellable Spreadsheet

Free Tool: Spintax Updated!

You Might Also Like

How To Plant Nearly 1,000 Trees an Hour

Optimization research not driving impact?

What is the 'perfectly optimised' article for SEO?

• Book Series Promos for Authors • All in one order • FB Reader Groups + Pins

🧙‍♂️ [Sponsor Games] How Jeff made $80,000 from sponsorships (without a huge audience)

When Naptime Conflicts With Your Civic Duty?

Is Art About Money?

For Authors: Affordable Proofreading Services by ContentMo

Toys, scratching, and quantum strategies

🧙‍♂️ [FAQ] “Is Sponsor Games right for me?”