Better Sheets - a perfect use of AI

I think I found the perfect use of AI. in Google Sheets.

Categorization.

I made a video and included it in Master Spreadsheet Automation. You can get it today!

From scratch, we utilize boilerplate code and leverage the OpenAI API to automate the process. The step-by-step tutorial covers how to obtain an API key, write a prompt, and see the AI in action as it accurately assigns categories.

This should keep you more organized.

Get Master Spreadsheet Automation at the best price available for the next 4 days.

​https://www.udemy.com/course/spreadsheet-automation-101/?couponCode=EAF178A7ED8F7F38CB8C​

-Andrew

Your Resident Google Sheets Wizard

P.S.

Here's the final code:

function ai(task) {

var prompt = "Give us back only the category of the task given. Only give back either Work or Home. No other categories. for example: Task: Prepare breakfast Category:Home Task:Respond to emails Category:Work Task:Clean the living room Category:Home Task:Attend morning meeting Category:Work Task:" + task + " Cateogry:"

var apikey = "enteryourapikeyhere"

var role = ""

var data = {

"model": "gpt-4o",

"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

}