Move File To Folder

Form uploads land in one big “(File responses)” folder. Exports land in My Drive root. moveFileToFolder(fileId, folderOrId) puts a Drive file in the folder you choose and takes it out of every other parent. It’s idempotent — if the file is already there, it returns { moved: false } and changes nothing, so re-running a filing job is safe.

When to use

  • Filing Google Form upload files into per-client folders
  • Moving generated PDFs / CSVs out of My Drive root
  • Cleanup jobs that sort a dump folder by a sheet column

How to use this snippet

/** * Move a Drive file into a target folder and remove it from all other parents. * Idempotent: if the file already lives only in the target, nothing changes. * * @param {string} fileId * @param {string|GoogleAppsScript.Drive.Folder} folderOrId folder or folder id * @return {{moved: boolean, file: GoogleAppsScript.Drive.File}} */ function moveFileToFolder(fileId, folderOrId) { var file = DriveApp.getFileById(fileId); var target = typeof folderOrId === 'string' ? DriveApp.getFolderById(folderOrId) : folderOrId; var targetId = target.getId(); // 1. Where does the file live right now? var parents = []; var it = file.getParents(); while (it.hasNext()) parents.push(it.next()); var inTarget = parents.some(function (p) { return p.getId() === targetId; }); // 2. Already filed (and only there): do nothing. if (inTarget && parents.length === 1) { return { moved: false, file: file }; } // 3. moveTo swaps the parent in one call (My Drive and shared drives). if (!inTarget) { file.moveTo(target); } // 4. Older files can have several parents — remove any that aren't the target. var it2 = file.getParents(); while (it2.hasNext()) { var p = it2.next(); if (p.getId() !== targetId) p.removeFile(file); } return { moved: true, file: file }; }

Example

function fileUploadForClient(uploadUrlOrId, clientName) { var root = DriveApp.getFolderById( PropertiesService.getScriptProperties().getProperty('clientsRootId')); // Pair with extractDriveFileId + getOrCreateFolderPath var fileId = extractDriveFileId(uploadUrlOrId); var folder = getOrCreateFolderPath(root, clientName + '/Uploads'); var res = moveFileToFolder(fileId, folder); console.log('%s %s', res.moved ? 'Moved' : 'Already in place:', res.file.getName()); }

Tips:

  • The script’s account needs edit access to the file and the target folder. Moving into a shared drive also needs permission to add content there.
  • Pairs with extractDriveFileId (URLs → ids) and getOrCreateFolderPath (build Client/Uploads on demand).
  • Moving doesn’t change sharing on its own, but the file can pick up access from its new folder. Check who can see the target before filing client documents there.
  • Pass a Folder object when you’re moving many files into the same place; that saves a getFolderById per file.

Tip: NitroGAS Co-Pilot can combine extractDriveFileId, getOrCreateFolderPath, and moveFileToFolder into one filing function if you describe the folder layout you want.

Happy Coding!

Tags

NitroGAS Chrome Extension

Want this snippet handy inside the Apps Script editor? NitroGAS gives you free themes and snippets — plus optional Co-Pilot when you want a boost (1-week, 1-month, or yearly passes — no subscription). Happy Coding!

Get the Extension

Other Helpful Code Snippets:

Assert Required Keys

function assertRequiredKeys(obj, requiredKeys, opts) { opts = opts || {}; obj = obj || {}; var missing = (requiredKeys || []).filter(function (key) { var v = obj[key]; // Missing = undefined, null, empty, or only spaces. 0 and false count as present. return v === undefined || v === null || (typeof v === 'string' && v.trim() === ''); }); var result = { ok: missing.length === 0, missing: missing }; if (!result.ok && opts.throwOnMissing) { throw new Error((opts.label ? opts.label + ': ' : '') + 'missing ' + missing.join(', ')); } return result; } // var check = assertRequiredKeys(row, ['Email', 'Amount']); // { ok: false, missing: ['Amount'] }

Set Dropdown From List

function setDropdownFromList(targetRange, source, opts) { opts = opts || {}; var list = source; if (source && typeof source.getValues === 'function') { // A Range: flatten, trim, drop blanks and duplicates (first one wins) var seen = {}; list = []; source.getValues().forEach(function (row) { row.forEach(function (v) { var s = String(v == null ? '' : v).trim(); if (s && !seen[s]) { seen[s] = true; list.push(s); } }); }); } if (!Array.isArray(list) || !list.length) throw new Error('setDropdownFromList: no values to use'); var rule = SpreadsheetApp.newDataValidation() .requireValueInList(list.map(String), opts.showDropdown !== false) .setAllowInvalid(opts.allowInvalid === true) // default: reject values not in the list .build(); targetRange.setDataValidation(rule); return list.length; } // setDropdownFromList(sheet.getRange('E2:E'), ['Pending', 'Approved', 'Rejected']);

Script Write Guard

var SCRIPT_WRITE_KEY_ = 'scriptWriting'; function writeGuardCache_() { // Document cache for bound scripts; script cache for standalone return CacheService.getDocumentCache() || CacheService.getScriptCache(); } function beginScriptWrite(ttlSeconds) { // Short TTL: if the job dies before endScriptWrite, the flag expires on its own writeGuardCache_().put(SCRIPT_WRITE_KEY_, '1', Math.max(1, Math.min(ttlSeconds || 120, 21600))); } function endScriptWrite() { writeGuardCache_().remove(SCRIPT_WRITE_KEY_); } function isScriptWriting() { return writeGuardCache_().get(SCRIPT_WRITE_KEY_) === '1'; } // beginScriptWrite(180); try { /* batch writes */ } finally { endScriptWrite(); } // function onEditInstalled(e) { if (isScriptWriting()) return; /* ... */ }