-
Notifications
You must be signed in to change notification settings - Fork 0
/
OpenAI_Google_Sheets.js
41 lines (36 loc) · 1.02 KB
/
OpenAI_Google_Sheets.js
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
// API KEY and variables
const apiKey = "";
const model = "text-davinci-003"
const temperature = 0.2
const maxTokens = 10
function createRequestBody(prompt) {
const requestBody = {
"model": model,
"prompt": prompt,
"temperature": temperature,
"max_tokens": maxTokens,
};
return requestBody;
}
function createRequestPayload(requestBody) {
const requestPayload = {
"method": "POST",
"headers": {
"Content-Type": "application/json",
"Authorization": "Bearer "+apiKey
},
"payload": JSON.stringify(requestBody)
}
return requestPayload;
}
// Text Completion
function ChatGPT(prompt, cell) {
prompt = prompt+cell+":"
const requestBody = createRequestBody(prompt)
const requestPayload = createRequestPayload(requestBody)
const response = UrlFetchApp.fetch("https://api.openai.com/v1/completions", requestPayload);
console.log(response.getContentText())
const responseBody = JSON.parse(response.getContentText());
const answer= responseBody.choices[0].text
return answer
}