앱 사용자를 스프레드시트에서 찾습니다. https://blog.naver.com/gsuite-reseller/221484133849

findDomainFromSheet.js

function findDomainFromSheet(sheet, domain) {
  var lastRow = sheet.getLastRow();
  var startRow = 2;
  var rows = lastRow - startRow + 1;
  var values = sheet.getRange(startRow, 1, rows, 1).getValues();
  for(var i=0; i<rows; i++) {
    if (values[i][0] === domain) {
      var searchRow = startRow + i;
      // console.log('searchRow: %s', searchRow);
      var domainKey = domain + 'SheetRow';
      PropertiesService.getUserProperties().setProperty(domainKey, searchRow);
      return searchRow;
    }
  }
  return -1;
}