Google Sheets commonly used functions

googlesheets.gs

/**
 * Delete columns and rows
 */
function DeleteColumnsAndRows() {
  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = spreadsheet.getSheetByName("SHEET-NAME-HERE");
  //  sheet.getRange(1, 2, sheet.getMaxRows(), sheet.getMaxRows()).activate();

  // Delete column B to max
  if (sheet.getMaxColumns() > 1) {
    sheet.deleteColumns(2, sheet.getMaxColumns()-1);
  }
  // Delete row 2 to max
  if (sheet.getMaxRows() > 1) {
    sheet.deleteRows(2, sheet.getMaxRows()-1);
  }
};

// Get value from "Price" sheet, 'N2' cell
var cellValue = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Price").getRange('N2').getValue();
// Logger.log(cellValue);