video1.0<iframe src="https://www.loom.com/embed/a1ffe7fabcf8467a9a17ffef92602108" frameborder="0" width="1280" height="960" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>9601280Loomhttps://www.loom.com9601280https://cdn.loom.com/sessions/thumbnails/a1ffe7fabcf8467a9a17ffef92602108-00001.gif126.772GPTs in Sheets Using our ScriptBelow is our script for you to copy and paste:
// The two functions used in cell references are defined below
// A cell with =GPT(A2) will return contents in cell A2 using faster gpt-3.5-turbo
// and a cell with =GPT4(A2) in a cell will do the same but using the more powerful gpt-4 model.
function GPT(input) {
return gptCommon(input, "gpt-3.5-turbo");
}
function GPT4(input) {
return gptCommon(input, "gpt-4");
}
// common function dealing with the aip calls using the model needed
function gptCommon(input, model) {
const GPT_API = "YOUR-OPEN-AI-API-KEY"; //your Open AI API key goes here.
const BASE_URL = "https://api.openai.com/v1/chat/completions";
const headers = {
"Content-Type": "application/json",
"Authorization": `Bearer ${GPT_API}`
};
const options = {
method: "POST", // GET also works
muteHttpExceptions: true,
headers: headers,
payload: JSON.stringify({
model: model,
messages: [
{ "role": "system", "content": "" },
{ "role": "user", "content": input }
],
temperature: 0.2 // value between 0 and 1 think of it like 0 very conservative and 1 excentric for B2B we suggest 0.2.
})
};
const response = JSON.parse(UrlFetchApp.fetch(BASE_URL, options));
console.log(response.choices[0].message.content);
return response.choices[0].message.content;
}