Hello Community,
I need help with data retrieval from Google Sheets to VoiceFlow workflow using Make.
I have setup VF to make a GET API call to Make Webhooks.
In Make, a Google Sheets Search Rows function is set up to find and retrieve the Running Total data. Then a Webhook Response function is set up for VF to pick up and inform the user.
The workflow runs without any error, and wanted data properly retrieved by Make and is displayed as a result in Webhooks Response.
But the VF is showing 0 as the retrieved data instead of real values.
It looks like there’s something I’m missing in transferring the data from Make’s webhooks response to VF GET API call.
- Is this a proper setup for GET and Response to VF?
- I have posted this issue on VF side too, but if anyone knows VF and Make interactions, please help.
Thank you in advance.
Kevin
Welcome to the Make community!
What does the API documentation say; Can you provide a link to it?
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.
Hello @samliew
Here’s the link to the webhook setup on Make: https://help.make.com/webhooks.
I am using a Custom webhook to receive the Get Request from VoiceFlow.
The custom webhook then triggers Google Sheets Search Rows to find the appropriate data and passes on the webhook response module.
I think it’s the proper process, and seeing the correct data in the webhook response tells me, it’s working per design in Make.
However, in VoiceFlow, there’s no data received in the body of GET API call step. Hence my output shows 0 values. FYI, the header of GET API call step has current data, showing the call is being made.
My hunch is that I’m missing something either in Make or in VoiceFlow to transfer the data.
What do you think?
Kevin
What does the API documentation say; Can you provide a link to it?
I meant Voiceflow instructions on how to use the Voiceflow module to call a webhook and get the response.
Looks like your JSON is invalid. You’ll need a comma after each item except the last.
You can verify this by pasting the Input Bundle’s “Body” into https://jsonformatter.org
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.
2 Likes
Fantastic @samliew !!! It’s working now.
Thanks a lot for digging for the missing commas! I should’ve checked those first.
1 Like
Check the documentation, and did you assign value to the retrieval?
@Creativeimpact, this was resolved with help from @samliew
1 Like
