google-apps-script - 在 Google 电子表格上集成 OpenAI

Question

我正在创建一个简单的脚本来通过 Google App Script 调用 OpenAI API，并同时向其发送多个提示以在 B 列中写入答案:为此，我使用 A 列中的提示创建了一个数组，我循环调用 API 并在 B 列中写入值。

这是代码:

function gpt3_response(){
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheets()[0];
  var ufila = sheet.getLastRow();
  var range = SpreadsheetApp.getActiveSpreadsheet().getRange("A2:A" + ufila);
  var vector = range.getValues().flat();
  var API_KEY = "XXXXX";
  var data = {
    "model": "text-davinci-003",
    'max_tokens': 220,
    'temperature': 0,
  };
  var options = {
    'method' : 'post',
    'contentType': 'application/json',
    'payload' : JSON.stringify(data),
    'headers': {
      Authorization: 'Bearer ' + API_KEY,
    },
  };
  const recorreArray = vector => vector.forEach((prompt, index) => {
    data['prompt'] = prompt;
    response = UrlFetchApp.fetch(
      'https://api.openai.com/v1/completions',
      options,
    )
    var respuesta = JSON.parse(response.getContentText())['choices'][0]['text'];
    sheet.getRange(`B${index + 2}:B${index + 2}`).setValue(respuesta);
  });
  recorreArray(vector);
}

然而，响应是:

package com.example.demo.controller;

import com.example.demo.model.User;
import com.example.demo.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import java.util.List;

@RestController
@RequestMapping(""/user"")
public class UserController {

    @Autowired
    private UserService userService;

    @GetMapping(""/all"")
    public List<User> getAllUsers(){
        return userService.getAllUsers();
    }

    @PostMapping(""/add"")
    public void addUser(@RequestBody User user){
        userService.addUser(user);
    }

    @PutMapping(""/update"")
    public void updateUser(@RequestBody User user){
        userService.updateUser(user);
    }

    @DeleteMapping

有人知道发生了什么事吗？如果我只使用一个提示调用 API，则响应正常，但是当我尝试多次循环调用 API 时，响应就是我在顶部显示的内容

我正在尝试通过一个同时有许多提示的循环调用 OpenAI API，并将每个响应写在 B 列上

Answer 1

function OpenAI_Ask(API_KEY, Model, Prompt, Temperature, Tokens) {
  // Set the API endpoint for ChatGPT
  var apiEndpoint = "https://api.openai.com/v1/completions";

  // Set the options for the API call
  var options = {
  "headers": {
    "Content-Type": "application/json",
    "Authorization": "Bearer " + API_KEY
    },
  "payload": JSON.stringify(
    {
    "model": Model,
    "prompt": Prompt,
    "max_tokens": Tokens
    },
  ),
  "method": "POST",
  "temperature": Temperature
  };

  // Make the API call to ChatGPT
  var response = UrlFetchApp.fetch(apiEndpoint, options);

  // Parse the response from ChatGPT
  var responseObject = JSON.parse(response.getContentText());

  // Print the generated text from ChatGPT
  var Choice = responseObject.choices[0].text;
  return Choice;
}

function OpenAI_Test()
{
  var API_KEY = 'YOUR-API-KEY-HERE'; ;
  var PROMPT  = 'What is your favorite color?';
  var MODEL   = 'text-davinci-003';
  var TEMPERATURE = 0.5;
  var TOKENS   = 200;
  var Answer = OpenAI_Ask(API_KEY, MODEL, PROMPT, TEMPERATURE, TOKENS);
  Logger.log(Answer);
}

有一个示例 Google 表格，您可以使用代码和测试工具进行复制 here .