# Data Shows in Glide - but not in my google sheet

**URL:** <https://community.glideapps.com/t/data-shows-in-glide-but-not-in-my-google-sheet/22778>\
**Category:** Ask for Help\
**Created:** [February 14, 2021, 7:05pm UTC](https://community.glideapps.com/t/data-shows-in-glide-but-not-in-my-google-sheet/22778 "2021-02-14T19:05:17Z")\
**Posts on this page:** 14\
**Page:** 1

<div class="post-metadata">

**Author:** ![ErikBleifield](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erikbleifield/32/11777_2.png) [@ErikBleifield](https://community.glideapps.com/u/ErikBleifield)\
**Post date:** [February 14, 2021, 7:05pm UTC](https://community.glideapps.com/t/data-shows-in-glide-but-not-in-my-google-sheet/22778/1 "2021-02-14T19:05:17Z")

</div>

Hi,

I am seeing a strange issue in an app I am working on: when I add new data in my app - on my phone - it shows up in the app and in the Glide builder UI. But it does not show up in my linked Google sheet.

When I add data to the Google sheet directly, it shows up in the app and in the Glide builder. (So I know I am looking at the linked Google sheet.)

Then, after a few minutes, the data I entered from my phone disappears from my app and the Glide builder. If I post again from my phone, the data reappears in the app and in the Glide builder UI. But never shows up in my Google sheet.

It seems like several layers of strange behavior. Can anyone offer any insights or assistance?

Thanks,

----Erik

---

<div class="post-metadata">

**Author:** ![AymenM](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aymenm/32/21370_2.png) [@AymenM](https://community.glideapps.com/u/AymenM)\
**Post date:** [February 14, 2021, 7:08pm UTC](https://community.glideapps.com/t/data-shows-in-glide-but-not-in-my-google-sheet/22778/2 "2021-02-14T19:08:20Z")

</div>

Hey !

Thanks for sharing your issue with us. Please check that your issue is not related to following post and/or topic ⬇

> [@My app doesn't refresh sheets data when modified through the app](https://community.glideapps.com/t/my-app-doesnt-refresh-sheets-data-when-modified-through-the-app/2442/7):
>
> It seems you have empty columns in your spreadsheet, which confuses Glide. Please try removing those, that should fix the reloading issues.

If the issue persists please let us know 🙂

---

<div class="post-metadata">

**Author:** ![ErikBleifield](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erikbleifield/32/11777_2.png) [@ErikBleifield](https://community.glideapps.com/u/ErikBleifield)\
**Post date:** [February 14, 2021, 9:51pm UTC](https://community.glideapps.com/t/data-shows-in-glide-but-not-in-my-google-sheet/22778/3 "2021-02-14T21:51:53Z")

</div>

Hi -

I am using ARRAYCOLUMN formulas. They appear to be working fine. I do not have any data being written mid google sheet.

I do not have any blank columns.

I am not sure the post you shared is helpful in fixing my issue.

Are there some specific GOTCHAs that cause this sort of issue?

Thanks,

-----Erik

---

<div class="post-metadata">

**Author:** ![AymenM](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aymenm/32/21370_2.png) [@AymenM](https://community.glideapps.com/u/AymenM)\
**Post date:** [February 14, 2021, 10:18pm UTC](https://community.glideapps.com/t/data-shows-in-glide-but-not-in-my-google-sheet/22778/4 "2021-02-14T22:18:58Z")

</div>

Thanks. Any help on that @Jeff_Hager ?

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [February 15, 2021, 8:53am UTC](https://community.glideapps.com/t/data-shows-in-glide-but-not-in-my-google-sheet/22778/5 "2021-02-15T08:53:05Z")

</div>

Do you have any rows that are written really down below (like row 501, 1001)?

---

<div class="post-metadata">

**Author:** ![ErikBleifield](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erikbleifield/32/11777_2.png) [@ErikBleifield](https://community.glideapps.com/u/ErikBleifield)\
**Post date:** [February 15, 2021, 1:38pm UTC](https://community.glideapps.com/t/data-shows-in-glide-but-not-in-my-google-sheet/22778/6 "2021-02-15T13:38:19Z")

</div>

No. I have tried to “find” my records - but they are no where in the sheet.

---

<div class="post-metadata">

**Author:** ![ErikBleifield](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erikbleifield/32/11777_2.png) [@ErikBleifield](https://community.glideapps.com/u/ErikBleifield)\
**Post date:** [February 15, 2021, 1:39pm UTC](https://community.glideapps.com/t/data-shows-in-glide-but-not-in-my-google-sheet/22778/7 "2021-02-15T13:39:56Z")

</div>

Wait I am wrong. I just found them.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [February 15, 2021, 1:39pm UTC](https://community.glideapps.com/t/data-shows-in-glide-but-not-in-my-google-sheet/22778/8 "2021-02-15T13:39:58Z")

</div>

Can you reproduce the problem now?

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [February 15, 2021, 1:40pm UTC](https://community.glideapps.com/t/data-shows-in-glide-but-not-in-my-google-sheet/22778/9 "2021-02-15T13:40:25Z")

</div>

This was because you use an ARRAYFORMULA. You should delete all empty rows so that this won’t happen again.

---

<div class="post-metadata">

**Author:** ![ErikBleifield](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erikbleifield/32/11777_2.png) [@ErikBleifield](https://community.glideapps.com/u/ErikBleifield)\
**Post date:** [February 15, 2021, 1:40pm UTC](https://community.glideapps.com/t/data-shows-in-glide-but-not-in-my-google-sheet/22778/10 "2021-02-15T13:40:25Z")

</div>

49797

---

<div class="post-metadata">

**Author:** ![ErikBleifield](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erikbleifield/32/11777_2.png) [@ErikBleifield](https://community.glideapps.com/u/ErikBleifield)\
**Post date:** [February 15, 2021, 2:08pm UTC](https://community.glideapps.com/t/data-shows-in-glide-but-not-in-my-google-sheet/22778/11 "2021-02-15T14:08:33Z")

</div>

Thanks!

---

<div class="post-metadata">

**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\
**Post date:** [February 15, 2021, 3:05pm UTC](https://community.glideapps.com/t/data-shows-in-glide-but-not-in-my-google-sheet/22778/12 "2021-02-15T15:05:28Z")

</div>



---

<div class="post-metadata">

**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\
**Post date:** [February 15, 2021, 5:28pm UTC](https://community.glideapps.com/t/data-shows-in-glide-but-not-in-my-google-sheet/22778/13 "2021-02-15T17:28:09Z")

</div>



---

<div class="post-metadata">

**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\
**Post date:** [January 17, 2024, 4:53pm UTC](https://community.glideapps.com/t/data-shows-in-glide-but-not-in-my-google-sheet/22778/14 "2024-01-17T16:53:28Z")

</div>


