# Giving a gemini API prompt data from a google sheets?

**URL:** <https://community.thunkable.com/t/giving-a-gemini-api-prompt-data-from-a-google-sheets/3823236>\
**Category:** Web API's\
**Tags:** help\
**Created:** [May 12, 2025, 9:02pm UTC](https://community.thunkable.com/t/giving-a-gemini-api-prompt-data-from-a-google-sheets/3823236 "2025-05-12T21:02:38Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![tefgames03435xtj](https://avatars.discourse-cdn.com/v4/letter/t/dfb087/32.png) [@tefgames03435xtj](https://community.thunkable.com/u/tefgames03435xtj)\
**Post date:** [May 12, 2025, 9:02pm UTC](https://community.thunkable.com/t/giving-a-gemini-api-prompt-data-from-a-google-sheets/3823236/1 "2025-05-12T21:02:38Z")

</div>

I’m trying to create an app that gets the user a response based on quiz responses they give. I think the best way to do it is to use a join in the prompt given to the gemini API to put together the responses with the generic prompt. This is what I got so far on the gemini api screen:

 ![captura bloques thunkable 1](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/d/5d37db478400cecc1e66a5dda2ff1c86b73015e8.png)  
and for the quiz screen I have the following:  
 ![captura bloques thunkable 1](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/d/5d37db478400cecc1e66a5dda2ff1c86b73015e8.png)  
Sorry if it’s not very clear, I’m new to thunkable. Anyways, thank you so much!!

---

<div class="post-metadata">

**Author:** ![ioannis](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ioannis/32/146956_2.png) [@ioannis](https://community.thunkable.com/u/ioannis)\
**Post date:** [May 16, 2025, 9:51pm UTC](https://community.thunkable.com/t/giving-a-gemini-api-prompt-data-from-a-google-sheets/3823236/2 "2025-05-16T21:51:28Z")

</div>

Hi @tefgames03435xtj welcome to Thunkable! 🎉

A list is not a valid “row id”. You can find more information about data source blocks in our docs: [Data Sources Blocks | Thunkable Docs](https://docs.thunkable.com/blocks/app-features/data-sources-blocks)

Be sure to check out [How to ask Great Questions v2.0](https://community.thunkable.com/t/how-to-ask-great-questions-v2-0/2689983/1), the [Community Guidelines](https://community.thunkable.com/t/community-guidelines/78/8), and our [Getting Started Guide](https://docs.thunkable.com/getting-started/get-started) to make the best of your Thunkable Community experience!