Tutorial by Examples

Getting a reference to a named sheet tab var spread_sheet = SpreadsheetApp.getActiveSpreadsheet();//Get active spreadsheet var sheet_with_name_a = spread_sheet.getSheetByName("sheet_tab_name"); Getting active sheet tab var spread_sheet = SpreadsheetApp.getActiveSpreadsheet(); var ac...

Imagine that we have a separate Google spreadsheet, and we need to get the B2 cell value to cell D5 on your current sheet. function copyValueandPaste() { var source = SpreadsheetApp.openById('spread sheet id is here'); //Separate spreadsheet book var sourcesheet = source.getSheetByName...

function lastRowForColumn(sheet, column){ // Get the last row with data for the whole sheet. var numRows = sheet.getLastRow(); // Get all data for the given column var data = sheet.getRange(1, column, numRows).getValues(); // Iterate backwards and find first non empty cell ...

Inserting a row at the bottom of a spreadsheet is easy: var someSheet = SpreadsheetApp.getActiveSpreadsheet().getSheets()[0]; someSheet.appendRow(["Frodo", "Baggins", "Hobbit", "The Shire", 33]); Note this will add the row after the last non-empty row. I...