title: Is there a way to save a google spreadsheet as a blob in a database and then, during apps script, open that blob as a spreadsheet
body: <p>I have a very complex Google spreadsheet that I am using as a template to create another spreadsheet. The sheets have formatting, named ranges, data validation, formulas, data, permissions, etc. The code will select certain sheets within the template spreadsheet and copy them to the new spreadsheet.
  Example of code that does this:</p>
  
  <pre><code>var s = "complexity";
  var srcsheet = ss_src.getSheetByName(s);
  var newsheet = srcsheet.copyTo(ss).setName(s).hideSheet();
  rebuildNamedRange(ss,newsheet);
  var rule = ss_src.getSheetByName(s).getRange("C2").getDataValidation();
  newsheet.getRange("C2:C99").clearDataValidations();
  newsheet.getRange("C2:C99").setDataValidation(rule);
  copySheetProtections(srcsheet,newsheet);
  </code></pre>
  
  <p>The issue is that the "copyTo" functions require that the user has edit privileges to the spreadsheet.  Obviously that is not ideal.</p>
  
  <p>Is there a way to save a google spreadsheet as a blob in a database and then, during apps script, open that blob as a spreadsheet?
  I've tried the following to no avail.</p>
  
  <p>Test#1</p>
  
  <pre><code>function getBlob() {
    var doc = SpreadsheetApp.openById(SRC);
    var docContentBlob = doc.getBlob();
    copyBlobSheet(docContentBlob);
  }
  function copyBlobSheet(blob) {
    var dst = SpreadsheetApp.openById(DST);
    blob.setContentType('application/vnd.google-apps.spreadsheet'); // tried with and without this
    var newDocfromBlob = DriveApp.createFile(blob).setName("doc from blob");
    var src = SpreadsheetApp.open(newDocfromBlob); // this fails
    src.getSheetByName("one").copyTo(dst).setName("copy of one success");
  }
  </code></pre>
  
  <p>Test#2</p>
  
  <pre><code>function getBlob() {
    var doc = SpreadsheetApp.openById(SRC);
    var docContentBlob = doc.getBlob();
    copyBlobSheet(docContentBlob);
  }
  function copyBlobSheet(blob) {
    var dst = SpreadsheetApp.openById(DST);
    blob.setContentType('application/vnd.google-apps.spreadsheet'); // tried with and without this
    var file = {
      title: 'advanced_test',
      mimeType: 'application/vnd.google-apps.spreadsheet'
    };
    newFile = Drive.Files.insert(file, blob); // this fails with "invalid mime type"
  }
  </code></pre>
  
  <p>Any thoughts on this capability or a work-around would be greatly appreciated!</p>