function syncWithPublicSheet() var public = SpreadsheetApp.openById("PUBLIC_SHEET_ID"); var private = SpreadsheetApp.openById("PRIVATE_SHEET_ID"); var publicData = public.getSheetByName("Arcs").getDataRange().getValues(); private.getSheetByName("Arcs").clear(); private.getSheetByName("Arcs").getRange(1,1,publicData.length,publicData[0].length).setValues(publicData);
Check the in the sheet for revision tags (v2, v3). One Pace Spreadsheet BETTER