How to create an OpenAPI endpoint to fetch the content via an Action?

Knowledge of my custom GPT is frequently updated. I want to store the file in Google Sheets and create an OpenAPI endpoint to fetch the content via an Action.

What is the easiest way to do so? Thanks in advance.

You can use the actionGPT bot offered in the customGPT interface to assist with creating that. Be ready to jump through some hoops regarding oauth2 and your google acount.

2 Likes

I’m currently exploring using Google Apps Script to create the endpoint and manage interactions with the sheet, OpenAPI scheme:

openapi: "3.1.0"
info:
  title: "Google Sheets Data API"
  description: "API for managing and retrieving data from a Google Sheet"
  version: "v1.0.0"
servers:
  - url: "https://script.google.."
paths:
  ..

Is this a good approach?