# \[Solved\] Does Airtable and Google sheets only load 100 rows during a sync? **URL:** \ **Category:** Questions about Thunkable X\ **Created:** [January 31, 2022, 4:41pm UTC](https://community.thunkable.com/t/solved-does-airtable-and-google-sheets-only-load-100-rows-during-a-sync/1707397 "2022-01-31T16:41:53Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![similar2similar](https://avatars.discourse-cdn.com/v4/letter/s/a4c791/32.png) [@similar2similar](https://community.thunkable.com/u/similar2similar)\ **Post date:** [January 31, 2022, 4:41pm UTC](https://community.thunkable.com/t/solved-does-airtable-and-google-sheets-only-load-100-rows-during-a-sync/1707397/1 "2022-01-31T16:41:53Z")
Hi: ![MALSOLO100](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/b/7/b78a35d1253e684b4f6a639d9ac88c506d7fc677.png) It’s happening again: databases in Airtable or Google sheets only load 100 rows… Is it just my case? ---
**Author:** ![similar2similar](https://avatars.discourse-cdn.com/v4/letter/s/a4c791/32.png) [@similar2similar](https://community.thunkable.com/u/similar2similar)\ **Post date:** [January 31, 2022, 4:45pm UTC](https://community.thunkable.com/t/solved-does-airtable-and-google-sheets-only-load-100-rows-during-a-sync/1707397/2 "2022-01-31T16:45:24Z")
![MALSOLO100b](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/4/644480ff350d46d72354759d0f0479a725c2e046.png) ---
**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:** [January 31, 2022, 5:00pm UTC](https://community.thunkable.com/t/solved-does-airtable-and-google-sheets-only-load-100-rows-during-a-sync/1707397/3 "2022-01-31T17:00:20Z")
Hey @similar2similar I am looking into this and wondering if it’s an upper limit that can be changed. I’ll come back to this in a bit. Does this happen all the time? Did it ever work for you? ---
**Author:** ![similar2similar](https://avatars.discourse-cdn.com/v4/letter/s/a4c791/32.png) [@similar2similar](https://community.thunkable.com/u/similar2similar)\ **Post date:** [January 31, 2022, 5:22pm UTC](https://community.thunkable.com/t/solved-does-airtable-and-google-sheets-only-load-100-rows-during-a-sync/1707397/4 "2022-01-31T17:22:11Z")
I used to have my databases in thunkable, but now that I’m (hopefully) finishing the app, I wanted to put those databases in safer places than the app itself, and to lighten it up a bit too. Yesterday I did it and from Thunkable I saw them with all their content, but today, I find this behavior that makes me fear for my app… Some of my databases have several thousand rows, so… Please, I need a real long-term solution. Thank you. ---
**Author:** ![similar2similar](https://avatars.discourse-cdn.com/v4/letter/s/a4c791/32.png) [@similar2similar](https://community.thunkable.com/u/similar2similar)\ **Post date:** [January 31, 2022, 5:39pm UTC](https://community.thunkable.com/t/solved-does-airtable-and-google-sheets-only-load-100-rows-during-a-sync/1707397/5 "2022-01-31T17:39:58Z")
I don’t know if it makes sense to you, but as I’m testing one of the parts of the app, I see that it doesn’t always put the text on the screen, only sometimes, although it does reproduce the sound of the 3 Text to Speech that I use …and when I repeat it, I realize, because it gives me no sound, that it has deleted from the correspondent rows in the first column of the Airtable database (from where I am using my DB in this case) each of the words that I have been using… ---
**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:** [January 31, 2022, 5:51pm UTC](https://community.thunkable.com/t/solved-does-airtable-and-google-sheets-only-load-100-rows-during-a-sync/1707397/6 "2022-01-31T17:51:46Z")
To be clear here, are you trying to sync from Google to app or Airtable to app? if it is google/airtable to app, I understand you only see 100 rows in the table view in the design screen. When you test the app, are you able to access more than 100 rows of data? You should be able to access the data though it doesn’t appear in the design screen. ---
**Author:** ![similar2similar](https://avatars.discourse-cdn.com/v4/letter/s/a4c791/32.png) [@similar2similar](https://community.thunkable.com/u/similar2similar)\ **Post date:** [January 31, 2022, 6:11pm UTC](https://community.thunkable.com/t/solved-does-airtable-and-google-sheets-only-load-100-rows-during-a-sync/1707397/7 "2022-01-31T18:11:27Z")
Yes,I can only see 100, but I get more rows… Thanks! ---
**Author:** ![similar2similar](https://avatars.discourse-cdn.com/v4/letter/s/a4c791/32.png) [@similar2similar](https://community.thunkable.com/u/similar2similar)\ **Post date:** [January 31, 2022, 6:17pm UTC](https://community.thunkable.com/t/solved-does-airtable-and-google-sheets-only-load-100-rows-during-a-sync/1707397/8 "2022-01-31T18:17:12Z")
But it goes on deleting the rows in airtable … ---
**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:** [January 31, 2022, 6:40pm UTC](https://community.thunkable.com/t/solved-does-airtable-and-google-sheets-only-load-100-rows-during-a-sync/1707397/9 "2022-01-31T18:40:01Z")
Are you indicating that when you sync the data, it deletes data from your airtable? ---
**Author:** ![similar2similar](https://avatars.discourse-cdn.com/v4/letter/s/a4c791/32.png) [@similar2similar](https://community.thunkable.com/u/similar2similar)\ **Post date:** [January 31, 2022, 11:31pm UTC](https://community.thunkable.com/t/solved-does-airtable-and-google-sheets-only-load-100-rows-during-a-sync/1707397/10 "2022-01-31T23:31:19Z")
Yes, exactly that. I have done it three times, and now I have thre words left. ![MALSOLO100C](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/d/b/db4a4defeb2ce973e8ad396493e2d0df42dfb497.png) ---
**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:** [January 31, 2022, 11:52pm UTC](https://community.thunkable.com/t/solved-does-airtable-and-google-sheets-only-load-100-rows-during-a-sync/1707397/11 "2022-01-31T23:52:29Z")
You’ll need to show your blocks. We can’t delete data with a “get data” call ---
**Author:** ![similar2similar](https://avatars.discourse-cdn.com/v4/letter/s/a4c791/32.png) [@similar2similar](https://community.thunkable.com/u/similar2similar)\ **Post date:** [February 1, 2022, 12:07am UTC](https://community.thunkable.com/t/solved-does-airtable-and-google-sheets-only-load-100-rows-during-a-sync/1707397/12 "2022-02-01T00:07:12Z")
Here you are. These are the blocks of the page that is having a problematic behaviour I don’t understand ![FALSE FRIENDS DVL BLOCKS](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/2/52e9034f32a655a7b3536a077d3963854ed6f877.png) or maybe you need any other way to access this… ---
**Author:** ![similar2similar](https://avatars.discourse-cdn.com/v4/letter/s/a4c791/32.png) [@similar2similar](https://community.thunkable.com/u/similar2similar)\ **Post date:** [February 1, 2022, 12:11am UTC](https://community.thunkable.com/t/solved-does-airtable-and-google-sheets-only-load-100-rows-during-a-sync/1707397/13 "2022-02-01T00:11:34Z")
Fortunately, this behavior is not happening to me on the other pages I have with Airtable. ---
**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:** [May 2, 2022, 12:12am UTC](https://community.thunkable.com/t/solved-does-airtable-and-google-sheets-only-load-100-rows-during-a-sync/1707397/14 "2022-05-02T00:12:21Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.