Get or Create a Drive Folder by Name

Exports, backups, and client drop folders all need a stable place in Drive. This returns the first child folder with that name under a parent, or creates it.

What you'll need

  • A parent Folder (DriveApp.getRootFolder(), or a known folder ID)
  • Drive create/read permission for that parent

How to use this snippet

function getOrCreateFolder(parent, name) { var folders = parent.getFoldersByName(name); if (folders.hasNext()) { return folders.next(); } return parent.createFolder(name); } function ensureExportFolder() { var root = DriveApp.getFolderById('YOUR_PARENT_FOLDER_ID'); var year = Utilities.formatDate(new Date(), Session.getScriptTimeZone(), 'yyyy'); return getOrCreateFolder(root, 'Exports-' + year); }

Tips:

  • If multiple folders share the name, this returns the first — keep names unique under a parent.
  • Prefer folder IDs in production scripts so renames don't break paths.

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:

Get or Create a Nested Drive Folder Path

function getOrCreateFolderPath(parent, path) { if (!parent) throw new Error('getOrCreateFolderPath: parent folder required'); var parts = String(path || '') .split(/[/\\]+/) .map(function (p) { return p.trim(); }) .filter(Boolean); var folder = parent; for (var i = 0; i < parts.length; i++) { var name = parts[i]; var kids = folder.getFoldersByName(name); folder = kids.hasNext() ? kids.next() : folder.createFolder(name); } return folder; } // getOrCreateFolderPath(DriveApp.getFolderById(ID), 'Exports/2026/09');

Build a Header → Column Index Map

function buildHeaderMap(sheet, headerRow) { headerRow = headerRow || 1; var lastCol = sheet.getLastColumn(); if (lastCol < 1) return {}; var headers = sheet.getRange(headerRow, 1, 1, lastCol).getValues()[0]; var map = {}; for (var i = 0; i < headers.length; i++) { var name = String(headers[i] == null ? '' : headers[i]).trim(); if (!name) continue; if (map.hasOwnProperty(name)) { throw new Error('buildHeaderMap: duplicate header "' + name + '"'); } map[name] = i + 1; // 1-based column index for getRange } return map; } // var cols = buildHeaderMap(sheet); sheet.getRange(2, cols.email).getValue();