Snow Monkey Forms│お問い合わせ内容をスプレッドシートに書き込む方法

function output_(value) {
  return ContentService.createTextOutput(JSON.stringify(value)).setMimeType(ContentService.MimeType.JSON);
}
function doGet() { return output_({ok: false}); }
function doPost(e) {
  let lock;
  try {
    if (!e || !e.postData || e.postData.contents.length > 20000) return output_({ok: false});
    const data = JSON.parse(e.postData.contents);
    const props = PropertiesService.getScriptProperties();
    const secret = props.getProperty('WAZA_SMF_SECRET');
    if (!secret || !/^[0-9a-f]{64}$/i.test(secret) || data.secret !== secret) return output_({ok: false});
    if (!/^[0-9a-f-]{36}$/i.test(data.request_id || '') || data.form_id !== 115) return output_({ok: false});
    for (const [key, max] of [['name',200],['email',320],['message',5000]]) {
      if (typeof data[key] !== 'string' || data[key].length > max) return output_({ok: false});
    }
    const sheetId = props.getProperty('WAZA_SMF_SHEET_ID');
    if (!sheetId) return output_({ok: false});
    lock = LockService.getScriptLock();
    if (!lock.tryLock(5000)) return output_({ok: false});
    const sheet = SpreadsheetApp.openById(sheetId).getSheetByName('お問い合わせ');
    if (!sheet) return output_({ok: false});
    const last = sheet.getLastRow();
    if (last > 1 && sheet.getRange(2,1,last-1,1).createTextFinder(data.request_id).matchEntireCell(true).findNext()) {
      return output_({ok: true, duplicate: true});
    }
    const text = value => /^[\s]*[=+@-]/.test(value) ? "'" + value : value;
    sheet.appendRow([data.request_id,new Date(),data.form_id,text(data.name),text(data.email),text(data.message)]);
    SpreadsheetApp.flush();
    return output_({ok: true});
  } catch (_) {
    return output_({ok: false}); // 本文や秘密値をログに出さない
  } finally {
    if (lock && lock.hasLock()) lock.releaseLock();
  }
}

define( 'WAZA_SMF_GAS_URL', 'https://script.google.com/macros/s/REPLACE_WITH_DEPLOYMENT_ID/exec' );
define( 'WAZA_SMF_GAS_SECRET', 'REPLACE_WITH_RANDOM_64_HEX_CHARACTERS' );

// 同じ送信処理のスキップ結果を保持する（リクエスト内だけ）。
$waza_smf_sheet_state = new SplObjectStorage();
add_filter( 'snow_monkey_forms/administrator_mailer/skip', function ( $skip, $responser, $setting ) use ( $waza_smf_sheet_state ) {
    if ( 115 === (int) $setting->get( 'form_id' ) ) {
        $waza_smf_sheet_state[ $responser ] = (bool) $skip;
    }
    return $skip;
}, PHP_INT_MAX, 3 );

add_action( 'snow_monkey_forms/administrator_mailer/after_send', function ( $sent, $responser, $setting, $parser ) use ( $waza_smf_sheet_state ) {
    if ( ! $sent || 115 !== (int) $setting->get( 'form_id' ) ) return;

    if ( ! $waza_smf_sheet_state->contains( $responser ) ) return;
    $skipped = $waza_smf_sheet_state[ $responser ];
    $waza_smf_sheet_state->detach( $responser );
    if ( $skipped ) return; // スキップの true をメール成功として扱わない。
    if ( ! defined( 'WAZA_SMF_GAS_URL' ) || ! defined( 'WAZA_SMF_GAS_SECRET' ) || ! preg_match( '/^[0-9a-f]{64}$/i', WAZA_SMF_GAS_SECRET ) ) return;
    if ( ! preg_match( '~^https://script\.google\.com/macros/s/[A-Za-z0-9_-]+/exec$~', WAZA_SMF_GAS_URL ) ) return;
    $values = $responser->get_all();
    $payload = array( 'secret' => WAZA_SMF_GAS_SECRET, 'request_id' => wp_generate_uuid4(), 'form_id' => 115 );
    foreach ( array( 'name' => 'your-name', 'email' => 'your-email', 'message' => 'your-message' ) as $key => $field ) {
        $value = $values[ $field ] ?? '';
        if ( ! is_string( $value ) ) return;
        $payload[ $key ] = $value;
    }
    $response = wp_remote_post( WAZA_SMF_GAS_URL, array(
        'timeout' => 10,
        'headers' => array( 'Content-Type' => 'application/json' ),
        'body' => wp_json_encode( $payload ),
    ) );
    $ok = ! is_wp_error( $response ) && 200 === wp_remote_retrieve_response_code( $response );
    $body = $ok ? json_decode( wp_remote_retrieve_body( $response ), true ) : null;
    if ( ! is_array( $body ) || true !== ( $body['ok'] ?? false ) ) {
        error_log( 'WAZA SMF sheet copy failed. Request: ' . $payload['request_id'] );
    }
}, 10, 4 );