Advertisement
Guest User

Untitled

a guest
Apr 28th, 2016
51
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.29 KB | None | 0 0
  1. function getKey() {
  2. var filename = Utilities.formatDate(new Date(), 'GMT', 'yyyy-MM-dd');
  3. var files = DriveApp.getFilesByName(filename);
  4. if (files.hasNext()) {
  5. var ssId = SpreadsheetApp.open(files.next()).getId();
  6. SpreadsheetApp.getActiveSheet().getRange('A1').setValue(ssId);
  7. }
  8. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement