Hello everyone,

I have a spreadsheet that runs a script pulling in a Google Drive folder list. In the same sheet but into separate columns I'm manually adding relevant information for various rows which gets me to my questions:

(1) Can I get my Google Drive folder list script to pull in the folders in alphabetical order? (I'm right now sorting it via another script)

Script that pulls in my folder structure:

// Get Folder Tree function getFolderTree(folderId, listAll) { try { // Get folder by id var parentFolder = DriveApp.getFolderById(folderId);

// Initialise the sheet var file, data, sheet = SpreadsheetApp.getActiveSheet().getSheetByName('raw-data'); sheet.appendRow(["Full Path", "Name", "Date", "URL", "Last Updated", "Description", "Size"]);

// Get files and folders getChildFolders(parentFolder.getName(), parentFolder, data, sheet, listAll);

} catch (e) { Logger.log(e.toString()); } };

(2) How can the script that pulls in a Google drive folder list add new folders by inserting them between rows instead of appending them at the end? I want to make sure that my notes from the additional columns doesn't get mixed up with wrong rows once the folder structure is updated.

Any & all help is much appreciated!