google sheets AI de Teamplatino

=========================================
Este escript es para meterlo dentro de los AppScripts del google sheet. Sacado de Teamplatino https://teamplatino.com/club/clase/creando-webs-automaticas-con-ia-scrapeando-descargas-by-josma/ cometaro de "growmedia"
========================================
Es copiar->pegar el codigo y para ejecutarlo:
=openai (A1;"gpt-3.5-turbo";"")
A1: La celda del prompt
gpt3.5-turbo: El modelo a usar, puedes probar otros
IMPORTANTE: El ultimo es para meter un prompt de sistema, para dar un rol si es que lo usais.
=========================================
function openai(cellContent, modelo, systemprompt) {
  var url = 'https://api.openai.com/v1/chat/completions';
  var headers = {
    "Content-Type": "application/json",
    "Authorization": "Bearer xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"
  };

  var data = {
    "model": modelo,
    "messages": [
      {
        "role": "system",
        "content": systemprompt
      },
      {
        "role": "user",
        "content": cellContent // Or replace this with your actual question
      }
    ]
  };

  var options = {
    "method" : "post",
    "headers": headers,
    "payload" : JSON.stringify(data)
  };

  var response = UrlFetchApp.fetch(url, options);
  var json = JSON.parse(response.getContentText());

  return json.choices[0].message.content; // This will return the answer from GPT-3.5-turbo
}