Alexander Ivanov

if (continuationToken == null) {
  var files = DriveApp.getFiles();
} else {
  var files = DriveApp.continueFileIterator(continuationToken);
}
где continuationToken заранее получен и извлечен из внешнего хранилища.

if(files.hasNext()){
  var continuationToken = files.getContinuationToken();

var lock = LockService.getPublicLock();
try {
  lock.waitLock(30000);
  return success();
} catch (err) {
  Logger.log('Could not obtain lock after 30 seconds.');
  return failure();
}

var lock = LockService.getPublicLock();
var success = lock.tryLock(30000);
if (!success) {
  Logger.log('Could not obtain lock after 30 seconds.');
}

function myF(){
  var data = get_();
  Logger.log(data);
  append_(data);
}

function get_(){
  var sheet = SpreadsheetApp.openById("986327f36403948feb4a")
    .getSheetByName("Sheet1");
  return sheet.getDataRange().getValues().slice(sheet.getFrozenRows());
}

function append_(data){
  var d = new Date();
  var values = data.map(function(row){
    row.unshift(this.d);
    return row;
  }, {d:d});
  var sheet = SpreadsheetApp.openById("579e832d1ced2a2cc76c")
    .getSheetByName("Sheet2");
  sheet.getRange(sheet.getLastRow() + 1, 1, values.length, values[0].length).setValues(values);
}

=QUERY('Данные'!A:K;"select D, E, F, H, I where C='Белградская'")

=QUERY(K:U;"select N, O, P, R, Q where M='Белградская'")

=FILTER({'Данные'!D2:F\'Данные'!H2:I};'Данные'!C2:C="Белградская")

JSON.stringify(form['checkbox_name[]'], null, '  ')

=FILTER('данные'!A1:E14;MMULT(('данные'!A1:A14=TRANSPOSE('данные'!A1:A14))*('данные'!B1:B14>TRANSPOSE('данные'!B1:B14));SIGN(ROW('данные'!B1:B14)))=0)

/**
 * @param {globalThis.SpreadsheetApp.Range} cell
 * @param {string} imageUrl
 * @param {string} altTitle
 * @param {string} altDescription
 * @returns {void}
 */
function insertCellImage(cell, imageUrl, altTitle = '', altDescription = '') {
  const image = SpreadsheetApp.newCellImage()
    .setSourceUrl(imageUrl)
    .setAltTextTitle(altTitle)
    .setAltTextDescription(altDescription)
    .build();
  cell.setValue(image);
}