How to build an AI Assistant for your Data | Google Sheets and AI | Voiceflow Functions

[@e-Course.]

Nice video , to read excel sheet data in voiceflow

[@AKSHATBAHETY]

Thanks a lot

[@rishabhsahu2674]

can we also post the data the same way

[@AKSHATBAHETY]

We can build a post api for which I prefer airtable

[@ashleyevans6224]

Great video, although i have a problem. The Google Sheets API is not saving the output to the variable i have set. Under "Output Variable Mapping", the {content} -----> {captureResponse}. When i debug it, i can see the API call is working, the response its getting just isnt being saved to any variables. Any idea how to fix this?

[@AKSHATBAHETY]

Hi Ashley, I would suggest that your output vars should look something like this after the "return { " syntax should look like below outputVars: { content: JSON.stringify(responseBody) }, and the same name should be your output variable which in this case would be content if you still need more help let me know more than happy to jump on a quick call.

[@selmonvoi6832]

instead of funcation,can you directly call excel api and extract data from it ?

[@AKSHATBAHETY]

You should be able to, I have used Airtable API a lot of times and it works great (never tried google sheets api directly as such without the function) - Let me know if you face issues

[@ricardoantonio8223]

Something is wrong; it's not retrieving the information from Google Sheets. It says 'undefined,' and in the response block, it says it doesn't have access to the information.

[@AKSHATBAHETY]

Ricardo, is your google sheet public? And if you still are facing issues - please feel free to book a call with me cal.com/akshatbahety/ai18min