Giving a gemini API prompt data from a google sheets?

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:


and for the quiz screen I have the following:

Sorry if it’s not very clear, I’m new to thunkable. Anyways, thank you so much!!

Hi @tefgames03435xtj welcome to Thunkable! :tada:

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

Be sure to check out How to ask Great Questions v2.0, the Community Guidelines, and our Getting Started Guide to make the best of your Thunkable Community experience!