CODEWITHSUNDEEP
google-apps-script
Puneet Kukreja
Puneet Kukreja

Reputation: 1

I am trying to download the Google drive contents to sheets not getting the last modified column

I am trying to download the Google drive contents to sheets not getting the last modified column.

function myFunction() { 
var foldername = 'Folder Name'; 
var folderlisting = 'listing of folder ' + foldername; 
var folders = DriveApp.getFoldersByName(foldername) 
var folder = folders.next(); 
var contents = folder.getFiles();
var contents = folder.getFiles(); 
var ss = SpreadsheetApp.create(folderlisting);
var sheet = ss.getActiveSheet(); sheet.appendRow(['name','link','Owner','Modified']); 
var file; 
var name; 
var link; 
var Owner; 
var Modified; 
var row; 
while(contents.hasNext()){ 
     file = contents.next();
     name = file.getName(); 
     link = file.getUrl();
     Owner = file.getOwner(); 
     Modified = file.getModified();
     sheet.appendRow([name, link,Owner,Modified]); 
} };

Upvotes: 0

Views: 25

Answers (1)

user11982798
user11982798

Reputation: 1908

I Think no method of getModified, please try with this

Modified = file.getLastUpdated();

Upvotes: 1

Related Questions