The following Google Apps Script is designed to bulk create Google Shared drives all from data in a Google Sheet. It has been packaged into a downloadable tool that you can easily use.
- Provide the name of the Shared drive on each row in column A.
- Provide the email address(es) of the Google Account(s) under the relevant Access level column (Manager, Content Manager, Contributor, Commenter, Viewer). Use a comma and a space to separate multiple email addresses, eg: example1@example.com, example2@example.com, example3@example.com.
- Ensure you include at least one Manager - the script will check for this - so as to prevent creating a Shared drive that you are then unable to access.
- On the 'Config' sheet provide the column numbers - leave the default values unless you change the structure of the 'Data' sheet and move columns around.
- The 'Log' sheet should help to troubleshoot any errors you experience, but there will also be a popup message should the script fail at some point.
 |
| Bulk create Shared drives from a Google Sheet |
Enable Drive API Service
Make sure you have followed the instructions here to enable the Drive API Service if you are creating this from scratch yourself.
Download
Bulk create Shared drives with permissions download here (please use 'File' > 'Make a copy' for your own version).
I like this script. Though, my use case is to create a Shared Drive with a "sub folder" hierarchy as well.
ReplyDeleteLike
Name of Shared Drive
- sub folder
- sub-sub folder
- sub-sub folder 2
- sub folder 2
I have the hierarchy. Is this a revision that is possible? Has anyone else ever asked about this?
Thank you John.
DeleteYes that would be feasible in terms of Apps Script. I don't have an immediate tool available to do it.
I do freelance work if it's something you'd like me to develop for you (it shouldn't be too cumbersome): https://www.pbainbridge.co.uk/p/freelance.html
Kind regards
Phil