# Struggling to pull from API google sheets correctly

**URL:** <https://community.thunkable.com/t/struggling-to-pull-from-api-google-sheets-correctly/3281644>\
**Category:** Web API's\
**Tags:** beginner\
**Created:** [October 18, 2024, 3:25pm UTC](https://community.thunkable.com/t/struggling-to-pull-from-api-google-sheets-correctly/3281644 "2024-10-18T15:25:29Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ben.neatcrown3yl5m9](https://avatars.discourse-cdn.com/v4/letter/b/9fc29f/32.png) [@ben.neatcrown3yl5m9](https://community.thunkable.com/u/ben.neatcrown3yl5m9)\
**Post date:** [October 18, 2024, 3:25pm UTC](https://community.thunkable.com/t/struggling-to-pull-from-api-google-sheets-correctly/3281644/1 "2024-10-18T15:25:29Z")

</div>

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!

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/6/f6b01cf6f4952e3c47dcb81fcac362a71e91dac1.png)

---

<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:** [October 18, 2024, 5:52pm UTC](https://community.thunkable.com/t/struggling-to-pull-from-api-google-sheets-correctly/3281644/2 "2024-10-18T17:52:32Z")

</div>

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:

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/8/082c830c1900ffddd47ef38dc085dcf92be7c90e.png)  
 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/a/8/a808d7834d7b52c2a36960fc9e770a7737b4ac26.png)

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!

---

<div class="post-metadata">

**Author:** ![ben.neatcrown3yl5m9](https://avatars.discourse-cdn.com/v4/letter/b/9fc29f/32.png) [@ben.neatcrown3yl5m9](https://community.thunkable.com/u/ben.neatcrown3yl5m9)\
**Post date:** [October 19, 2024, 2:41pm UTC](https://community.thunkable.com/t/struggling-to-pull-from-api-google-sheets-correctly/3281644/3 "2024-10-19T14:41:40Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\
**Post date:** [October 19, 2024, 2:46pm UTC](https://community.thunkable.com/t/struggling-to-pull-from-api-google-sheets-correctly/3281644/4 "2024-10-19T14:46:32Z")

</div>

Yes, see my JSON API tutorial video here: [API JSON Tutorial (Video)](https://community.thunkable.com/t/api-json-tutorial-video/1140575)