excel-script-lab-completion.ts

/**
 * @customfunction
 */
async function completion(content: string) {
  const response = await fetch("https://api.openai.com/v1/chat/completions", {
    method: "POST",
    headers: {
      "Content-Type": "application/json",
      "Authorization": "Bearer <OPENAI_API_KEY>"
    },
    body: JSON.stringify({
      model: "gpt-4o",
      temperature: 0,
      messages: [
        {
          role: "system",
          content
        }
      ]
    })
  });

  const result = await response.json();
  return result["choices"][0]["message"]["content"];
}