Bulk create test folders/files in Google Drive

The following Google Apps Script is designed to bulk create a set number of Google Drive folder/files as quickly as possible. Its purpose was to support a bigger project I was working on with bulk moving folders/files from My Drive to Shared Drive.

Screenshot of example folder structure in Google Drive

The script makes use of 4 'loops' with the option to define how many folders/files you want to create at each level. There is an initial top row of folders each with files, then a row of sub-folders under this each with files too.

Selecting to create 5 of each via the parameters would produce 175 items in total, within about 8 minutes.

	function createFoldersFiles() {
	// get spreadsheet
	var ss = SpreadsheetApp.getActive();
	var configSheet = ss.getSheetByName('Config');
	// get Drive Parent folder ID
	var parentFolderID = configSheet.getRange(1, 2).getValue();
	var parentFolder = DriveApp.getFolderById(parentFolderID);
	// get Google Doc Template file
	var templateDocID = configSheet.getRange(2, 2).getValue();
	var templateDoc = DriveApp.getFileById(templateDocID);
	// set parameters
	var folders = 2;
	var files = 2;
	var subFolders = 2;
	var subFiles = 2;
	// create folder(s)
	for (var p=0; p<folders; p++) {
	var newFolderName = 'Folder ' + (p+1);
	var newFolderId = parentFolder.createFolder(newFolderName).getId();
	var newFolder = DriveApp.getFolderById(newFolderId);
	ss.toast(newFolderName, 'Created Folder');
	// create file(s)
	for (var h=0; h<files; h++) {
	var newFileName = 'Folder ' + (p+1) + ' - File ' + (h+1);
	var newFile = templateDoc.makeCopy(newFileName, newFolder);
	ss.toast(newFileName, 'Created File');
	}
	// create sub-folder(s)
	for (var i=0; i<subFolders; i++) {
	var newSubFolderName = 'Folder ' + (p+1) +' - Sub Folder ' + (i+1);
	var newSubFolderId = newFolder.createFolder(newSubFolderName).getId();
	var newSubFolder = DriveApp.getFolderById(newSubFolderId);
	ss.toast(newSubFolderName, 'Created Sub-Folder');
	// create sub-file(s)
	for (var l=0; l<subFiles; l++) {
	var newSubFileName = 'Sub Folder ' + (i+1) +' - Sub File ' + (l+1)
	var newSubFile = templateDoc.makeCopy(newSubFileName, newSubFolder);
	ss.toast(newSubFileName, 'Created Sub-File');
	}
	}
	}
	}

view raw Bulk create test folders_files in Google Drive.gs hosted with ❤ by GitHub

Bulk create test folders/files in Google Drive