Function sheetArrayFunctions

ArrayFunctions.js:23–60

()

// Function the Arrays of Arrays pulled from a Google Sheet
function sheetArrayFunctions() {
  let sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Raw Data");
  let data = sheet.getDataRange().getValues(); // dynamically detects the data range and returns the value
  Logger.log(data);
  let header = data.shift(); // Shift Removed the first element from an Array and Returns it
  Logger.log(header);
  Logger.log(data);

  // Filter Function
  let fruitsOnly = data.filter(
    row => row[1] === "Fruit");
  Logger.log(fruitsOnly);

  // Map Function to each row
 let updatedData = fruitsOnly.map(row => {
   row[2] *= 1.10; // Increase price by 10%
   return row;
  });
  Logger.log(updatedData);

  // ForEach - Perform Operation on each row 
  updatedData.forEach(row => row[1] = "fruits");

  // Insert header row back at the start
  updatedData.unshift(header);

  let ss = SpreadsheetApp.getActiveSpreadsheet();
  let reportSheet = ss.getSheetByName("Fruit Report");
  if (!reportSheet) {
    reportSheet = ss.insertSheet("Fruit Report");
  }

  // Clear old data and write the new data
  reportSheet.clear();
  reportSheet.getRange(1, 1,  updatedData.length, updatedData[0].length).setValues(updatedData);

  Logger.log("Report generated successfully!");
}

/**
 * Sample of Data