Setup GPT Assistants to send data to Coda (without the need of Packs)

[Felipe_Griebel]

Hi Community,
For those who have not seen the latest news, OpenAI now allows us to make our own GPT Assistants directly at chat.openai.com

The idea is that we can setup an assistant capable of doing many things, like internet search and function calling.

Function Calling
We are able to add actions to our own GPT, like actions to get information from a website. Notice the print below, they have a weather report example where they provide a Schema so that GPT understands how to call the GetCurrentWeather function when needed.

Authentication
They also allow us to setup our authentications

Coda Webhook Automations
I noticed Coda automations follow the same structure as they can provide webhook URLs and API tokens to authenticate POST methods with JSON payloads to our Coda documents.

I’m not a developer but I tried to follow instructions and used robots to figure out how to setup a Schema (like in their weather example) that enables the GPT to call a POST function with some data. But it has proven to be a challenging tasks. Since I’m not a developer, I was wondering if this only works if I make a GPT Plugin, or else I could actually make a schema that works.

If there is someone in the community that successfully setup a GPT able to send data to a Coda document through webhooks, I’d appreaciate your help.

My goal is to make an assistant capable of discussing our projects with us and then, when we’re done talking, I ask it to send a list of items paired with content based on our discussions to a Coda document. All of that without leaving the context of chat.openai.com

Here are some useful links on the matter:

• Function Calling documentation
• Trigger WebHook in Coda
• Playground for Assistant testing
• OpenAPI Builder (a GPT that helps make schemas)

Thank you for your interest.

[Yuriy_Mykhasyak]

This will be huge. I am also looking if someone will create the pack that works with the new assistant functionality and or overcome the API timeout issues.

[Nick_McCartney1]

you don’t need to do anything in Coda like setup web hooks you can use the API.
https://coda.io/developers
specifically, https://coda.io/apis/v1/openapi.yaml
this is exactly what you need to put in the custom GPT. it’s just too long so you will need to only take out the needed parts.

after you set up that and the authentication as you have it, it works really well.

[Lynn_vK]

What are the needed parts? Can you provide an example? Thanks!

[Nick_McCartney1]

Ya here is one that gives access to the docs endpoint. I also created a GPT with access to Coda’s OpenAPI and examples for GPTs. You can try using it to create what you need. https://chat.openai.com/g/g-qFoeSAsGU-coda-open-api

{
  "openapi": "3.1.0",
  "info": {
    "title": "Get Coda Docs",
    "description": "Retrieves a list of Coda docs accessible by the user, ordered by the latest relevant event (last viewed, edited, or shared).",
    "version": "v1.0.0"
  },
  "servers": [
    {
      "url": "https://coda.io/apis/v1"
    }
  ],
  "paths": {
    "/docs": {
      "get": {
        "summary": "List available docs",
        "description": "Returns a list of Coda docs accessible by the user. These are returned in the same order as on the docs page: reverse chronological by the latest event relevant to the user (last viewed, edited, or shared).",
        "operationId": "listDocs",
        "tags": [
          "Docs"
        ],
        "parameters": [
          {
            "name": "isOwner",
            "in": "query",
            "description": "Show only docs owned by the user.",
            "required": false,
            "schema": {
              "type": "boolean"
            }
          },
          {
            "name": "limit",
            "in": "query",
            "description": "Limit the number of docs returned",
            "required": false,
            "schema": {
              "type": "integer"
            }
          },
          {
            "name": "query",
            "in": "query",
            "description": "Search term used to filter down results.",
            "required": false,
            "schema": {
              "type": "string"
            }
          }
        ],
        "responses": {
          "200": {
            "description": "List of accessible Coda docs",
            "content": {
              "application/json": {
                "schema": {}
              }
            }
          }
        },
        "deprecated": false
      }
    }
  },
  "components": {
    "schemas": {
      "Doc": {
        "type": "object",
        "properties": {
          "id": {
            "type": "string",
            "description": "Unique identifier for the document"
          },
          "name": {
            "type": "string",
            "description": "Name of the document"
          },
          "createdAt": {
            "type": "string",
            "format": "date-time",
            "description": "Timestamp when the document was created"
          },
          "updatedAt": {
            "type": "string",
            "format": "date-time",
            "description": "Timestamp when the document was last updated"
          },
          "isOwner": {
            "type": "boolean",
            "description": "Indicates if the user is the owner of the document"
          }
        }
      },
      "DocsListResponse": {
        "type": "object",
        "properties": {
          "documents": {
            "type": "array",
            "items": {
              "$ref": "#/components/schemas/Doc"
            },
            "description": "List of documents accessible to the user"
          }
        }
      }
    }
  }
}

[Lynn_vK]

Thank you so much Nick. Happy Thanksgiving!

[Robert_Collett]

Very helpful. Thank you. Two follow ups for you:

• Have you seen any Custom GPTs for writing Coda.io formulas?
• And have you found that Custom GPTs are unable to access your knowledge base files? I am using your GPT at the moment and keep getting an error that it is unable to read the files for technical reasons. I’ve heard others complain about that in their GPTs too.

[Yuriy_Mykhasyak]

I was able to copy webpage with coda formulas and upload it to custom GPT. It’s faster than web search but would be nice if Coda created their own GPT trained on all examples, formulas and documentation.