# Fetching information from google sheet using Make

**URL:** <https://community.make.com/t/fetching-information-from-google-sheet-using-make/76785>\
**Category:** Questions\
**Tags:** api, webhooks\
**Created:** [March 28, 2025, 7:16am UTC](https://community.make.com/t/fetching-information-from-google-sheet-using-make/76785 "2025-03-28T07:16:46Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dylan\_Wright](https://avatars.discourse-cdn.com/v4/letter/d/dec6dc/32.png) [@Dylan\_Wright](https://community.make.com/u/Dylan_Wright)\
**Post date:** [March 28, 2025, 7:16am UTC](https://community.make.com/t/fetching-information-from-google-sheet-using-make/76785/1 "2025-03-28T07:16:46Z")

</div>

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! 🙏

---

<div class="post-metadata">

**Author:** ![Melika\_Ghasemifard](https://avatars.discourse-cdn.com/v4/letter/m/7feea3/32.png) [@Melika\_Ghasemifard](https://community.make.com/u/Melika_Ghasemifard)\
**Post date:** [March 28, 2025, 1:25pm UTC](https://community.make.com/t/fetching-information-from-google-sheet-using-make/76785/2 "2025-03-28T13:25:47Z")

</div>

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:

> **[Voiceflow Integration with Make](https://www.voiceflow.com/apps/voiceflow-integration-with-make)**
>
> Use this Make App to connect to Voiceflow and build automated no code workflows

Use these details to craft personalized responses within your Voiceflow project.  
i suggest see this website they have some good tutorial [effeect](https://effeect.com/blog/)

---

<div class="post-metadata">

**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\
**Post date:** [June 26, 2025, 12:27pm UTC](https://community.make.com/t/fetching-information-from-google-sheet-using-make/76785/3 "2025-06-26T12:27:28Z")

</div>

This topic was automatically closed because it's resolved or inactive. Please, start a new topic.


