【GPT-4-Turbo】ChatGPTとGoogle Spreadsheetを連携！

function requestGpt4Completion(prompt) {
  // Get the OpenAI API key set in the Script Properties
  const apiKey = PropertiesService.getScriptProperties().getProperty('APIKEY');
  const customInstructions = PropertiesService.getScriptProperties().getProperty('CUSTOM_INSTRUCTIONS');
  // Set the API endpoint for GPT-4
  const apiUrl = 'https://api.openai.com/v1/chat/completions';
  // Define the message to send to GPT-4 (only user role's post)
  const messages = [{'role': 'system', 'content': ''},
                    {'role': 'user', 'content': prompt}];
  // Set the necessary header information for the OpenAI API request
  const headers = {
    'Authorization': 'Bearer ' + apiKey,
    'Content-type': 'application/json'
  };
  // Set the options for GPT-4 model, token limit, and prompt
  const options = {
    'muteHttpExceptions': true,
    'headers': headers,
    'method': 'POST',
    'payload': JSON.stringify({
      'model': 'gpt-4-turbo',
      'max_tokens': 2048,
      'temperature': 0.7,
      'messages': messages
    })
  };
  // Send the API request to OpenAI's GPT-4 and store the result in a variable
  const response = UrlFetchApp.fetch(apiUrl, options);
  const responseData = JSON.parse(response.getContentText());

  // Check if the response is successful and has the expected data
  if (response.getResponseCode() === 200 && responseData.choices && responseData.choices.length > 0) {
    return responseData.choices[0].message.content;
  } else {
    // Log error or return a default error message
    console.error('Failed to fetch response:', responseData);
    return "Error: Failed to fetch response from API.";
  }
}

function requestGpt4Completion(prompt) {

  // Get the OpenAI API key set in the Script Properties

  const apiKey = PropertiesService.getScriptProperties().getProperty('APIKEY');

  const customInstructions = PropertiesService.getScriptProperties().getProperty('CUSTOM_INSTRUCTIONS');

  // Set the API endpoint for GPT-4

  const apiUrl = 'https://api.openai.com/v1/chat/completions';

  // Define the message to send to GPT-4 (only user role's post)

  const messages = [{'role': 'system', 'content': ''},

                    {'role': 'user', 'content': prompt}];

  // Set the necessary header information for the OpenAI API request

  const headers = {

    'Authorization': 'Bearer ' + apiKey,

    'Content-type': 'application/json'

  };

  // Set the options for GPT-4 model, token limit, and prompt

  const options = {

    'muteHttpExceptions': true,

    'headers': headers,

    'method': 'POST',

    'payload': JSON.stringify({

      'model': 'gpt-4-turbo',

      'max_tokens': 2048,

      'temperature': 0.7,

      'messages': messages

    })

  };

  // Send the API request to OpenAI's GPT-4 and store the result in a variable

  const response = UrlFetchApp.fetch(apiUrl, options);

  const responseData = JSON.parse(response.getContentText());

​

  // Check if the response is successful and has the expected data

  if (response.getResponseCode() === 200 && responseData.choices && responseData.choices.length > 0) {

    return responseData.choices[0].message.content;

  } else {

    // Log error or return a default error message

    console.error('Failed to fetch response:', responseData);

    return "Error: Failed to fetch response from API.";

  }

}

​