title: How can I make my script save the copy to a specific folder?
body: <p>I am using the below script to make a copy of my google worksheet (values and formatting only).  However, this script is placing the new file in my main google drive and I want the file to be saved to an archive folder.  How can I edit my script to do this?</p>
  
  <pre><code>function copySheetValuesV4(){
      var sourceSpreadsheet = SpreadsheetApp.getActiveSpreadsheet();
      var sourceSheets = sourceSpreadsheet.getSheets();
      var destination = SpreadsheetApp.create('03_'+sourceSpreadsheet.getName()+' _December 2017');
      for (var i = 0; i &lt; sourceSheets.length; i++){
          var sourceSheet = sourceSheets[i];
          if (!sourceSheet.isSheetHidden()) {
              var sourceSheetName = sourceSheet.getSheetName();
              var sValues = sourceSheet.getDataRange().getValues();
              sourceSheet.copyTo(destination)
              var destinationSheet = destination.getSheetByName('Copy of '+sourceSheetName).setName(sourceSheetName);
  
              destinationSheet.getRange(1,1,sValues.length,sValues[0].length).setValues(sValues);// overwrite all formulas that the copyTo preserved */
  
          }
          destination.getSheetByName("sheet1").hideSheet() // Remove the default "sheet1" */
      }
  }
  </code></pre>