I manage a dashboard that has a lot of different Google Docs, Sheets, etc. There is a team of about 100 individuals and I want to dynamically add/remove them from the files, as well as change editor/viewer of the files based on a master sheet with all of the links (or IDs) of the files.
Here is a sample of the master sheet: Sample Sheet
I do not have the ability to use Google Groups, as it is restricted by the Admin of the domain. My research shows that it will need to be an Apps Script, but I do not know enought about coding to write something that will work.