Веб-хук для Гугл форм с записью данных в таблицу БД и отправкой email уведомления. Интеграция Гугл форм с MODX.

app.js

function onFormSubmit(e) {
  if( e ) {
    values = e.range.getValues();
    theNewRow = values[0];
    var response = UrlFetchApp.fetch('https://test.ru/assets/components/newsletters/googleform_hook.php?id=1&form=TestForm&data='+theNewRow, {'muteHttpExceptions': true});
    Logger.log(response);
  }
}

appsscript.json

{
  "timeZone": "Europe/Moscow",
  "dependencies": {
  },
  "exceptionLogging": "STACKDRIVER",
  "runtimeVersion": "V8",
  "oauthScopes": [
    "https://www.googleapis.com/auth/forms",
    "https://www.googleapis.com/auth/spreadsheets",
    "https://www.googleapis.com/auth/forms.currentonly",
    "https://www.googleapis.com/auth/script.external_request"
  ]
}

googleform_hook.php

<?php
header('Access-Control-Allow-Origin: *');
header('Content-type: application/json; charset=utf-8');

if (!isset($modx)) {
    define('MODX_API_MODE', true);
    while (!isset($modx) && ($i = isset($i) ? --$i : 10)) {
        if (($file = dirname(!empty($file) ? dirname($file) : __FILE__) . '/index.php') AND !file_exists($file)) {
            continue;
        }
        require_once $file;
    }
    if (!is_object($modx)) {
        exit('{"success":false,"message":"Access denied"}');
    }
    $modx->getService('error', 'error.modError');
    $modx->getRequest();
    $modx->setLogLevel(modX::LOG_LEVEL_ERROR);
    $modx->lexicon->load('default');
}
$ctx = !empty($_REQUEST['ctx']) ? $_REQUEST['ctx'] : $modx->context->get('key');
if ($ctx != $modx->context->get('key')) {
    $modx->switchContext($ctx);
}

$data = $_REQUEST;

$modx->addPackage('newsletters', MODX_CORE_PATH . 'components/newsletters/model/');

$table = $modx->newObject('newslettersItem');

$date = date('Y-m-d H:i:s');
$form_name = $data['form']?:'Внешняя гугл форма';
$allFormFields['createdon'] = $date;
$allFormFields['form_name'] = $form_name;
$mail_to = $modx->getOption('site_email_request');

if($data['data']){
    $form_id = $data['id'];
    $data = explode(',', $data['data']);
    if($form_id == 1 && $data[1]){
        $allFormFields['email'] = $data[1];
        $table->fromArray($allFormFields);
        if($table->save()){
            $pdoTools = $modx->getService('pdoTools');
            $msg = $pdoTools->getChunk('@INLINE {if $data}{foreach $data as $item}{$item}<br>{/foreach}{/if}', array('data' => array_merge(['form' => $form_name], $data)));
            $from_sent = 'Название сайта';
            $subj = 'Заполнена форма';
            $modx->getService('mail', 'mail.modPHPMailer');
            $modx->mail->set(modMail::MAIL_BODY, $msg);
            $modx->mail->set(modMail::MAIL_FROM, 'noreply@' . MODX_HTTP_HOST);
            $modx->mail->set(modMail::MAIL_FROM_NAME, $from_sent);
            $modx->mail->set(modMail::MAIL_SENDER, 'noreply@' . MODX_HTTP_HOST);
            $modx->mail->set(modMail::MAIL_SUBJECT, $subj);
            $mail_to_sent = array_map('trim', explode(',', $mail_to));
            if(is_array($mail_to_sent)){
              foreach($mail_to_sent as $m_to){
                $modx->mail->address('to', $m_to);
              }
            }
            $modx->mail->setHTML(true);
            if (!$modx->mail->send()) {
              $modx->log(modX::LOG_LEVEL_ERROR,'An error occurred while trying to send the email: '.$modx->mail->mailer->ErrorInfo);
            }
        }
    }
    if($form_id == 2 && $data[1]){
        $allFormFields['email'] = $data[1];
        $table->fromArray($allFormFields);
        if($table->save()){
            $pdoTools = $modx->getService('pdoTools');
            $msg = $pdoTools->getChunk('@INLINE {if $data}{foreach $data as $item}{$item}<br>{/foreach}{/if}', array('data' => array_merge(['form' => $form_name], $data)));
            $from_sent = 'Название сайта';
            $subj = 'Заполнена форма';
            $modx->getService('mail', 'mail.modPHPMailer');
            $modx->mail->set(modMail::MAIL_BODY, $msg);
            $modx->mail->set(modMail::MAIL_FROM, 'noreply@' . MODX_HTTP_HOST);
            $modx->mail->set(modMail::MAIL_FROM_NAME, $from_sent);
            $modx->mail->set(modMail::MAIL_SENDER, 'noreply@' . MODX_HTTP_HOST);
            $modx->mail->set(modMail::MAIL_SUBJECT, $subj);
            $mail_to_sent = array_map('trim', explode(',', $mail_to));
            if(is_array($mail_to_sent)){
              foreach($mail_to_sent as $m_to){
                $modx->mail->address('to', $m_to);
              }
            }
            $modx->mail->setHTML(true);
            if (!$modx->mail->send()) {
              $modx->log(modX::LOG_LEVEL_ERROR,'An error occurred while trying to send the email: '.$modx->mail->mailer->ErrorInfo);
            }
        }
    }
}

die(json_encode(array('success' => true)));