quickest-silver•14mo ago
Help wanted! Using GET function in voiceflow with make.com for spread sheets
Hi everyone, I have a bot that is tracking my 'monk mode' progress. I want to be able to tell the user whether or not they have achieved their goals on a certain day from a google spread sheet.
I am using make.com to communicate between voiceflow & google sheets. I attached screenshots of my current scenario set-up & google sheet. In make.com , it's showing the right output from the google sheet, however on voiceflow it is not receiving this output for some reason.
Anyone have any clue what I'm doing wrong here? Or if you can recommend an easier way to do this would be great also. Thanks in advance
9 Replies
you need to return valid JSON
@Kimbo To get data back to voiceflow from make.com, the module setup in your make scenario has to be a custom webhook first and the last a webhook response module returning a valid JSON as @W. Williams (SFT) pointed out.
In your scenario as you have a watchrows module as your first module this won't work. Honestly I would suggest using Airtable as you can use filterByFormula to return anything you want back to Voiceflow and you don't need to use make in between.
@Steve B. | IntelleSync.ai is 100% correct about Airtable being better. Plus, you would not need to use Make.
quickest-silverOP•14mo ago
Thanks @Steve B. | IntelleSync.ai @W. Williams (SFT)
Though I will 100% look to use airtable as this has become really messy for what feels like a simple task, I would still love to know why i cant figure this out even after adding a webhook response..
quickest-silverOP•14mo ago
New scenario^
quickest-silverOP•14mo ago
quickest-silverOP•14mo ago
Still not returning the data to voiceflow 😦
You need to send back JSON, not text.
quickest-silverOP•14mo ago
How do you mean? Sorry I'm still a beginner and not familiar with coding xD
@W. Williams (SFT)
NVM, figured it out! thank you