This guide shows how to create a custom GPT on the OpenAI Platform that can communicate with YouAI’s Embeddings Sheet.

1. Go to https://chat.openai.com.

2. Click “Explore” in the left navigation menu.

   

3. Click “Create a GPT”.

   

4. Within your new GPT, move to the ‘Configure’ tab and enter a name for your GPT. Then, click “Create new action”.

   

5. Copy the code below, then paste it into the ‘Schema’ field.

{
  "openapi": "3.1.0",
  "operationId": "SalesAI",
  "info": {
  "operationId": "SalesAI",
    "title": "Query GPT 3.5 Turbo Fined Tuned Model",
    "description": "API for interacting with specific Google Script services for information retrieval.",
    "version": "v1.0.0"
  },
  "servers": [
    {
      "url": "<https://script.google.com>"
    }
  ],
  "paths": {
    "/macros/s/AKfycbxGZdBa1p8SUJjIpJ0lnQoIX5n6rq5E73nu8rbWZ0LjWS5TDQLBfW8rsoLsC-iI_15-/exec": {
      "get": {
        "description": "Get information from SalesAI",
        "operationId": "SalesAI",
        "parameters": [
          {
            "name": "prompt",
            "in": "query",
            "description": "Prompt for retrieving specific information from SalesAI",
            "required": true,
            "schema": {
              "type": "string"
            }
          }
        ],
        "responses": {
          "200": {
            "description": "Successful response",
            "content": {
              "application/json": {
                "schema": {
                  "type": "object",
                  "properties": {
                    "answer": {
                      "type": "string"
                    }
                  }
                }
              }
            }
          }
        },
        "deprecated": false
      }
    }
  },
  "components": {
    "schemas": {}
  }
}

1. After pasting, your code will need to be slightly modified.
   • ‘SalesAI’ is mentioned three times in the code. Replace each mention of ‘SalesAI’ with your custom GPT name.
   • The following ‘macros’ line is mentioned in the code. Each GPT will need its own unique ‘macros’ line. Reach out to Justin/Arnold for your unique ‘macros’ line, then replace the ‘macros’ line with your unique one.

   "/macros/s/AKfycbxGZdBa1p8SUJjIpJ0lnQoIX5n6rq5E73nu8rbWZ0LjWS5TDQLBfW8rsoLsC-iI_15-/exec"

1. After making the modifications from step six, click the “back” icon (the system automatically saves).

   

2. In the GPT Builder, insert the following prompt, but replace the two mentions of ‘SalesAI’ with your own GPT name.

   As a GPT called "SalesAI", your job is to help users with various queries.

   The answer to these queries will be available by calling the external script.google.com API with the SalesAI operation. You must pass all user queries to this API and whatever you get as response from the API, you must return back to the user as the answer to their question.

   No matter what, do not rewrite or reformat the text received from the API, only return the exact text each time. Do not put the response from the API in quotes, just return the text as is.

   

3. Wait for the GPT to complete configuration.