Skip to content

Instantly share code, notes, and snippets.

@ideiudicibus
Last active April 5, 2016 12:20
Show Gist options
  • Save ideiudicibus/eabaa8d7baef2c828758 to your computer and use it in GitHub Desktop.
Save ideiudicibus/eabaa8d7baef2c828758 to your computer and use it in GitHub Desktop.
google apps script GAS clone a spreadsheet
//in client try to use hello js https://adodson.com/hello.js/
function doGet(e) {
//parameters
var fileId = e.parameters.fileId;
var fileName=e.parameters.name;
var editor=e.parameters.editor;
//clone the file
var f= DriveApp.getFileById(fileId).makeCopy(fileName);
f.setSharing(DriveApp.Access.ANYONE, DriveApp.Permission.VIEW);
f.addEditor(editor);
//prepare the return JSON object to be consumed by a REST-a-like-service
var returnObj={};
returnObj.url=f.getUrl();
returnObj.id=f.getId();
returnObj.createdDate=f.getDateCreated();
return ContentService.createTextOutput(JSON.stringify(returnObj))
.setMimeType(ContentService.MimeType.JSON);
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment