SyncPermissions

A tiny tool to synchronize permissions for Google Drive.

The original spreadsheet is here.
Related article is here.

What is this?

This is a tool to manage and synchronize each user's permissions to various resources in Google Drive.

How to use?

1. Copy the original spreadsheet (only once).

Open this spreadsheat, click [File]-[Make a copy], and save it to your Google Drive with a name of your choice. (You must be signed in with a Google account.)

ℹ️ If you want to copy the spreadsheet directly into your "My Drive", click on this link.

2. Enter the resources to be managed

Enter the ID of the file or folder you want to manage in the resource id line. (resource name is optional.)
You need to be an owner of those files or folders.

How do you know the ID of a file or folder?
The ID is a part of the URL when you've opened the file.

For example:

⚠️Caution:
If you want to set permissions for both the parent folder and child folders or files, enter the parent on the left side of the column so that the parent is processed first.

3. Enter the users to be managed

Enter the Gmail addresses of the users you want to manage.

4. Enter the permissions for each user

Enter the character you want to set in each cell.

• R: read only (=viewer)
• W: writable (=editor)
• [Empty]: no access (the access rights will be removed.)

5. Click the Run button

When you are ready, press the Run button to run the program.

6. Authorize the script to run (only once)

The first time you run it, you will see a dialog asking for permission to run the script.
Follow the steps below to allow the script to run.

• Click Continue

• Select your account (Perhaps it will be a different procedure for signing in.)

• Click Advanced.

• Click Go to SyncPermissions (unsafe).

• Click Allow.

• Then click Run button again.

  Don't worry about the word "unsafe". It's a dialog that all of us face when running our personal scripts.👍

7. Click OK

Check "Process only the selected range" if you want to process only the settings of the selected range.

8. Wait until the process is done

When mini-console shows Done, All processing will have completed.
This tool uses the LongRun class to be able to handle a large number of settings; if you see 'Pausing for long processing time...', the process will resume after a minute or so.