Google Apps Script: Create New Document (Spreadsheet) from Template

Question

I'm currently doing this:

//set active spreadsheet to my template
      var ss = SpreadsheetApp.openById("MYSHEETKEY");
      SpreadsheetApp.setActiveSpreadsheet(ss);


//duplicate active sheet and set a new name
       SpreadsheetApp.getActiveSpreadsheet().duplicateActiveSheet().setName(rData[0][1]);

which is creating a new sheet in my template Spreadsheet, quite rightly. What I really need is to create an entirely new copy of the document as a whole, ideally in to a specified folder in my Google Drive. Is this possible?

Thanks as advance!

Spencer Easton · Accepted Answer · 2015-05-21 12:46:35Z

4

There is a copy() function. The docs are at: https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet#copy(String)

var ss = SpreadsheetApp.openById("MYSHEETKEY");
var newSS = ss.copy("Copy of " + ss.getName());
// Move to original folder
var originalFolder = DriveApp.getFileById("MYSHEETKEY").getParents().next();
var newSSFile = DriveApp.getFileById(newSS.getId());
originalFolder.addFile(newSSFile);
DriveApp.getRootFolder().removeFile(newSSFile);

edited May 21, 2015 at 12:46

answered May 21, 2015 at 12:35

Spencer Easton

5,8021 gold badge18 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

James Over a year ago

Thanks very much for your advice. Works great, although I had to remove getParents() and next() .... can you please explain to me the purpose of these?

Spencer Easton Over a year ago

.getParents() returns the list of folders this file is in and next() gets the first folder. This code is assuming that the spreadsheet is only in one folder.

Spencer Easton Over a year ago

And you shouldn't have to remove those. The code above works.

James Over a year ago

Apologies, I confused myself for a moment there, I was indeed struggling to make the code work (I assume my own incompetence!) but in the end I tweaked that line to var targetFolder = DriveApp.getFolderById("MYFOLDERID"); - and then I removed the getParents & next(). Thanks again

Collectives™ on Stack Overflow

Google Apps Script: Create New Document (Spreadsheet) from Template

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related