I’m working on a Voiceflow project where I want the bot to ask users if they’ve stayed at a hotel before. If they have, it should retrieve their full name, email, and preference (e.g., local wine) from a Google Sheet using Make. I’m stuck on how to properly retrieve this info and send it back to Voiceflow, so the bot can use the data to create a personalized response. Any tips on setting up the flow between Google Sheets and Voiceflow via Make would be greatly appreciated! Thanks in advance!
hi Dylan i think this step by step instruction can help you:Trigger a Webhook from Voiceflow:
In Voiceflow, when a user indicates they’ve stayed before, configure an API block to send a POST request to a Make webhook. Include the user’s identifier (e.g., email) in the payload.
Set Up the Make Scenario:
Webhook Module: Start with a custom webhook trigger to receive data from Voiceflow.
Google Sheets Module: Use the ‘Search Rows’ function to locate the user’s information based on the provided identifier.
Text Aggregator (if multiple entries): If there are multiple rows to retrieve, insert a Text Aggregator module before sending data back to Voiceflow.
Webhook Response: Format the retrieved data as JSON and send it back to Voiceflow.
Handle the Response in Voiceflow:
Parse the incoming JSON to extract user details.
you can review this doc for better underestanding:
Use these details to craft personalized responses within your Voiceflow project.
i suggest see this website they have some good tutorial effeect