CODEWITHSUNDEEP
google-apps-scriptsubdirectory
Jean
Jean

Reputation: 83

google app script : how to change folder destination

I am using the script below to export a google spreadsheet to CSV (thank you ziganotschka). I am trying to save the CSV in another folder than the same as my Spreadsheet. I have a folder containing my spreadsheet and inside a subfolder ("Final_Export) where I would like the CSV to save in.

The app script I use is : 

function saveAsCSV() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var ssname = ss.getName();
var sheet = ss.getActiveSheet(); 
var folder = DriveApp.getFileById(ss.getId()).getParents().next();
var fileName = ssname + ".csv";
var url = "https://docs.google.com/spreadsheets/d/" + ss.getId() + "/export? 
exportFormat=csv&format=csv";  
var token = ScriptApp.getOAuthToken();  
var response = UrlFetchApp.fetch(url + sheet.getSheetId(), {
headers: {
  'Authorization': 'Bearer ' +  token
}
});
folder.createFile(response.getBlob().setName(fileName));
}

Thank you for your help

Upvotes: 0

Views: 1319

Answers (1)

Jean
Jean

Reputation: 83

Finally, I found the solution. I had this code : 

  var parentFolder = DriveApp.getFolderById("myFolderDestinationId");
  var folder = parentFolder;

Upvotes: 1

Related Questions