var file = folder.createFile(blob);

function uploadFile() {
  var image = UrlFetchApp.fetch('http://goo.gl/nd7zjB').getBlob();
  var file = {
    title: 'google_logo.png',
    mimeType: 'image/png'
  };
  file = Drive.Files.insert(file, image);
  Logger.log('ID: %s, File size (bytes): %s', file.id, file.fileSize);
}

//Get root folder and pull all existing folders, plus setup variables pulled from form
    var dropbox = form.Country;
    var filename = form.reportType+".xls";
    var rootfolder = DriveApp.getFolderById("0Byvtwn42HsoxfnVoSjB2NWprYnRiQ2VWUDZEendNOWwwM1FOZk1EVnJOU3BxQXhwU0pDSE0");
    //Note root folder is Live Uploads Folder in Flatworld App folder structure
    var folder, folders = rootfolder.getFoldersByName(dropbox);

    //Check if folder exists and if not create
    if (folders.hasNext()) {
      folder = folders.next();
    } else {
      folder = rootfolder.createFolder(dropbox);
    }

    //Check if file already exists and delete if it does
    var file, files = folder.getFilesByName(filename);
    while( files.hasNext()){
      file = files.next();
      file.setTrashed(true);
    }


    //Upload file and set various properties
    var blob = form.myFile;
    var file = folder.createFile(blob);
    var timeStamp = new Date();
    file.setDescription("Uploaded via BNI Upload Form by " + form.myName + " on: " + timeStamp);

    //Set file name slightly differently for Weekly Member Report (do not want to overright based on name just keep each extract so add timestamp to name)
    if (form.reportType == "Member Weekly"){
    file.setName(form.reportType + timeStamp + ".xls");
    }
  else
  {
    file.setName(filename);
  }

//Upload file and set various properties
var mediaData = form.myFile;
var timeStamp = new Date();

var resource = {
  title: (form.reportType == "Member Weekly") ? form.reportType + timeStamp + ".xls" : filename,
  mimetype: 'application/vnd.ms-excel',
  description: "Uploaded via BNI Upload Form by " + form.myName + " on: " + timeStamp
};

var file = Drive.Files.insert(resource, mediaData);
var fileId = file.id;
var DriveAppFile = DriveApp.getFileById(fileId);

DriveApp.removeFile(DriveAppFile);
folder.addFile(DriveAppFile);