Google Spreedsheet Scripts code

googlescripts.js

function doGet(e) {
//grab the id passed in of the google ss that I want to duplicate
var id = e.parameter.id;
var name = e.parameter.name;

//get the spreadsheet we want to duplicate and create a new sheet
var duplicateSS = SpreadsheetApp.openById(id);

//copy in the template to the new sheet and name it
var newSheet = duplicateSS.copy(name).getId();

//push the changes we committed above.
SpreadsheetApp.flush();

//get the url of the ss
var returnURL = SpreadsheetApp.openById(newSheet).getUrl();

//if we want to limit people by email and goole account requirements
//SpreadsheetApp.openById(newSheet).addEditor("[email protected]");

//if we want anyone to view with the link
DriveApp.getFileById(newSheet).setSharing(DriveApp.Access.ANYONE_WITH_LINK, DriveApp.Permission.EDIT);

return ContentService.createTextOutput(returnURL);
}