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 rand…

Hello @ben.neatcrown3yl5m9 , welcome to Thunkable! :tada: 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] [image] Be sure to check out How to…

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?

Struggling to pull from API google sheets correctly

Questions about Thunkable X Web API's

tatiang October 19, 2024, 2:46pm 4

Yes, see my JSON API tutorial video here: API JSON Tutorial (Video)

Topic		Replies	Views
Thunkable WebAPi and Google Sheets APi to Fetch Data. How? Questions about Thunkable X beginner	1	685	August 30, 2021
[Solved] How do I use Google Sheets on a device? Questions about Thunkable X solved , spreadsheets	24	1055	May 11, 2021
Text Input Based Data Extraction From Google Sheets Web API's	1	181	November 25, 2023
Spreadsheet To get cell data : problem with blocks that crash the app Questions about Thunkable X	2	1053	September 10, 2018
Vocabulary app - Newbie! Issues / Bugs	0	30	July 14, 2025

Struggling to pull from API google sheets correctly

Related topics