AdWords Scripts Bulks Up With Bulk File Uploads

// name: The name of the folder to find or create
// folder: The parent folder. Pass null to look in the root folder
function findOrCreateFolder(name,folder) {
  if(!folder) { folder = DriveApp.getRootFolder(); }
  var fileIter = folder.getFoldersByName(name);
  if(fileIter.hasNext()) {
    return fileIter.next();
  } else {
    return folder.createFolder(name);
  }
}

// This is the name of the folder to hold the account data
var ROOT_FOLDER_NAME = 'AdWords Management';
// This folder will hold the bulk uploads we have already processed
var PROCESSED_FOLDER_NAME = 'Processed';
// This folder will hold the bulk uploads we need to process
var TO_PROCESS_FOLDER_NAME = 'To Process';

function main() {
  var accountIter = MccApp.accounts().get();
  var successfulUploads = [];
  while(accountIter.hasNext()) {
    var account = accountIter.next();
    MccApp.select(account);
    
    var rootFolder = findOrCreateFolder(ROOT_FOLDER_NAME,null);
    // The folder name for each account will be in the format  
    var accountFolderName = AdWordsApp.currentAccount().getCustomerId() + 
                      ' ' + AdWordsApp.currentAccount().getName();
    
    // This will create the folder structure we need
    var accountFolder = findOrCreateFolder(accountFolderName,rootFolder);
    var toProcessFolder = findOrCreateFolder(TO_PROCESS_FOLDER_NAME,accountFolder);
    var processedFolder = findOrCreateFolder(PROCESSED_FOLDER_NAME,accountFolder);
    
    // Now we look in the "To Process" folder for any new CSV files
    var filesToProcessIter = toProcessFolder.getFilesByType(MimeType.CSV);
    while(filesToProcessIter.hasNext()) {
      var file = filesToProcessIter.next();
      // Change the following line to use .apply() instead of .preview()
      // once you are satisfied things are working correctly. When using .preview(),
      // you will need to log into your account to apply the change.
      AdWordsApp.bulkUploads().newFileUpload(file).preview();
      // To move a file, we add it to the new folder and remove it from the old one
      processedFolder.addFile(file);
      toProcessFolder.removeFile(file);
      // We record some information here to help us with a notification email.
      successfulUploads.push({customerId:AdWordsApp.currentAccount().getCustomerId(),
                              accountName:AdWordsApp.currentAccount().getName(),
                              filename:file.getName()});
    }
  }
  // Send the notification email
  notifySuccessfulUploads(successfulUploads);
}

// These can go at the top of the script with the other global variables
var SCRIPT_NAME = 'Bulk Uploader';
var TIMEZONE = 'PST';
var TODAY_STR = Utilities.formatDate(new Date(), TIMEZONE, 'yyyy-MM-dd');
var NOTIFY = ['[email protected]'];

// successfulUploads should be an array of objects containing
// [{customerId:'',accountName:'',filename:''},...]
function notifySuccessfulUploads(successfulUploads) {
  if(!successfulUploads || successfulUploads.length == 0) { return; }
  if(typeof NOTIFY == 'undefined') { throw 'NOTIFY is not defined.'; }
  var subject = SCRIPT_NAME+' - Successful Uploads - '+TODAY_STR;
   
  var htmlBody = 'The following files were uploaded to your accounts.<br / >';
  htmlBody += 'Log in to AdWords: https://goo.gl/7mS6A';
  var body = htmlBody;
  htmlBody += '<br / ><br / >';
  htmlBody += '<table border="1" width="95%" style="border-collapse:collapse;">' +
              '<tr><td>Account Id</td><td>Account Name</td><td>Filename</td></tr>';
  for(var i in successfulUploads) {
    htmlBody += '<tr><td>'+ successfulUploads[i].customerId +
      '</td><td>' + successfulUploads[i].accountName +
      '</td><td>' + successfulUploads[i].filename + '</td></tr>';
  }
  htmlBody += '</table>';
  var options = { htmlBody : htmlBody };
  for(var i in NOTIFY) {
    Logger.log('Sending email to: '+NOTIFY[i]+' with subject: '+subject);
    MailApp.sendEmail(NOTIFY[i], subject, body, options);
  }
}