# Google Sheet not appear at Glider Builder

**URL:** <https://community.glideapps.com/t/google-sheet-not-appear-at-glider-builder/35327>\
**Category:** Ask for Help\
**Created:** [December 1, 2021, 1:38am UTC](https://community.glideapps.com/t/google-sheet-not-appear-at-glider-builder/35327 "2021-12-01T01:38:39Z")\
**Posts on this page:** 12\
**Page:** 1

<div class="post-metadata">

**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\
**Post date:** [December 1, 2021, 1:38am UTC](https://community.glideapps.com/t/google-sheet-not-appear-at-glider-builder/35327/1 "2021-12-01T01:38:39Z")

</div>

Hello,

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/9/29c994a3326973e0d3cb41d9e6cbb400530368e5.png)

This is the google sheet that link with my apps.  
So, you can see row 365, Client : DMG Energy.

But no in Glideapps builder

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/5/95496553fbde3186aa43fe6fcc3e7c4a717269dc.png)

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [December 1, 2021, 2:03am UTC](https://community.glideapps.com/t/google-sheet-not-appear-at-glider-builder/35327/2 "2021-12-01T02:03:53Z")

</div>

Row 365 is not visible in your 2nd screen shot.

---

<div class="post-metadata">

**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\
**Post date:** [December 1, 2021, 2:06am UTC](https://community.glideapps.com/t/google-sheet-not-appear-at-glider-builder/35327/3 "2021-12-01T02:06:26Z")

</div>

yes, 361 is the last row

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [December 1, 2021, 2:09am UTC](https://community.glideapps.com/t/google-sheet-not-appear-at-glider-builder/35327/4 "2021-12-01T02:09:52Z")

</div>

Ah, I see.

- I assume that it stays like this even after you force a re-sync?
- What happens if you exit the builder and then open the app again?
- Does the “missing” data show up in the published app?

I’ve seen this happen before when the sheet and the GDE appear to get out of sync. But reloading the app in the builder usually fixes it.

---

<div class="post-metadata">

**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\
**Post date:** [December 1, 2021, 2:12am UTC](https://community.glideapps.com/t/google-sheet-not-appear-at-glider-builder/35327/5 "2021-12-01T02:12:31Z")

</div>

How to reloading ?  
Close the apps and open it back ?  
It is ?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [December 1, 2021, 2:13am UTC](https://community.glideapps.com/t/google-sheet-not-appear-at-glider-builder/35327/6 "2021-12-01T02:13:01Z")

</div>

yes, that’s what I meant.  
Try that.

---

<div class="post-metadata">

**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\
**Post date:** [December 1, 2021, 2:16am UTC](https://community.glideapps.com/t/google-sheet-not-appear-at-glider-builder/35327/7 "2021-12-01T02:16:24Z")

</div>

Yes, it is work for DMG Energy client but currently in google sheet have 369 rows but the glide builder shows 367 rows.  
But i don’t know which 2 rows missing.  
Why and what happen ? what will cause it ?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [December 1, 2021, 2:18am UTC](https://community.glideapps.com/t/google-sheet-not-appear-at-glider-builder/35327/8 "2021-12-01T02:18:43Z")

</div>

Have you checked the Google Sheet for empty rows?  
You might have 2 empty rows somewhere…

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [December 1, 2021, 2:55am UTC](https://community.glideapps.com/t/google-sheet-not-appear-at-glider-builder/35327/9 "2021-12-01T02:55:14Z")

</div>

One of those rows in the Google sheet is the header, so that won’t be counted in glide and should offset everything by one. I would also guess you maybe have an empty row in your google sheet which glide would ignore.

---

<div class="post-metadata">

**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\
**Post date:** [December 1, 2021, 3:05am UTC](https://community.glideapps.com/t/google-sheet-not-appear-at-glider-builder/35327/10 "2021-12-01T03:05:50Z")

</div>

One of the reasons for empty rows is are we deleting rows in the builder in the near future, and there is an addition of rows in the Google sheet before synchronization occurs?

---

<div class="post-metadata">

**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\
**Post date:** [December 1, 2021, 3:22am UTC](https://community.glideapps.com/t/google-sheet-not-appear-at-glider-builder/35327/11 "2021-12-01T03:22:25Z")

</div>

> [@Himaladin](#):
>
> there is an addition of rows in the Google sheet before synchronization occurs?

I’m not sure with this since the apps is live but logically, when user adding row, it will add to the glide builder first and then just google sheet right ?

---

<div class="post-metadata">

**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\
**Post date:** [December 1, 2021, 3:41am UTC](https://community.glideapps.com/t/google-sheet-not-appear-at-glider-builder/35327/12 "2021-12-01T03:41:25Z")

</div>

> [@biha](#):
>
> I’m not sure with this since the apps is live but logically, when user adding row, it will add to the glide builder first and then just google sheet right ?

I mean the occurrence due to manual deletion.  
I’ve experienced this myself. But the way I use is to remove some rows from the data row that doesn’t appear and a few rows below it to eliminate the possibility of those blank rows (sometimes hard to see), then sync again. And re-paste the previously deleted row data, and the problem is solved.
