Skip to content

Instantly share code, notes, and snippets.

@pastcompute
Created April 6, 2016 02:26
Show Gist options
  • Save pastcompute/f5c6ff73d483bb7e7b44b90af9ef6563 to your computer and use it in GitHub Desktop.
Save pastcompute/f5c6ff73d483bb7e7b44b90af9ef6563 to your computer and use it in GitHub Desktop.
Google sheets script get list of files in gdrive
function listFilesInFolder(id) {
var folder = DriveApp.getFolderById('MyFolderID');
var contents = folder.getFiles();
var file;
var name;
var sheet = SpreadsheetApp.getActiveSheet();
var date;
var size;
sheet.clear();
sheet.appendRow(["Nome", "Data", "Dimensione"]);
while(contents.hasNext()) {
file = contents.next();
name = file.getName();
date = file.getDateCreated()
size = file.getSize()
data = [name, date, size]
sheet.appendRow(data);
}
};
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment