How to get OpenAI block to see Variables from Google Sheet?
How to get OpenAI block to see Variables from Google Sheet?
At a glance
The community member was having trouble getting the OpenAI Assistant block to recognize variables from a Google Sheet in their Typebot workflow. They tried setting up a new variable called userProfile earlier in the workflow, but it did not work. Another community member suggested showing the OpenAI block configuration, and the original poster provided a screenshot. The community members discovered that the Google variables were appearing correctly in the first text bubble, but the OpenAI Assistant could not see them. Eventually, the original poster found a solution by removing the Function completely and being more explicit with the System Prompt in the Message by listing the variables and starting the instructions with the word "System". This solution worked for them.
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}}.
Never mind - I removed the Function completely - it was not needed. I was more explicit with the System Prompt in Message by listing the variables and starting the instructions with the word System. And It works...
Never mind - I removed the Function completely - it was not needed. I was more explicit with the System Prompt in Message by listing the variables and starting the instructions with the word System. And It works...