sheet Append Files. Listing folders - 3 https://m.cafe.naver.com/eojji/303

sheet Append Files.gs

// https://m.cafe.naver.com/eojji/303
function sheetAppendFiles_(parentId, data, sheetFolder, sheetFiles) {
  if (!data || data.length < 1) {
    return;
  }
  
  var folderData = [];
  var newDate = new Date();
  // title, id
  // id2, files, fileSize, start, end, file row, parent																	
  var newFolderContents = ['', 0, 0, newDate, newDate, 0, parentId];
  
  var fileData = [];
  // copy, name, message, check, parent
  var newFileContents = ['', '', '', '', parentId];
  
  var len = data.length;
  for (var i = 0; i < len; i++) {
    // title, id, mimeType, fileSize
    var mimeType = data[i][2]; // mimeType
    if (mimeType == 'application/vnd.google-apps.folder') {
      folderData.push(data[i].slice(0, 2).concat(newFolderContents));
    } else {
      fileData.push(data[i].concat(newFileContents));
    }
  }
  
  if (folderData && folderData.length > 0) {
    sheetFolder.getRange(sheetFolder.getLastRow() + 1, 1, folderData.length, folderData[0].length).setValues(folderData);
  }
  
  if (fileData && fileData.length > 0) {
    sheetFiles.getRange(sheetFiles.getLastRow() + 1, 1, fileData.length, fileData[0].length).setValues(fileData);
  }
}

function myFunction() {
  var startTime = Date.now();
  var ssNew = SpreadsheetApp.create('_gfolder, '+startTime);
  var sheetFolder = ssNew.getSheets()[0];   
  sheetFolder.setName('folder');
  sheetFolder.appendRow(["row to read", 0]);
  
  sheetFolder.appendRow(["title", "id", "id2", "files", "fileSize", "start", "end", "file row", "parent"]);
  
  // files    
  var  sheetFiles = ssNew.insertSheet('files');
  sheetFiles.appendRow(["row to read", 0, "page token"]);
  sheetFiles.appendRow(['title', 'id', 'mime', 'size', 'copy', 'name', 'message', 'check', 'parent']);
  
  var folderId = '0B_MA3GXgQ1ulZzVxWnE2RHhvX2M';
  var pageToken;
  
  var objFiles = listFilesByPageToken_(folderId, pageToken, startTime);       
  if (objFiles) {
    var parentId = '???? 1kkW35FafQbJFRvbp4'; // test folder id
    sheetAppendFiles_(parentId, objFiles.files, sheetFolder, sheetFiles);
  }
}

https://m.cafe.naver.com/eojji/303