Hey all, I am a non-coder so I know I’m out of my depth here, but ChatGPT had convinced me that this would be easy to accomplish and I have now wasted countless hours trying to do it with no success, so at this point I just want to get it working so those hours aren’t a complete waste!
I created a CustomGPT that I would like to have access to an inventory I keep in GoogleSheets. ChatGPT walked me through the steps to create the Web App API from the GoogleSheets, then it created the schema for my custom GPT action, but consistently without fail when I( hit the “test” button in the CustomGPT preview window, it returns an error. Most of the time it says the response is too large, although it has been verified that this is incorrect (the entire JSON for the inventory is only 17,000 characters). Occasionally it’ll give a different error.
I have confirmed the API’s output is pure JSON. I have confirmed the API is accessible by anyone, with no restrictions. I have confirmed the schema is correct with no “required” fields or errors. I have confirmed the properties are all listed exactly accurately.
What am i missing here!?!? Why can’t I get this to work?