Auto-Organize Google Drive Files with Apps Script

Drive file organizers sort uploads from email attachments, form uploads, or shared inbox folders into YYYY/MM/client hierarchies automatically on schedule.

Rules read from OrganizerRules sheet: if MIME contains pdf and name contains Invoice route to Finance/Invoices. First match wins unless priority column sorts rules.

Works with DriveApp iterators; log moves to Moves tab for undo guidance, Drive lacks full undo API.

Example code

function organizeInbox() {
  const inbox = DriveApp.getFolderById('INBOX_FOLDER_ID');
  const rules = SpreadsheetApp.openById('RULES_SHEET_ID').getSheetByName('Rules').getDataRange().getValues();
  rules.shift();
  const files = inbox.getFiles();
  let n = 0;
  while (files.hasNext() && n < 100) {
    const file = files.next();
    const dest = resolveDestination(file, rules);
    if (dest) file.moveTo(DriveApp.getFolderById(dest));
    n++;
  }
}
function resolveDestination(file, rules) {
  const name = file.getName();
  const mime = file.getMimeType();
  for (var i = 0; i < rules.length; i++) {
    if (mime.indexOf(rules[i][0]) >= 0 && name.indexOf(rules[i][1]) >= 0) return rules[i][2];
  }
  return null;
}

FAQ