Skip to content

Instantly share code, notes, and snippets.

@skabbes

skabbes/backup.gs

Created December 28, 2018 19:26
Show Gist options
  • Save skabbes/9b2f8a4d8022d2b4784a6ecd0491d013 to your computer and use it in GitHub Desktop.
Save skabbes/9b2f8a4d8022d2b4784a6ecd0491d013 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
backup.gs
// https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet
var ss = SpreadsheetApp.openById("yourSpreadSheetIdHere");
var dataSheet = ss.getSheetByName("data sheet name");
var historySheet = ss.getSheetByName("Historical");
var cell = dataSheet.getRange("A1");
historySheet.appendRow(["a man", "a plan", "panama"]);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment