Alexander Ivanov

=QUERY({DB!A13:L1155};"
SELECT Col1, Col2, Col3

WHERE
( Col1 >= date'2015-10-22'
AND Col1 <= date'2015-10-25')
AND ( Col2 = 'Campaign_1'
OR Col2 = 'Campaign_2')

ORDER BY Col7 DESC")

потом осуществлять последующую обработку

1. Лист/Листы для приема ответов Формы/Форм
   
2. Лист/Листы для ввода данных вручную
   
3. Лист/Листы для промежуточной обработки данных с консолидацией или без
   
4. Лист/Листы для отображения обработанных данных с консолидацией или без
   

function onEdit() {
   run2();
}

function run2() {
  /* Remove dash */
  var sheet = SpreadsheetApp.getActiveSheet();
  if (sheet.getName() === 'Журнал вода данных') return;
  var archive = SpreadsheetApp.getActive().getSheetByName('Журнал вода данных');

  var action = function(values, i, i2) {
    var data = values.slice(i, i + i2);
    archive
      .getRange(archive.getLastRow() + 1, 1, data.length, data[0].length)
      .setValues(data);
  };

  var condition = function(values, i) {
    var row = values[i];
    return (
      i > 0 && row[0] !== '' && row[1] !== '' && row[3] !== '' && row[5] !== ''
    );
  };

  deleteRowsByConditional_(sheet, condition, action);
}

function deleteRowsByConditional_(sheet, condition, action) {
  sheet
    .getDataRange()
    .getValues()
    .forEach(
      function(_, i, arr) {
        var j = arr.length - i - 1;
        if (this.condition.apply(null, [arr, j])) {
          this.isContinue++;
          if (j > 0) return;
        }
        if (this.isContinue > 0) {
          var prevPos = j + 1; // It's reversed
          if (action) action(arr, prevPos, this.isContinue);
          this.sheet.deleteRows(prevPos + 1, this.isContinue);
          this.isContinue = 0;
          return;
        }
        return;
      },
      { sheet: sheet, condition: condition, isContinue: 0 }
    );
}

MailApp.sendEmail({
  ...
  body: 'https://drive...',
  ...
});

var file = DriveApp.getFilesByName('test123.pdf');
if (file.hasNext()) {
    MailApp.sendEmail(emailAddress, subject, message, {
    attachments: [file.next().getAs(MimeType.PDF)],
    name: 'Automatic Emailer Script'
}

function sendEmail() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var activeRange = sheet.getActiveRange();
  var data = sheet
    .getRange(
      activeRange.getRow(),
      1,
      activeRange.getLastRow() - activeRange.getRow() + 1,
      6
    )
    .getValues();

  data.forEach(function(row) {
    var file = DriveApp.getFilesByName(row[5]);
    if (file.hasNext()) {
      var namesender = row[0];
      var emailAddress = row[1];
      var hiddencopy = row[2];
      var subject = row[3];
      var message = row[5];
      var information = row[4];
      var emailQuotaRemaining = MailApp.getRemainingDailyQuota();
      Logger.log('Remaining email quota: ' + emailQuotaRemaining);

      MailApp.sendEmail({
        to: emailAddress,
        bcc: hiddencopy,
        replyTo: 'supportmp@test.ru',
        name: namesender,
        subject: subject + ' ' + information,
        htmlBody: message + ' ' + https,
        attachments: [file.next().getAs(MimeType.PDF)],
      });
    } else {
      Logger.log('Файл для отправки не найден');
    }
  });
}

Unlike most other types of Apps Scripts, custom functions never ask users to authorize access to personal data. Consequently, they can only call services that do not have access to personal data, specifically the following:

Supported services	Notes
Cache	Works, but not particularly useful in custom functions
HTML	Can generate HTML, but cannot display it (rarely useful)
JDBC
Language
Lock	Works, but not particularly useful in custom functions
Maps	Can calculate directions, but not display maps
Properties
Spreadsheet	Read only (can use most get*() methods, but not set*()). Cannot open other spreadsheets (SpreadsheetApp.openById() or SpreadsheetApp.openByUrl()).
URL Fetch
Utilities
XML