# Google Sheet used in Glide and Looker Studio not sync

**URL:** <https://community.glideapps.com/t/google-sheet-used-in-glide-and-looker-studio-not-sync/63709>\
**Category:** Ask for Help\
**Created:** [July 10, 2023, 9:13am UTC](https://community.glideapps.com/t/google-sheet-used-in-glide-and-looker-studio-not-sync/63709 "2023-07-10T09:13:21Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Darren\_Teoh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_teoh/32/61016_2.png) [@Darren\_Teoh](https://community.glideapps.com/u/Darren_Teoh)\
**Post date:** [July 10, 2023, 9:13am UTC](https://community.glideapps.com/t/google-sheet-used-in-glide-and-looker-studio-not-sync/63709/1 "2023-07-10T09:13:21Z")

</div>

I plan to use Google Looker Studio to plot a dashboard for reports. The same Google Sheet will be used as Data Source by Glide. However, I found that Google Looker Studio now locked this Google Sheet. Glide Apps data written to this Google Sheet no longer able to update.

 ![glide_GoogleSheet_cant_update_after_shared_with_looker_studio](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/a/6a235c3d4b94519362862213c15ac47b50bd3c89.png)

Glide refresh google sheet get error code 1035!!  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/9/a909fdb16427bd23548670c67b90c94ec09097ea.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:** [July 10, 2023, 9:20am UTC](https://community.glideapps.com/t/google-sheet-used-in-glide-and-looker-studio-not-sync/63709/2 "2023-07-10T09:20:44Z")

</div>

Are you still able to access the Google Sheet using the same Google Account that you log in to Glide with?

I’d suggest checking the permissions on the sheet and make sure that account has access.

---

<div class="post-metadata">

**Author:** ![Darren\_Teoh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_teoh/32/61016_2.png) [@Darren\_Teoh](https://community.glideapps.com/u/Darren_Teoh)\
**Post date:** [July 11, 2023, 2:50am UTC](https://community.glideapps.com/t/google-sheet-used-in-glide-and-looker-studio-not-sync/63709/3 "2023-07-11T02:50:22Z")

</div>

Hi Darren,

I have created a credential to access GoogleSheet through APIs. Since after this, my Glide can’t sync up with Google Sheet. Even when I trying to create a new Glide project using Google Sheet, the process just stopped and no new project creation based on Glide. I still have access to this Google Sheet through Google Drive and made change.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/6/06fb81c04bc7dad158fd1ed25461e88011f9995d.png)

I have created a credential access Key for my Google Sheet API. But I am not sure if this is the reason?

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/b/cbb2163ed38285722dad97c40ebbd797a41a275d.png)

---

<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:** [July 11, 2023, 1:58pm UTC](https://community.glideapps.com/t/google-sheet-used-in-glide-and-looker-studio-not-sync/63709/4 "2023-07-11T13:58:25Z")

</div>

Have you tried scrolling all the way down on the Sheet to see if the data is down there?

---

<div class="post-metadata">

**Author:** ![Darren\_Teoh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_teoh/32/61016_2.png) [@Darren\_Teoh](https://community.glideapps.com/u/Darren_Teoh)\
**Post date:** [July 12, 2023, 2:48am UTC](https://community.glideapps.com/t/google-sheet-used-in-glide-and-looker-studio-not-sync/63709/5 "2023-07-12T02:48:36Z")

</div>

Just tried… there is none.

---

<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:** [July 12, 2023, 11:58pm UTC](https://community.glideapps.com/t/google-sheet-used-in-glide-and-looker-studio-not-sync/63709/6 "2023-07-12T23:58:38Z")

</div>

That’s weird. I would try submitting a ticket.

> [@How to open a support ticket?](https://community.glideapps.com/t/how-to-open-a-support-ticket/59883/2):
>
> Please note: the option to create a support ticket is only available if your App is in a Pro, Business or Enterprise Team. If you need help with a Billing Issue (on any plan), you should open a Billing Enquiry via the [Glide Support Page](https://www.glideapps.com/support). To create a Support Ticket: Open the App that is giving you problems, and go to Settings → Contact Support: Glide will prompt you to create a support link for your App. Click on Create Link:

---

<div class="post-metadata">

**Author:** ![George-Glide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george-glide/32/22384_2.png) [@George-Glide](https://community.glideapps.com/u/George-Glide)\
**Post date:** [July 15, 2023, 3:04am UTC](https://community.glideapps.com/t/google-sheet-used-in-glide-and-looker-studio-not-sync/63709/7 "2023-07-15T03:04:59Z")

</div>

If Looker Studio is locking the Google sheet there is nothing Glide can do to write to it. Glide uses the standard Google sheet API and the API is not allowing us to write to the sheet. You could try using a separate sheet for the Looker reports and use an Importrange() function to pull in the data from the other sheet that is linked to the Glide app.

---

<div class="post-metadata">

**Author:** ![George-Glide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george-glide/32/22384_2.png) [@George-Glide](https://community.glideapps.com/u/George-Glide)\
**Post date:** [July 16, 2023, 3:03am UTC](https://community.glideapps.com/t/google-sheet-used-in-glide-and-looker-studio-not-sync/63709/8 "2023-07-16T03:03:08Z")

</div>


