Too much google sync

Hey, Andrey! The definition of a Sync from our Doc on Updates is below:

Syncs: When Glide reloads data from an external data source that has changed (e.g., Google Sheets, Excel), this counts as a Sync.

Is the data in your Google Sheet changing? This will cause syncs as Glide will reload the data from the external data source.

not much before (when i start this topic)
and not at all now. (but sync still appear)

@DJP Thank you for the clarification.

maybe you have the time now() function in GS… and your sheets are refreshing every hour?

no

GS - you mean google sheet or glide sheet?

in google i have no one calculation.

in glide - i have, but it’s not affect to sync.

GS (Google Sheets) GT (Glide Tables)

maybe you have extra syncs turned on in Glide settings?
so no Today() or Now() functions in GS?
then I have no idea… maybe a webhook? or trigger?

report:
i add a row
it’s affect as: 1 add, 1 edit (all in case of app logic) and 2 sync. :man_shrugging:

then for 20 minutes and no any activity - 1 more sync

then add one more row:
1 add, 1 edit (all in case of app logic) and 3 sync

it’s looks like add - affect to sync.

yes, after adding a row, Glide runs the second sync to update any GS computed columns… I noticed that… i guess, so you don’t need to wait for next auto sync,

in settings - “normal”
in GS no one function
i have a webhook during add - but it’s not work with GS.

trigger? what do you mean?

one more unexpected behavior:
in castom action used 2 setcolumn.

i run this action inside builder and… in usage appear 2 sync and 0 edits.
then i do same via app in usage appear 2 sync and 2 edits.

in GS i remove 1 row = 2 sync :man_shrugging:

when using editor, edits are not counted

While you have a Google Sheet open in your browser, it is constantly sending updates to Glide. Does any of your data depend on the current time?

hi David.

“While you have a Google Sheet open in your browser, it is constantly sending updates to Glide.”

does it means that even if the result of calculation same as before - Glide count it as new information and add a sync?

“Does any of your data depend on the current time?”

no.
i remove all formulas. no one any more in GS. (i check all tables, even that not in Glide)
but again and again to each activity (add or edit) - appear sync.

if no activity (for now) - almost no new sync. (for 6 and half hours appear 2 sync)

once i add a row (just a minute ago) emmediately appear +2 sync :sob:

and little bit later +1 sync.
like a echo

Hmm, we will have to check our logs here.

We don’t count syncs when no data changes.

1 Like

Please chek it :pray: :pray: :pray:
for the day and one hour:
6 add
47 edit
40 sync - why?!

i have no any formulas in GS
i close all windows with that GS

i pay for 2500 updates, but in fact will use about half of it. :exploding_head:

@david how can i send you a video with situation? i guess it can explaine extra sync, and give a key to find error.

@user19 you can use loom and share it here. I think you should open a Support ticket and we can work with support team there.