Script to move all files into a folder?

Tim

Hi all,

Can anyone help me with a Google script that moves all files found in the root directory of Google Drive into a specified folder?

Thank you!

Support from Sheetgo

@Gonzalo maybe you can help?

Gonzalo

Hi Tim,
Try the following script:

function moveFiles() {
  const rootFolderFiles = DriveApp.getFiles();
  const destinationFolder = DriveApp.getFolderById("<<enter your folder id>>");

  while(rootFolderFiles.hasNext()){
    let file = rootFolderFiles.next();
    file.moveTo(destinationFolder);
  }
}

Tim

Gonzalo it's working wonderfully, thank you!

Tim

@Gonzalo one small issue. It's moving the files but throwing this error. Why?

Gonzalo

Hi Tim,
I'm sorry, my reply was never submitted!
I couldn't find much on that error but you can try creating a new script and running the same code if it's not working.

Support from Sheetgo

Gonzalo I'm sorry, my reply was never submitted!

What was the error you were receiving?

Tim

Gonzalo I couldn't find much on that error but you can try creating a new script and running the same code if it's not working.

Same issue. Let me precise my goal so maybe your script is not entirely working towards that?

How can I reference the root folder as source and move all files from there to a folder inside root except for the script itself?

So my root has the following structure:

/
/destination folder
/your script
/file1
/file2

All files except your script should be moved to the destination folder.