Matching AppScript Creators to GCP AppScript sys- Projects

Google Workspace Developers Q&A
1

Our eng team is trying to do some GCP project cleanup. They sent me a huge list of “sys-” projects that are tied to AppScripts that have been created. They asked me to match each project with a creator to identify if the AppScript is still needed. I’m having trouble with this. I ran gam all users print filelist query "mimeType='application/vnd.google-apps.script'" todrive in GAM but none of what was reported seems to match any of the GCP projects.

Does anyone have any recommendations on a better approach or how to handle this clean up properly? Thanks!

2

I have not tried this myself, but if you have the latest version of GAM-Advanced, you can try to pull the script metadata specifically: gam all users print scripts

This should give you a column for parentId or projectId which often aligns with those sys- strings.

5

hmmm I got an invalid argument on that

6

I have only seen an ‘API Access Denied’ error. It was necessary to go to the GAM Project in the GCP Console and ensure the Google Apps Script API was turned ON, and then “gam update project”.