# App won't refresh with google sheets
**URL:** https://community.glideapps.com/t/app-wont-refresh-with-google-sheets/66814
**Category:** Ask for Help
**Tags:** data-sync
**Created:** [October 6, 2023, 9:48pm UTC](https://community.glideapps.com/t/app-wont-refresh-with-google-sheets/66814 "2023-10-06T21:48:34Z")
**Posts on this page:** 16
**Page:** 1
### Author:  [@melisse\_leib](https://community.glideapps.com/u/melisse_leib)
#### Post date: [October 6, 2023, 9:48pm UTC](https://community.glideapps.com/t/app-wont-refresh-with-google-sheets/66814/1 "2023-10-06T21:48:34Z")
I can’t get my google-sheet app to refresh, unless I put the app in “extra” mode, and even with that it takes 3 minutes to refresh.
My app consists primarily of two tables: drivers and riders, and I match riders to drivers with a relation that is many-to-one. Specifically, each rider has 0 or one driver, and that field is changable. Screen shots are attached. It’s a fairly small app, no more than 50 riders and drivers, though the Destinations table has 186 rows.
Is this behavior expected? Are there any workarounds?
I could use glide tables, but google sheets are far more user-friendly. Would excel be a better alternative?
* * *
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [October 6, 2023, 9:52pm UTC](https://community.glideapps.com/t/app-wont-refresh-with-google-sheets/66814/2 "2023-10-06T21:52:59Z")
What’s not syncing? Is data changing in the app that’s not syncing to the sheet, or is data changing in the sheet that’s not syncing to the app?
---
### Author:  [@melisse\_leib](https://community.glideapps.com/u/melisse_leib)
#### Post date: [October 6, 2023, 10:03pm UTC](https://community.glideapps.com/t/app-wont-refresh-with-google-sheets/66814/3 "2023-10-06T22:03:02Z")
The data changing in the sheet isn’t syncing in the app
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [October 6, 2023, 10:08pm UTC](https://community.glideapps.com/t/app-wont-refresh-with-google-sheets/66814/4 "2023-10-06T22:08:58Z")
What kind of calculations or logic is happening in the sheet? Is it something that could be moved into Glide? The general recommendation is to move as much logic into Glide as possible so you can have a responsive app instead of waiting for data to sync back and forth.
I use Google sheets in one of my apps, but most computation logic is in Glide. For me the google sheet is just a place to store raw data. The sheet doesn’t do any calculations unless it’s something I absolutely cannot reproduce on the Glide side.
---
### Author:  [@melisse\_leib](https://community.glideapps.com/u/melisse_leib)
#### Post date: [October 6, 2023, 10:15pm UTC](https://community.glideapps.com/t/app-wont-refresh-with-google-sheets/66814/5 "2023-10-06T22:15:16Z")
There really isn’t any logic or calculations going on in the google sheet, and I could work to replace it. Do you think that is the problem?
---
### Author:  [@melisse\_leib](https://community.glideapps.com/u/melisse_leib)
#### Post date: [October 6, 2023, 10:19pm UTC](https://community.glideapps.com/t/app-wont-refresh-with-google-sheets/66814/6 "2023-10-06T22:19:19Z")
I noticed a few concatenate operations on the sheet, which I can move to Glide
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [October 6, 2023, 10:22pm UTC](https://community.glideapps.com/t/app-wont-refresh-with-google-sheets/66814/7 "2023-10-06T22:22:23Z")
Concat operations can be replaced with a template column in Glide.
Other than the concats, if the sheet is not doing much else, then why do you say that there is a sync issue from the google sheet to glide? Sounds like all interaction with the data should be happening in the app, so it really should only be syncing TO the google sheet. In that case, so would think the timing of the sync really shouldn’t matter.
---
### Author:  [@melisse\_leib](https://community.glideapps.com/u/melisse_leib)
#### Post date: [October 6, 2023, 10:31pm UTC](https://community.glideapps.com/t/app-wont-refresh-with-google-sheets/66814/8 "2023-10-06T22:31:54Z")
> > then why do you say that there is a sync issue from the google sheet to glide?
Actually, an administrator edits the sheet, assigning drivers to riders
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [October 6, 2023, 10:33pm UTC](https://community.glideapps.com/t/app-wont-refresh-with-google-sheets/66814/9 "2023-10-06T22:33:10Z")
Would it be better to build that assignment process into the same app, or a secondary app?
The problem is that it’s up to Google to send data to Glide if the data is changing via the sheet. Google only does that every few minutes or more at their discretion. Turning extra sync on in Glide can help a little bit as Glide will then request data from Google, but that’s also every few minutes. There is a cost associated with syncing the data that often, so it’s not feasible to sync all tables every few seconds. Instead you are stuck with a sync that happens every few minutes at best.
---
### Author:  [@melisse\_leib](https://community.glideapps.com/u/melisse_leib)
#### Post date: [October 6, 2023, 10:46pm UTC](https://community.glideapps.com/t/app-wont-refresh-with-google-sheets/66814/10 "2023-10-06T22:46:53Z")
Not really, it’s just so much easier to do the assignment process on a google sheet. Is there a workaround to get google to send the data more frequently? Would excel be a better alternative?
---
### Author:  [@melisse\_leib](https://community.glideapps.com/u/melisse_leib)
#### Post date: [October 6, 2023, 10:54pm UTC](https://community.glideapps.com/t/app-wont-refresh-with-google-sheets/66814/11 "2023-10-06T22:54:16Z")
Also, I’m not sure what you mean by secondary app. If it is a completely separate app, then it would write the assignment to the google sheet. Wouldn’t I have the same issues?
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [October 6, 2023, 11:02pm UTC](https://community.glideapps.com/t/app-wont-refresh-with-google-sheets/66814/12 "2023-10-06T23:02:04Z")
> [@melisse\_leib](#):
>
> Is there a workaround to get google to send the data more frequently? Would excel be a better alternative?
Not really. That’s just how google sheets work…unless a paid version of google services would be better, but I don’t know and I kind of doubt it. I can’t vouch for Excel, but I doubt it would be any better.
> [@melisse\_leib](#):
>
> If it is a completely separate app, then it would write the assignment to the google sheet. Wouldn’t I have the same issues?
I don’t think it would be the same. Glide keeps a separate copy of the data and syncs it with the google sheet. The app only ever communicates with Glide servers and has no knowledge of the existence of a google sheet. Glide servers then sync with the google sheet. Two separate apps would be communicating directly with Glide and Glide’s copy of the data, so the sync between apps should be fairly quick.
If you don’t trust that solution, then I would just build an Admin interface into your existing app. Build screens that only you can access to assign drivers. The drivers won’t see that part of the app. Then it’s a single app that is always communicating with Glide’s copy of the data and all users get those updates almost instantly.
---
### Author:  [@nathanaelb](https://community.glideapps.com/u/nathanaelb)
#### Post date: [October 7, 2023, 9:14am UTC](https://community.glideapps.com/t/app-wont-refresh-with-google-sheets/66814/13 "2023-10-07T09:14:53Z")
> [@melisse\_leib](#):
>
> it’s just so much easier to do the assignment process on a google sheet
Have you considered the assignment process either via your app or another driver assignment app? I think this is what Jeff is suggesting. Assigning via an app could be easier and quicker than assigning via Google Sheets because the data could be populating a Glide Table (no sync required) instead of a Google Sheet (sync required).
---
### Author:  [@melisse\_leib](https://community.glideapps.com/u/melisse_leib)
#### Post date: [October 7, 2023, 3:42pm UTC](https://community.glideapps.com/t/app-wont-refresh-with-google-sheets/66814/14 "2023-10-07T15:42:42Z")
Yes, I have considered it, and I understand that it is what Jeff is suggesting. It is definitely quicker, but I don’t think it’s easier because it requires a lot of information that is on the google sheet. Regardless, I have asked my user what she thinks of the idea, and we’ll go from there, as it might not be a problem with the 3-minute delay
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [October 8, 2023, 12:51am UTC](https://community.glideapps.com/t/app-wont-refresh-with-google-sheets/66814/15 "2023-10-08T00:51:21Z")
> [@melisse\_leib](#):
>
> I don’t think it’s easier because it requires a lot of information that is on the google sheet.
Can you go into more details about this part? What logic are you using for this process that relies on the Google Sheets info?
---
### Author:  [@melisse\_leib](https://community.glideapps.com/u/melisse_leib)
#### Post date: [October 8, 2023, 3:48am UTC](https://community.glideapps.com/t/app-wont-refresh-with-google-sheets/66814/16 "2023-10-08T03:48:01Z")
The problems are:
1. Screen real estate. The dispatcher needs to have a lot of room to navigate.
2. I may need to use information about other riders and drivers that are not the ones being assigned.