Username Taken wrote: ↑Sat Feb 18, 2023 3:46 pm

For the less tech savvy among us the above is a way to embed an existing LLM.

I actually used the ChatGPT API to embed ChatGPT into a Google Sheet so I could generate student report comments.

The JavaScript to create the function "GPT(question you ask ChatGPT)"

/**
* GPT-3 and Google Sheets
*
* @param {string} prompt Prompt.
* @param {number} temperature (Optional) Temperature.
* @param {string} model (Optional) GPT-3 Model.
* @return Response returned by GPT-3.
* @customfunction
*/

const SECRET_KEY = "key for ChatGPT";
const MAX_TOKENS = 200;
const MODEL_NAME = "text-davinci-003"; // more structured and deterministic: for data
//const MODEL_NAME = "davinci"; // more flexible and creative: for stories, chatbots
const MODEL_TEMP = 0.7;

function GPT(prompt) {
const url = "https://api.openai.com/v1/completions";
const payload = {
model: MODEL_NAME,
prompt: prompt,
temperature: MODEL_TEMP,
max_tokens: MAX_TOKENS,
};
const options = {
contentType: "application/json",
headers: { Authorization: "Bearer " + SECRET_KEY },
payload: JSON.stringify(payload),
};
const res = JSON.parse(UrlFetchApp.fetch(url, options).getContentText());
return res.choices[0].text.trim();
}

The above wasn't even the tricky part lol
That was using a pre-made table of suitable comments and joining them together in a coherent way such that correct gender pronouns and possessive pronouns were used. I set all the comments to be missing gender pronouns at the start of sentences and then wrote a function that search for the string ". " (a period followed by a space). Then another that replaced "his" with "her" depending on a user selection.



There is another sheet where the correct pronouns etc are swapped in but not shown.

After discussing time spent per student the above system... 2 per hour, the above system can increase this to 5 or 6 per hour