// Constants const API_KEY = "A TE API KULCSOD"; const MODEL_TYPE = "gpt-3.5-turbo"; //chatGPT model // Creates a custom menu in Google Sheet function onOpen() { SpreadsheetApp.getUi().createMenu("ChatGPT") .addItem("Kulcsszó generálás", "generateKeywords") .addItem("Google Adwords", "generateAdCopy") .addToUi(); } function generateAdCopy() { const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); const selectedText = sheet.getActiveRange().getValue(); const prompt = "Generálj 5 Google Adwords verziót ehhez a kulcsszóhoz : " + selectedText; const temperature = 0; const maxTokens = 2050; const requestBody = { model: MODEL_TYPE, messages: [{role: "user", content: prompt}], temperature, max_tokens: maxTokens, }; const requestOptions = { method: "POST", headers: { "Content-Type": "application/json", Authorization: "Bearer " + API_KEY, }, payload: JSON.stringify(requestBody), }; const response = UrlFetchApp.fetch("https://api.openai.com/v1/chat/completions", requestOptions); const responseText = response.getContentText(); const json = JSON.parse(responseText); const generatedText = json['choices'][0]['message']['content']; Logger.log(generatedText); sheet.getRange(sheet.getLastRow() + 1, 1).setValue(generatedText.toString()); } function generateKeywords() { const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); const selectedText = sheet.getActiveRange().getValue(); const prompt = "Generálj 10 ehhez hasonló Kulcsszót : " + selectedText; const temperature = 0; const maxTokens = 2050; const requestBody = { model: MODEL_TYPE, messages: [{role: "user", content: prompt}], temperature, max_tokens: maxTokens, }; const requestOptions = { method: "POST", headers: { "Content-Type": "application/json", Authorization: "Bearer " + API_KEY, }, payload: JSON.stringify(requestBody), }; const response = UrlFetchApp.fetch("https://api.openai.com/v1/chat/completions", requestOptions); const responseText = response.getContentText(); const json = JSON.parse(responseText); const generatedText = json['choices'][0]['message']['content']; Logger.log(generatedText); sheet.getRange(sheet.getLastRow() + 1, 1).setValue(generatedText.toString()); }