Error 1035 (Make sure the sheet exists and has not been moved to a different location that causes the Glide login email account to not be able to access the sheet.)

First time reporting a bug? Refer to our Start Here post.


Untitled-2

Intermittently, the synchronization of the Google Sheets and Glide apps you are using stops syncing and “Error 1035” appears.

I am using the Glide “Legacy Pro” plan with my personal Gmail account. (in use for several years)

Recently, in order to revamp the service, we have additionally subscribed to the ‘Maker’ version of Glide with a Google Business account and are working on development.

  • I’ve never had this problem with the “Legacy Pro” plan, which I’ve been using as a personal email account for several years.

  • This problem (Error 1035) appears intermittently in the “Maker” version recently subscribed to through a Google Business account.

After checking through this community, it seems that there is a way to duplicate Google Spreadsheets and reconnect, but I think it is a temporary solution.

Additionally, since Google AppScript is currently being used, the method of reconnecting Google Spreadsheet as a clone requires modifying the related AppScript as well.

Is there already a fundamental solution to this?

If anyone knows a solution, I would be very grateful if you could let me know.~!

1 Like

I have the same exact problem, no idea why Glide does that. Maybe it’s complications with sharing or the new plans.

It seems that this problem has not been resolved to this day. The same symptoms continue to appear.

I am currently using both a personal Google account and a business Google account.

Even though I successfully switched accounts in the Chrome browser, the synchronization between Google Sheets and Glide is disconnected.

In the end, you have to reset the Chrome browser you are using, turn it off, and then open it again to access it for normal synchronization between Google Sheets and Glide.

When the service is actually launched, at least 500 customers are expected to use it, and since it is a service that can involve a lot of money, there are concerns that serious problems may arise as a result.

Is there any solution?

I don’t have any answers as to what’s happening, but I also don’t use two separate accounts to built my apps, so I haven’t run into any issues keeping google sheets synced.

First and foremost, I would be testing the published version of your app. The builder may be getting confused because you are switching between accounts and it might be doing some of that syncing locally on your computer instead of on the server, but your personal browser should have no bearing on others that are using your app. In the end, it’s the connection between glide servers and your google account that matters. Not the account your browser is signed into.

I’m not sure if it would help, but you could add your personal google account as an editor in your maker plan. Then you only need to sign into glide with you personal account and you can work with both plans without having to switch users.

For anyone else that might read this in the future, the trick when juggling multiple Google accounts is to keep each one in a separate browser profile. I currently use six separate Google accounts (and six associated Glide accounts) for building with Glide. I keep each one in a separate Arc Browser Space, so each has it’s own independent cache, cookie store and saved passwords. Before I switched to Arc, I did the same with Chrome profiles. I’m always very careful to only ever sign into one single Google account from each workspace. This keeps everything nice and clean, and I almost never have issues with Google accounts tripping over each other.

4 Likes

: Thank you for your explanation. :slight_smile: I’d like to ask because I don’t understand the inside of the exact sync part yet. As you said, even if the spreadsheet and glide disconnects as above in the browser on my PC, there will be no problem with users using this glide app. Is that correct?

It should be that way, as long as the connection between Glide servers and your Google account (as the developer/owner) is still intact.

I don’t think there should be a problem. Your browser may be making connections to google separately from the Glide servers. This is only a guess though. I’m not really sure.

Just thinking of a somewhat similar case, I believe when you are working on a google sheet on your computer, all calculations actually use your computer’s processing power. When you close that google sheet, then calculations actually use google server processing power. I’m thinking there may be some similarities with how Glide works when you are in the builder. This is something that I’ve observed personally. When something updates in my Google sheet and I happen to have it open, my computer actually starts working harder to process the calculations and actually takes longer. When I close the google sheet, then things prices a little faster.

1 Like

Ah… I understand. We will continue to test this part while making Glide.~!
thank you for the reply. :slight_smile:

1 Like

We’re having the same issue (Error 1035) but we’re using Excel in OneDrive as the data source. I have reached to Glide support last week but there has been no reply as of yet. My main account was signed up under my Google email using SSO.

Has anyone discovered a solution? We haven’t been able to sync with Glide for over 10 days now.

i’ve noticed the same, easiest way is to “replace” the data source with the original content, this will prompt the Google Drive / Sheets authentication again:

see screenshot:

2 Likes