# How to minimize the code for retrieving the data from Google Sheet?

**URL:** https://community.thunkable.com/t/how-to-minimize-the-code-for-retrieving-the-data-from-google-sheet/1208048
**Category:** Questions about Thunkable X
**Tags:** beginner
**Created:** [April 6, 2021, 5:26am UTC](https://community.thunkable.com/t/how-to-minimize-the-code-for-retrieving-the-data-from-google-sheet/1208048 "2021-04-06T05:26:24Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![rechilleanndp0wyv](https://avatars.discourse-cdn.com/v4/letter/r/858c86/32.png) [@rechilleanndp0wyv](https://community.thunkable.com/u/rechilleanndp0wyv)
#### Post date: [April 6, 2021, 5:26am UTC](https://community.thunkable.com/t/how-to-minimize-the-code-for-retrieving-the-data-from-google-sheet/1208048/1 "2021-04-06T05:26:24Z")

</div>

![code](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/2/c2104a6eb452be2d4fa673a4874a7c8f00120fb5.png)  
Good day Thunkers! How to solve this kind of code to minimize the way retrieving the data from Google Sheets to faster response? I try the [get all row] code in spreadsheets but the response is [object Object] .

Is there is another way to correct the code? Thank you so much in advance!

---

<div class="post-metadata">

### Author: ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [April 6, 2021, 3:07pm UTC](https://community.thunkable.com/t/how-to-minimize-the-code-for-retrieving-the-data-from-google-sheet/1208048/2 "2021-04-06T15:07:13Z")

</div>

Use GetAllRows and then read the data as a list of objects that has column names and values.

---

<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: [November 8, 2024, 1:25pm UTC](https://community.thunkable.com/t/how-to-minimize-the-code-for-retrieving-the-data-from-google-sheet/1208048/3 "2024-11-08T13:25:29Z")

</div>


