https://myaccount.google.com/permissions - try that. You can revoke the existing permissions through there, and then if you run it manually you should be prompted to approve it again.
change the failure settings to notify immediately… maybe it will tell you whats going on
I remember one time I duplicated my script so there were 2 functions with the same name, and it give me some trouble… maybe that’s the case?
so i revoked permissions, manually ran then prompted me to approve permissions again.
but script is still not been triggered by a sheet change 
starting to think it may be a google-side issue perhaps
checked all my function names and there’s no duplicates
ugh 
I’m running out of ideas.
Maybe one more thing to try… make a copy of the sheet, then attach the copied sheet to your Glide app (ie. replace existing sheet). Grasping at straws here, but that might be worth a shot…
1 Like
I’m a little nervous doing that, this is a prod app with 2.5k+ users and processing a considerable amount of sales/revenue, I don’t what to completely break it
You could try it with a copy of the app first.
oh, maybe you run out of quotas for that script… any API there?
The issue is that there’s not even an execution entry when the sheet is changed as is supposed to…
The last working execution based on a sheet changed (Type = Trigger) highlighted below was approx 2 hours ago, the other entries (Type = Editor) after that have been manually executed trying to debug.
I do have connected APIs everywhere including Google-services but its connected to a paid account so no quota issues that I can think of.
I copied the app attached to the same sheet, made updates to the sheet via the app but still doesn’t trigger an execution.
if you have a paid account, just contact google support… they answer right away
My suggestion was to also try copying the sheet… then see if it triggers with the copied sheet. You’d need to run it manually once first.
1 Like
soo copying the app and sheet works! very strange!
would you then suggest to attach the copied sheet to my prod app?
Yes 
I can’t explain what happened, but it does sound like something “broke” in the original Google Sheet.
Before I hit “replace” what’s the back-out plan? is there any other risks that any other features in the app will not work?
just s little nervous 
As long as you’ve not made any structural changes to the copied sheet, I think you should be pretty safe. I’ve done this before, and seen others do it, and I think it’s pretty reliable.
I assume you now have a working backup copy of the app? That would be your fallback - if it all goes pear shaped, you should be able to promote that backup to be your new production app.
ok - so I hit replace, tested it on my installed app on my phone and all seems to be working fine and back to normal.
I can now see the executions being triggered from the sheet (type = Trigger) in the log execution logs.
this is the first time i encounter this type of issue - thanks soo much for your help!
Excellent!
Glad you got it working, and happy to help. Still a bit of a mystery as to what went wrong though. Would be nice to know…
1 Like
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.