Eendless-jade
Need to use fetched data from a function block to respond with AI
So, I'm a complete noob in Voiceflow with zero coding knowledge and experience.
Here's what I'm trying to achieve: I want a chatbot that can pull data from a Google Sheets file and answer my queries. For example, if it's a spreadsheet about the status of my different projects with columns, like client name, tasks, payment status, due date, etc., I might ask "what projects are pending?" and it fetches the data from the spreadsheets, understands the data and then provides an appropriate response.
Here's the progress I've made so far: Using the "Pull from Google Sheets" function from Voiceflow's website, I am able to fetch the sheets data into a JSON text. The function has two paths - Succeeded and Failed. I have connected an AI response block with the "Succeded" path, prompting it use the fetched data to answer user query based on "last_utterance" variable. AND IT ACTUALLY WORKED.
However, when I woke up next morning, it wasn't working anymore. There doesn't seem to be a problem with the functions block as I have tested it and it's returning valid response. The problem seems to be with AI response block as it's not able utilize any of the fetched data. Seems like it isn't aware of the data. However, it worked fine before. Am I missing any steps? Any help would be really appreciated.
Here's what I'm trying to achieve: I want a chatbot that can pull data from a Google Sheets file and answer my queries. For example, if it's a spreadsheet about the status of my different projects with columns, like client name, tasks, payment status, due date, etc., I might ask "what projects are pending?" and it fetches the data from the spreadsheets, understands the data and then provides an appropriate response.
Here's the progress I've made so far: Using the "Pull from Google Sheets" function from Voiceflow's website, I am able to fetch the sheets data into a JSON text. The function has two paths - Succeeded and Failed. I have connected an AI response block with the "Succeded" path, prompting it use the fetched data to answer user query based on "last_utterance" variable. AND IT ACTUALLY WORKED.
However, when I woke up next morning, it wasn't working anymore. There doesn't seem to be a problem with the functions block as I have tested it and it's returning valid response. The problem seems to be with AI response block as it's not able utilize any of the fetched data. Seems like it isn't aware of the data. However, it worked fine before. Am I missing any steps? Any help would be really appreciated.
