I'm really new to google sheets app script. I need an script which finds a date in row 1, selects the entire row and copy and paste values only. This is because I have formulas in each column which will only work if row 1 matches =today().
To get the range values and save into a variable (copy):
var book = SpreadsheetApp.openByUrl(url); //url=spread sheet url var sheet = book.getSheetByName("sheet name"); var range = sheet.getRange(a, b, x, y).getValues(); //a=inicial row ,b=inicial column, x=last row, y=last column // range will be a bidimensional array // "A1" cell value will be: range
To append in new cells (paste): //you have to iterate the array