# Data pulled from Google sheets (1200 records) take a very long time to show **URL:** \ **Category:** Questions about Thunkable X\ **Created:** [March 27, 2022, 5:06pm UTC](https://community.thunkable.com/t/data-pulled-from-google-sheets-1200-records-take-a-very-long-time-to-show/1804725 "2022-03-27T17:06:36Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![yosik](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/yosik/32/1489_2.png) [@yosik](https://community.thunkable.com/u/yosik)\ **Post date:** [March 27, 2022, 5:06pm UTC](https://community.thunkable.com/t/data-pulled-from-google-sheets-1200-records-take-a-very-long-time-to-show/1804725/1 "2022-03-27T17:06:36Z")
Hi, I have a Google sheets which serves as a Data source (it is for a community phone book). I have a Data Viewer object which shows the whole list (although it takes a little time for the records to appear when I scroll down the list). When clicking an entry, I want to show details of this person (Data from the Google sheets). It takes a very long time for the Data to show. This is both in preview and also after building the apk. I’d appreciate guidance or help. TY Yossi ---
**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:** [March 27, 2022, 6:06pm UTC](https://community.thunkable.com/t/data-pulled-from-google-sheets-1200-records-take-a-very-long-time-to-show/1804725/2 "2022-03-27T18:06:46Z")
Can you show your blocks so someone can see what makes it too long to get you the vales? ---
**Author:** ![yosik](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/yosik/32/1489_2.png) [@yosik](https://community.thunkable.com/u/yosik)\ **Post date:** [March 27, 2022, 6:25pm UTC](https://community.thunkable.com/t/data-pulled-from-google-sheets-1200-records-take-a-very-long-time-to-show/1804725/3 "2022-03-27T18:25:26Z")
![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/6/9692193b11b91b81a78ab323ed1a0ae8662accc8.png) I have a bunch of Labels which show the relevant info of the selected record (row). Thank you ---
**Author:** ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)\ **Post date:** [March 27, 2022, 6:36pm UTC](https://community.thunkable.com/t/data-pulled-from-google-sheets-1200-records-take-a-very-long-time-to-show/1804725/4 "2022-03-27T18:36:12Z")
The delay is probably due to making several different back to back api calls. Each time you call google sheets you send a message to the google API’s, and then wait on a response. Our blocks don’t execute without having received a response. So, you call, wait, apply label, the. Do it again. And again. And again. And again. I would recommend storing objects of data if you can predictably use the data in this manner. Then you could make 1 call and consume a Json object vs making several individual calls for 1 piece of info. Firebase is a great tool for this exact use case. Perhaps consider restructuring your data such that you do not need to make so many different data calls. ---
**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:** [March 27, 2022, 6:51pm UTC](https://community.thunkable.com/t/data-pulled-from-google-sheets-1200-records-take-a-very-long-time-to-show/1804725/5 "2022-03-27T18:51:49Z")
This will, undoubtedly, introduce huge delay. If I were you, I would create a variable to retrieve the row information all at once. then I use in the row object to populate the labels. ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/8/08e886a6eec5888aad83b5c8faede0622fd58dc2.png) **Example code** ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/4/84bdd875cd83e205ac8881290fdad1009acde337.png) ---
**Author:** ![yosik](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/yosik/32/1489_2.png) [@yosik](https://community.thunkable.com/u/yosik)\ **Post date:** [March 28, 2022, 8:42pm UTC](https://community.thunkable.com/t/data-pulled-from-google-sheets-1200-records-take-a-very-long-time-to-show/1804725/6 "2022-03-28T20:42:01Z")
OK. Thank you. I will try your suggestion. ---
**Author:** ![system](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0f59f292712368bce16ff80133ae10de8a6f27e8.png) [@system](https://community.thunkable.com/u/system)\ **Post date:** [June 26, 2022, 8:42pm UTC](https://community.thunkable.com/t/data-pulled-from-google-sheets-1200-records-take-a-very-long-time-to-show/1804725/7 "2022-06-26T20:42:49Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.