View difference between Paste ID: LP4m9kDy and HUu2vGBu

 =========================================
 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
 }