Integrating Google Sheets AND OpenAi Assistant (AND...)
Integrating Google Sheets AND OpenAi Assistant (AND...)
At a glance
The community member is trying to build a Typebot for an online course, where students will do a self-assessment that will be stored in a Google Sheet. They want to use OpenAI Assistant as the primary knowledge base for course information and the Google Sheet as a secondary knowledge base for personalized student data. The community member has successfully pulled data from each knowledge base separately, but is having trouble getting the Typebot to use both knowledge bases in one chat. An answer from another community member suggests that the community member may have inserted the wrong variable in the Message field, using {{Assistant message}} instead of {{User message}}.
Hello! I am trying to build a Typebot for my new online course. Students will do a self assessment when they start the program. That data will be stored in a Google Sheet. I want to use OpenAI Assistant for my primary knowledge base (course info) and use the Google Sheet as my secondary knowledge base (Personalized rows for each student).
I have successfully pulled data from each knowledge base separately during my initial tests. But I cannot figure out how to to get the Typebot to use both of the knowledge bases in one chat.
Currently in my workflow, the Google Sheet data seems to come through ok, but then I get lost with the connecting of everything else...
I am still fairly new, but I have watched every video on Youtube (Thank you Baptiste!) about Typebot and read the docs twice but do not seem to see this addressed. The more I try the more confused I make myself 😉 so it is possible I am doing something very simple to keep it from working.
Can someone please take a look at my workspace (attached and photoshopped to show both GPT blocks open) and point me in the right direction? Much appreciated!
