I am pulling data from a Google Sheet using the user's email which allows a personal conversation. Works great. But... if the user gives a wrong email address, the workflow continues which causes a lot of issues. I need to have the workflow stop if the email provided does not match the email in the Google Sheet and redirect user to input correct email. Attached is my current attempt using Conditional Logic. I am not sure if this is the right approach... or if there is another (right way) way to do this? Thanks!

Hello! My Variables are coming from Google sheet correctly - they show up in the chat when they are hard coded in the opening text bubble. But OpenAI Assistant block does not see them when interacting with user. Claude suggested setting up a new Variable earlier in the workflow. userProfile. But it did not work - see below.

Has anyone gotten the OpenAI Assistant block to see variables from a Google Sheet? If so, how did you make this happen? Thanks much! (I am no-coder but eager to learn whatever must be learned to succeed 😉

-- From Claude:

Set A New Variable earlier in the workflow:
userProfile
The user's name is {{getGoogleSheetData.firstName}}. They are {{getGoogleSheetData.age}} years old. Their profession is {{getGoogleSheetData.profession}}.

Message:
System: {{userProfile}}

Function:
return {
firstName: params.firstName,
age: params.age,
profession: params.profession,
conversation: params.conversation
}

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!