Hi,
I’m completely new at coding, and trying to create a game for my kids as a family project, but getting stuck on a critical element!
I have correctly created a google spreadsheet and google api, so know the api connection works, but can’t successfully do the next step, which is to return a random cell from the spreadsheet. I know it’s returning in json format, but can’t figure out what I’m missing to get it to work!
I’ve attached a screenshot, and any help would be gratefully received!
Hello @ben.neatcrown3yl5m9 , welcome to Thunkable! 
It is hard to tell you the blocks you will need without seeing the response you receive from the API.
In general, if you want to get a random item from a list you can use the following block:
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!
Thanks! I know it’s coming back as a json string, so do I need to use “get object from json” to convert it into something that you can use?
Yes, see my JSON API tutorial video here: API JSON Tutorial (Video)
