List Drive Folder Contents

Instructions

• Open the Google Apps Script editor in your Google Sheet.

• Change the folderId to the ID of your Drive folder.

• Change the sheetTabName, if needed.

• Run the script – you may need to authorize the first time around!

• You can add a scheduled trigger to keep this running regularly – or add onOpen() to run it every time you open the file.

/**@OnlyCurrentDoc*/

function listFolderContents() {

  //***edit the lines below to change your data import***//

  var folderId = 'DRIVE_FOLDER_ID';

  var sheetTabName = 'Drive File List'

  //***do not edit below!!***//

  var folder = DriveApp.getFolderById(folderId)

  var contents = folder.getFiles();

  var ss = SpreadsheetApp.getActive();

  var sheet = ss.getSheetByName(sheetTabName);

  var fileListArray = [];

  fileListArray.push(['Name', 'Link']);

  var file;

  var name;

  var link;

  var row;

  while(contents.hasNext()) {

    file = contents.next();

    name = file.getName();

    link = file.getUrl();

    fileListArray.push([name, link]);

  }

  sheet.getRange('A:B').clearContent();

  sheet.getRange(1,1,fileListArray.length,fileListArray[0].length).setValues(fileListArray);

};