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.
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.
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.