GoogleChatからOpenAI ChatGPTをさくっと利用する

// Your OpenAI key and endpoint
const openaiKey = PropertiesService.getScriptProperties().getProperty('OPEN_AI_KEY');
const openaiEndpoint = 'https://api.openai.com/v1/chat/completions';

// Your service account details for Google Chat
const serviceAccountEmail = PropertiesService.getScriptProperties().getProperty('SERVICE_ACCOUNT_EMAIL');

const privateKey = PropertiesService.getScriptProperties().getProperty('PRIVATE_KEY').replace(/\\n/g, '\n');

const scope = 'https://www.googleapis.com/auth/chat.bot';

// The OAuth2 service for Google Chat
const service = OAuth2.createService('GoogleChat')
  .setAuthorizationBaseUrl('https://accounts.google.com/o/oauth2/auth')
  .setTokenUrl('https://accounts.google.com/o/oauth2/token')
  .setPrivateKey(privateKey)
  .setClientId(serviceAccountEmail)
  .setPropertyStore(PropertiesService.getUserProperties())
  .setScope(scope);

// The function to handle the webhook from Dialogflow
const doPost = (e) => {
  let userMessage = JSON.parse(e.postData.contents).queryResult.queryText;

  let webhookData = JSON.parse(e.postData.contents);

  let spaceId = webhookData.originalDetectIntentRequest.payload.data.event.message.space.name.split('/')[1]; // Remove the 'spaces/' prefix

  // Send user message to OpenAI GPT-3
  let openaiResponse = sendToOpenAI(userMessage);

  // Post the OpenAI response to Google Chat
  postToGoogleChat(openaiResponse, spaceId);

}

// The function to send a request to OpenAI GPT-3
const sendToOpenAI = (message) => {
  let payload = {
    "messages": [
      {
        "role": "system",
        "content": "You are a helpful assistant."
      },
      {
        "role": "user",
        "content": message
      }
    ],
    "max_tokens": 4000,
    "temperature": 0.5,
    "model": "gpt-3.5-turbo" // Updated the model name as well
  };

  let options = {
    method: 'POST',
    headers: {
      'Authorization': 'Bearer ' + openaiKey,
      'Content-Type': 'application/json'
    },
    payload: JSON.stringify(payload)
  };

  let response = UrlFetchApp.fetch(openaiEndpoint, options);
  
  let resJson = JSON.parse(response.getContentText());
  let aiMessage = resJson['choices'][0]['message']['content']; 

  return aiMessage.trim();
}


// The function to post a message to Google Chat
const postToGoogleChat = (message, spaceId) => {
  if (!service.hasAccess()) {
    Logger.log('Authentication failed.');
    return;
  }

  // Ensure the spaceId is valid
  if (!spaceId || spaceId.trim() === '') {
    Logger.log('Invalid or missing spaceId.');
    return;
  }

  // Options for UrlFetchApp
  let url = 'https://chat.googleapis.com/v1/spaces/' + encodeURIComponent(spaceId) + '/messages';
  let options = {
    method: 'POST',
    headers: {
      Authorization: 'Bearer ' + service.getAccessToken(),
    },
    contentType: 'application/json',
    payload: JSON.stringify({ "text": message }),
  };

  UrlFetchApp.fetch(url, options);
}

const testDoPost = () => {
  const testWebhookData = {
    "postData": {
      "contents": JSON.stringify({
        "responseId": "ae9985fb-a80a-46fa-95a7-26c17379409b-1b0ea404",
        "queryResult": {
          "queryText": "円周率を40桁まで出してください",
          "action": "input.unknown",
          "parameters": {},
          "allRequiredParamsPresent": true,
          "outputContexts": [
            {
              "name": "projects/withchatgpt-crur/agent/sessions/eb4322ae-45e5-324d-b8a1-145cc7da00c5/contexts/__system_counters__",
              "lifespanCount": 1,
              "parameters": {
                "no-input": 0,
                "no-match": 1
              }
            }
          ],
          "intent": {
            "name": "projects/withchatgpt-crur/agent/intents/bcad348a-fa73-4e50-83da-aa2cd5749cfe",
            "displayName": "Default Fallback Intent",
            "isFallback": true
          },
          "intentDetectionConfidence": 1,
          "languageCode": "ja"
        },
        "originalDetectIntentRequest": {
          "source": "hangouts",
          "payload": {
            "data": {
              "token": "1UW1r2_vH0p3Rnh0YMCv4Dy9Bm3VoCZAL7uKA1ZMaZ8=",
              "projectNumber": "741325218799",
              "event": {
                "token": "1UW1r2_vH0p3Rnh0YMCv4Dy9Bm3VoCZAL7uKA1ZMaZ8=",
                "eventTime": "2023-07-20T09:43:55.614031Z",
                "common": {
                  "userLocale": "ja",
                  "hostApp": "CHAT"
                },
                "type": "MESSAGE",
                "message": {
                  "space": {
                    "singleUserBotDm": true,
                    "spaceThreadingState": "UNTHREADED_MESSAGES",
                    "spaceType": "DIRECT_MESSAGE",
                    "spaceHistoryState": "HISTORY_ON",
                    "type": "DM",
                    "name": "spaces/lCPTyUAAAAE" // ここのlCPTyUAAAAE を実際のRoomIDに置き換えます
                  },
                  "sender": {
                    "avatarUrl": "https://lh3.googleusercontent.com/a/AAcHTtfN-3lO61v3GhJWShAlCGt_78QMOe7eBKv33lrAuXgOgg=k-no",
                    "email": "subaru@cloudnative.co.jp",
                    "displayName": "Subaru Ishikawa",
                    "type": "HUMAN",
                    "domainId": "3h12403",
                    "name": "users/109233687882194542877"
                  },
                  "createTime": "2023-07-20T09:43:55.614031Z",
                  "thread": {
                    "retentionSettings": {
                      "state": "PERMANENT"
                    },
                    "name": "spaces/lCPTyUAAAAE/threads/la3w4kBK8YI"
                  },
                  "text": "ほげほげ",
                  "messageHistoryState": "HISTORY_ON",
                  "argumentText": "ほげほげ",
                  "retentionSettings": {
                    "state": "PERMANENT"
                  },
                  "name": "spaces/lCPTyUAAAAE/messages/la3w4kBK8YI.la3w4kBK8YI"
                },
                "space": {
                  "spaceHistoryState": "HISTORY_ON",
                  "singleUserBotDm": true,
                  "name": "spaces/lCPTyUAAAAE",
                  "spaceType": "DIRECT_MESSAGE",
                  "type": "DM",
                  "spaceThreadingState": "UNTHREADED_MESSAGES"
                },
                "user": {
                  "email": "subaru@cloudnative.co.jp",
                  "displayName": "Subaru Ishikawa",
                  "domainId": "3h12403",
                  "type": "HUMAN",
                  "name": "users/109233687882194542877",
                  "avatarUrl": "https://lh3.googleusercontent.com/a/AAcHTtfN-3lO61v3GhJWShAlCGt_78QMOe7eBKv33lrAuXgOgg=k-no"
                },
                "configCompleteRedirectUrl": "https://chat.google.com/api/bot_config_complete?token=APz5chJ0a03U5gIkPtXRMpSt1ri2IUsQ86AaZT_czbasn-O8IrDWf4fpgSgQsQA-D5tprintQfR0xMjI4MKg7eLxuE4szqfUOMNb8p28mIgpls1mdiY3Z1xL2mAQFBY3-gc4-vuT-XTZIqltug6V6-nn9A%3D%3D"
              }
            }
          }
        },
        "session": "projects/withchatgpt-crur/agent/sessions/eb4322ae-45e5-324d-b8a1-145cc7da00c5"
      })
    }
  };

  doPost(testWebhookData);
}