INNER CODE UNIT · TypeScript

getUnprocessedInputRows

google-marketing-solutions/feedgen · src/app.ts:160

export function getUnprocessedInputRows(filterProcessed = true) {
  refreshConfigSheet();
  const inputSheet = SpreadsheetApp.getActive().getSheetByName(
    CONFIG.sheets.input.name
  );
  const generatedSheet = SpreadsheetApp.getActive().getSheetByName(
    CONFIG.sheets.generated.name
  );
  let inputRows = SheetsService.getInstance().getNonEmptyRows(inputSheet!);

  // Add a 'target ouput row' index value to each input row, except header row
  inputRows.forEach((row, index) => {
    if (index > 0) {
      row.push(CONFIG.sheets.generated.startRow + index);
    }
  });

  const generatedRowIds = SheetsService.getInstance()

View source record →