I have been working with Google Sheets and running various scripts that ask for authorization when I click certain buttons or triggers. Now I want to check what permissions I have granted to these scripts over time. Is there a way to see a complete list of all the script authorizations I have approved? I also want to know if I can remove or revoke these permissions if I no longer need them. I think these scripts only run locally but I want to make sure I can manage the access properly. Where do I find this information in my Google account settings?
The security section’s a good start, but here’s another trick. When you’re in Google Sheets, hit Extensions > Apps Script to see exactly which scripts are attached to that specific spreadsheet and what permissions they need. I like keeping track of scripts I actually made versus ones from add-ons or shared templates. You’ll be surprised how many old scripts pile up in sheets you forgot about - they keep their permissions even when you’re not using them. Also check script.google.com for the full picture if you’ve got scripts scattered across different sheets.
Heads up - if you’ve shared sheets with others, their scripts can still access your data even after you revoke collaboration. Check sharing settings on each individual sheet, not just the main permissions page. Found this out when an old coworker’s script kept running on a sheet we’d shared months ago. Also, some scripts create time-based triggers that run in the background indefinitely.
Go to myaccount.google.com/permissions to manage your Google Sheets script permissions. You’ll see every app and script that can access your Google services, including Sheets ones. Each shows what permissions you’ve granted and when it was last used. Want to remove one? Just select it and hit ‘Remove Access’ - that kills all permissions for that script. Remember, these scripts run on Google’s servers and need OAuth authorization, not on your computer. I’d check this list regularly and clean out stuff you’re not using anymore to keep your account secure.
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.