1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
| function add() {
var templateSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Template');
var sourceRange = templateSheet.getRange('A1:C4');
var clientsSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Clients');
var numRows = sourceRange.getNumRows();
var numColumns = sourceRange.getNumColumns();
var lastRow = clientsSheet.getLastRow();
if (lastRow == 0) {
lastRow = 5;
}
var destRange = clientsSheet.getRange(lastRow + 2, 1, numRows, numColumns);
sourceRange.copyTo(destRange);
} |
