LANG SELRCT

Apps Script Reference  (Create: Create new Spreadsheet | Create new Apps Script

Tuesday, June 5, 2018

Googleドライブの指定したフォルダ内のフォルダの一覧をシートに書き出す


「書き出すスプレッドシートのURL」と「対象のフォルダID」を指定して
Googleドライブのフォルダ内のフォルダ一覧を書き出すコードを書きました。



コード.gs
var SS_URL = "書き出すスプレッドシートのURL";
var FOLDER_ID = "対象のフォルダID";

function get_file_info_to_sheet() {
  var names= [];
  var ids = [];
  var createds = [];
  var folder = DriveApp.getFolderById(FOLDER_ID);
  var folders = folder.getFolders();
  while(folders.hasNext()) {
    var folder_i = folders.next();
    var name = folder_i.getName();
    var id = folder_i.getId();
    var created = folder_i.getDateCreated();
    createds.push(created);
    names.push(name);
    ids.push(id);
  }
  var ss = SpreadsheetApp.openByUrl(SS_URL);
  var sh = ss.getSheets()[0];
  var row = sh.getLastRow() + 1;
  var view_path = "https://drive.google.com/drive/folders/";
  for(var i = 0; i < ids.length; i++){
    sh.getRange(row, 1).setValue(names[i]);
    sh.getRange(row, 2).setValue(ids[i]);
    sh.getRange(row, 3).setValue(view_path + ids[i]);
    sh.getRange(row, 4).setValue(createds[i]);
    row++;
  }
}


参考

getFolders
https://developers.google.com/apps-script/reference/drive/drive-app#getFolders()


Latest post

Extracting data from Google Sheets with regular expressions

Introduction Regular expressions are a powerful tool that can be used to extract data from text.  In Google Sheets, regular expressions ca...