Fetching information from google sheet using Make

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! :folded_hands:

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