Tuesday, 7 April 2020

Bulk change ownership of Google Drive items

The following Google Apps Script is designed to bulk transfer ownership of Google Drive files/folders by iterating through them. It gets the current owner and compares that to the new designated owner before making the change. This particular example will retain the previous owner as an editor of the item.
Screenshot of transfer tool requirements
Screenshot of transfer tool requirements

A 'while' loop is used to cycle through and 'getFiles' in the first instance. From here we can get the email address of the current owner:
var currentFileOwner = file.getOwner().getEmail();
Using an 'if' statement we can then look for a match with the current owner specified on the Welcome sheet and if one is found the new owner can be set:
if (currentFileOwner == currentOwner) {
   file.setOwner(newOwner);
}
The process can then be repeated for sub-folders ('getFolders') which at the end we pass this folder ID back into the Function (hence creating a loop).


File Download

Download the Bulk change ownership of Google Drive items here. Please use 'File' > 'Make a copy' for your own version.


Labels: , ,

15 comments:

  1. Jeffrey Bary12 July 2021 at 14:38

    What is the format of "Source Folder ID"?

    ReplyDelete
    Replies
    1. Phil Bainbridge12 July 2021 at 20:37

      Hi Jeffrey

      It's the long string of characters in the Url that Google Drive uses for its ID. For example: https://drive.google.com/drive/folders/THIS PART IS THE ID

      Kind regards
      Phil

      Delete
    2. Jeffrey Bary12 July 2021 at 22:08

      Thanks, I'll give it a try.

      Delete
  2. UNIQedumx7 August 2021 at 07:18

    I checked it with the spreadsheet but it didn't work for me, then I went to the script editor, leaving the data in the spreadsheet and it worked without problems
    Thanks friend, I was looking for a solution to a code that I have for a long time but it stopped me with a time limit error

    ReplyDelete
    Replies
    1. Phil Bainbridge8 August 2021 at 17:49

      Hi

      I've double checked the sheet/script and all seems to be fine. It won't run the very first time you authorise against your Google account (as Google makes you click to run it again as a security measure).

      Thank you for the feedback.

      Kind regards
      Phil

      Delete
    2. Unknown30 August 2021 at 04:08

      I ran into that same "Exceeded maximum execution time" error. If you've got so many files that it takes longer than 6 minutes, you'll need to try one of these strategies: https://stackoverflow.com/questions/14450819/google-app-script-timeout-5-minutes

      Delete
    3. Phil Bainbridge30 August 2021 at 18:46

      Hi

      Yes you are correct about the limits (https://developers.google.com/apps-script/guides/services/quotas) at the time of developing this it was a small number of items and we had 30 minutes for execution.

      Kind regards
      Phil

      Delete
  3. Unknown30 August 2021 at 05:06

    Here's a script that takes into consideration the 6-minute time limit. It saves a continuationToken so you can start back up where you left off.

    https://stackoverflow.com/a/54104948

    Here's my adaptation of the bulk change script using the continuation token: https://gist.github.com/TurekBot/6da5acd27f92c86dc68d3f6588eeb499

    ReplyDelete
    Replies
    1. Phil Bainbridge30 August 2021 at 18:47

      Cool, thanks for sharing.

      Kind regards
      Phil

      Delete
    2. Unknown21 December 2021 at 01:40

      How do you add that adaptation into the Google Sheets already made? Sorry, I am very inexperienced with using code.

      Delete
    3. Phil Bainbridge22 December 2021 at 10:32

      Hi

      You would need to use the Apps Script Editor. Here is the Google site to get started with learning Apps Script: https://developers.google.com/apps-script

      Kind regards
      Phil

      Delete
  4. Deb and Steve24 November 2021 at 10:55

    Hi, does this only work for google files? I am trying to change ownership for a folder of JPGs and it fails at the line to to set new owner.

    ReplyDelete
    Replies
    1. Phil Bainbridge24 November 2021 at 17:18

      Hi

      No, I've just tested it on a folder of JPGs and it worked perfectly fine.

      Kind regards
      Phil

      Delete
  5. Unknown11 January 2022 at 09:10

    Hi there, thanks for the script! It doesn't seem to work with jpg. How did you make it work @phil?

    ReplyDelete
    Replies
    1. Phil Bainbridge11 January 2022 at 13:34

      Hi

      You're welcome.

      As mentioned above it works fine for me with JPGs. The only time I've not seen it work (in general) is when changing the owner to an account that belongs to another domain (eg a business).

      Kind regards
      Phil

      Delete

Subscribe to: Post Comments (Atom)