{"id":27349,"date":"2025-11-22T13:34:58","date_gmt":"2025-11-22T04:34:58","guid":{"rendered":"https:\/\/motoki-design.co.jp\/wordpress\/?p=27349"},"modified":"2026-10-04T07:47:10","modified_gmt":"2026-10-03T22:47:10","slug":"snow-monkey-forms-to-spreadsheet","status":"publish","type":"post","link":"https:\/\/motoki-design.co.jp\/wordpress\/snow-monkey-forms-to-spreadsheet\/","title":{"rendered":"Snow Monkey Forms\u2502\u304a\u554f\u3044\u5408\u308f\u305b\u5185\u5bb9\u3092\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306b\u66f8\u304d\u8fbc\u3080\u65b9\u6cd5"},"content":{"rendered":"\n

\u304a\u554f\u3044\u5408\u308f\u305b\u30d5\u30a9\u30fc\u30e0\u7528\u306e\u30d7\u30e9\u30b0\u30a4\u30f3Snow Monkey Forms<\/strong>\u3067\u3059\u304c\u3001\u57fa\u672c\u3001\u304a\u554f\u3044\u5408\u308f\u305b\u5185\u5bb9\u306f\u30e1\u30fc\u30eb\u3067\u9001\u4fe1\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n

\u305d\u308c\u3060\u3051\u3067\u306a\u304f\u3001\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306b\u3082\u66f8\u304d\u8fbc\u307f\u305f\u3044\u3068\u304d\u306b\u5f79\u306b\u7acb\u3064\u30ab\u30b9\u30bf\u30de\u30a4\u30ba\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n\n\n\n

Snow Monkey Forms \u306e\u8a2d\u5b9a\u30fb\u30ab\u30b9\u30bf\u30de\u30a4\u30ba\u65b9\u6cd5\u306f\u3053\u3061\u3089\u306b\u307e\u3068\u3081\u3066\u3044\u307e\u3059<\/a>\u3002<\/p>\n\n\n\n

Snow Monkey Forms\u3067\u304a\u554f\u3044\u5408\u308f\u305b\u5185\u5bb9\u3092\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306b\u66f8\u304d\u8fbc\u3080\u30ab\u30b9\u30bf\u30de\u30a4\u30ba<\/h2>\n\n\n\n

\u3084\u308a\u65b9\u306f\u610f\u5916\u3068\u7c21\u5358\u3067\u3059\u3002<\/p>\n\n\n\n

Snow Monkey Forms\u306e\u4f5c\u6210<\/h3>\n\n\n\n

\u666e\u901a\u306b\u30d7\u30e9\u30b0\u30a4\u30f3\u3092\u5165\u308c\u3066\u304a\u554f\u3044\u5408\u308f\u305b\u30d5\u30a9\u30fc\u30e0\u3092\u4f5c\u308a\u307e\u3059\u3002<\/p>\n\n\n\n

\"Snow<\/figure>\n\n\n\n

\u304a\u554f\u3044\u5408\u308f\u305b\u9805\u76ee\u306b\u5408\u308f\u305b\u3066NAME\u5c5e\u6027\u306b\u540d\u524d\u3092\u3064\u3051\u3066\u304a\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n

\"\u304a\u554f\u3044\u5408\u308f\u305b\u30d5\u30a9\u30fc\u30e0\u306e\u9805\u76ee\u306b\u5408\u308f\u305b\u3066NAME\u5c5e\u6027\u3092\u8a2d\u5b9a\u3057\u3066\u3044\u308b\u753b\u9762\u3002\"<\/figure>\n\n\n\n

\u4eca\u56de\u306f\u4ee5\u4e0b\u306b\u8a2d\u5b9a\u3057\u307e\u3057\u305f\u3002<\/p>\n\n\n\n

\u9805\u76ee<\/th>NAME<\/th><\/tr><\/thead>
\u304a\u540d\u524d<\/td>your-name<\/td><\/tr>
E\u30e1\u30fc\u30eb<\/td>your-email<\/td><\/tr>
\u30e1\u30c3\u30bb\u30fc\u30b8<\/td>your-message<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u4f5c\u6210<\/h3>\n\n\n\n

\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3092\u7528\u610f\u3057\u307e\u3059\u3002<\/p>\n\n\n\n

\u30b7\u30fc\u30c8\u540d\u306f\u304a\u554f\u3044\u5408\u308f\u305b<\/code>\u306b\u3057\u307e\u3057\u305f\u3002<\/p>\n\n\n\n

\u5c02\u7528\u30b7\u30fc\u30c8\u306e1\u884c\u76ee\u3092\u300c\u30ea\u30af\u30a8\u30b9\u30c8ID\u3001\u65e5\u6642\u3001\u30d5\u30a9\u30fc\u30e0ID\u3001\u304a\u540d\u524d\u3001\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u3001\u30e1\u30c3\u30bb\u30fc\u30b8\u300d\u306e6\u5217\u306b\u3057\u307e\u3059\u3002\u65e2\u5b58\u30c7\u30fc\u30bf\u3078\u4e0a\u66f8\u304d\u305b\u305a\u3001\u30c6\u30b9\u30c8\u7528\u306e\u5225\u30b7\u30fc\u30c8\u3092\u7528\u610f\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n

\u30ea\u30af\u30a8\u30b9\u30c8ID<\/td>\u65e5\u6642<\/td>\u30d5\u30a9\u30fc\u30e0ID<\/td>\u304a\u540d\u524d<\/td>\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9<\/td>\u30e1\u30c3\u30bb\u30fc\u30b8<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n\n\n

GAS\u306e\u4f5c\u6210<\/h3>\n\n\n\n

\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u62e1\u5f35\u6a5f\u80fd\u304b\u3089Apps Script\u3092\u9078\u629e<\/p>\n\n\n\n

\"\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u62e1\u5f35\u6a5f\u80fd\u30e1\u30cb\u30e5\u30fc\u304b\u3089Apps<\/figure>\n\n\n\n

\u4ee5\u4e0b\u306fPOST\u5c02\u7528\u306e\u53d7\u4fe1\u30b3\u30fc\u30c9\u3067\u3059\u3002\u65e2\u5b58\u306e\u5b9f\u30c7\u30fc\u30bf\u3092\u4f7f\u308f\u305a\u3001\u307e\u305a\u30c6\u30b9\u30c8\u7528\u30b7\u30fc\u30c8\u3067\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n

\u3044\u304b\u3001\u8a73\u7d30\u3067\u3059\u3002<\/p>\n\n\n\n

\u307e\u305a\u306f\u4e0b\u8a18\u306e\u30b3\u30fc\u30c9\u3092\u30b3\u30d4\u30da\u3057\u307e\u3059\u3002<\/p>\n\n\n\n

\u30b7\u30fc\u30c8\u540d\u306f\u304a\u554f\u3044\u5408\u308f\u305b<\/code>\u306b\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n

function output_(value) {\n  return ContentService.createTextOutput(JSON.stringify(value)).setMimeType(ContentService.MimeType.JSON);\n}\nfunction doGet() { return output_({ok: false}); }\nfunction doPost(e) {\n  let lock;\n  try {\n    if (!e || !e.postData || e.postData.contents.length > 20000) return output_({ok: false});\n    const data = JSON.parse(e.postData.contents);\n    const props = PropertiesService.getScriptProperties();\n    const secret = props.getProperty('WAZA_SMF_SECRET');\n    if (!secret || !\/^[0-9a-f]{64}$\/i.test(secret) || data.secret !== secret) return output_({ok: false});\n    if (!\/^[0-9a-f-]{36}$\/i.test(data.request_id || '') || data.form_id !== 115) return output_({ok: false});\n    for (const [key, max] of [['name',200],['email',320],['message',5000]]) {\n      if (typeof data[key] !== 'string' || data[key].length > max) return output_({ok: false});\n    }\n    const sheetId = props.getProperty('WAZA_SMF_SHEET_ID');\n    if (!sheetId) return output_({ok: false});\n    lock = LockService.getScriptLock();\n    if (!lock.tryLock(5000)) return output_({ok: false});\n    const sheet = SpreadsheetApp.openById(sheetId).getSheetByName('\u304a\u554f\u3044\u5408\u308f\u305b');\n    if (!sheet) return output_({ok: false});\n    const last = sheet.getLastRow();\n    if (last > 1 && sheet.getRange(2,1,last-1,1).createTextFinder(data.request_id).matchEntireCell(true).findNext()) {\n      return output_({ok: true, duplicate: true});\n    }\n    const text = value => \/^[\\s]*[=+@-]\/.test(value) ? "'" + value : value;\n    sheet.appendRow([data.request_id,new Date(),data.form_id,text(data.name),text(data.email),text(data.message)]);\n    SpreadsheetApp.flush();\n    return output_({ok: true});\n  } catch (_) {\n    return output_({ok: false}); \/\/ \u672c\u6587\u3084\u79d8\u5bc6\u5024\u3092\u30ed\u30b0\u306b\u51fa\u3055\u306a\u3044\n  } finally {\n    if (lock && lock.hasLock()) lock.releaseLock();\n  }\n}\n<\/code><\/pre><\/div>\n\n\n
\u30b3\u30fc\u30c9\u304c\u30b3\u30d4\u30da\u3067\u304d\u305f\u306e\u3067\u3042\u308c\u3070\u3001\u65b0\u3057\u3044\u30c7\u30d7\u30ed\u30a4\u3092\u9078\u629e\u3002<\/p>\n\n\n\n
\"Apps<\/figure>\n\n\n\n
\u30a6\u30a7\u30d6\u30a2\u30d7\u30ea\u306e\u7a2e\u985e\u3092\u9078\u629e<\/p>\n\n\n\n
WordPress\u304b\u3089\u975e\u30ed\u30b0\u30a4\u30f3\u306eHTTP\u30ea\u30af\u30a8\u30b9\u30c8\u3092\u53d7\u3051\u308b\u69cb\u6210\u3067\u3059\u3002\u516c\u958b\u524d\u306b\u3001\u30b9\u30af\u30ea\u30d7\u30c8\u30d7\u30ed\u30d1\u30c6\u30a3\u3078 WAZA_SMF_SECRET\uff08\u5b89\u5168\u306a\u4e71\u6570\u3067\u751f\u6210\u3057\u305f64\u6841\u306e16\u9032\u6587\u5b57\u5217\uff09\u3068 WAZA_SMF_SHEET_ID\uff08\u4fdd\u5b58\u5148\u306e\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8ID\uff09\u3092\u767b\u9332\u3057\u307e\u3059\u3002\u30b3\u30fc\u30c9\u306f\u79d8\u5bc6\u5024\u304c\u4e00\u81f4\u3057\u306a\u3044POST\u3068\u3001\u3059\u3079\u3066\u306eGET\u3092\u62d2\u5426\u3057\u307e\u3059\u3002\u7d44\u7e54\u3067\u533f\u540dWeb\u30a2\u30d7\u30ea\u3092\u8a31\u53ef\u3057\u3066\u3044\u306a\u3044\u5834\u5408\u306f\u3001\u3053\u306e\u69cb\u6210\u3092\u4f7f\u308f\u306a\u3044\u3067\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n\n\n
\u6700\u5f8c\u306b\u30c7\u30d7\u30ed\u30a4\u30dc\u30bf\u30f3\u3092\u62bc\u3057\u307e\u3059\u3002<\/p>\n\n\n\n
\u30c7\u30d7\u30ed\u30a4\u6642\u306e\u5b9f\u884c\u8005\u30fb\u30a2\u30af\u30bb\u30b9\u7bc4\u56f2\u30fb\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3078\u306e\u6a29\u9650\u3092\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u30b7\u30fc\u30c8\u81ea\u4f53\u3092\u4e00\u822c\u516c\u958b\u3059\u308b\u5fc5\u8981\u306f\u3042\u308a\u307e\u305b\u3093\u3002<\/p>\n\n\n\n
\"\u30c7\u30d7\u30ed\u30a4\u6642\u306b\u6c42\u3081\u3089\u308c\u308b\u30a2\u30af\u30bb\u30b9\u627f\u8a8d\u306e\u753b\u9762\u3002\"<\/figure>\n\n\n\n
\u627f\u8a8d\u304c\u7d42\u308f\u308b\u3068\u30a6\u30a7\u30d6\u30a2\u30d7\u30ea\u306eURL\u304c\u767a\u884c\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n
URL\u306f\u30b3\u30d4\u30fc\u3057\u3066\u30e1\u30e2\u3057\u3066\u304a\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n
\"\u30c7\u30d7\u30ed\u30a4\u5b8c\u4e86\u5f8c\u306b\u767a\u884c\u3055\u308c\u305f\u30a6\u30a7\u30d6\u30a2\u30d7\u30ea\u306eURL\u753b\u9762\u3002\"<\/figure>\n\n\n\n
functions.php\u306e\u8a2d\u5b9a<\/h3>\n\n\n\n
WordPress\u306b\u623b\u308a\u307e\u3059\u3002<\/p>\n\n\n\n
\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u5f8c\u3001\u5b50\u30c6\u30fc\u30de\u306efunctions.php\u3078\u4ee5\u4e0b\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002\u5bfe\u8c61\u30d5\u30a9\u30fc\u30e0ID\u306e115\u306fPHP\u3068GAS\u306e\u4e21\u65b9\u3067\u5909\u66f4\u3057\u3066\u304f\u3060\u3055\u3044\u3002PHP\u3067\u306fskip\u30d5\u30a3\u30eb\u30bf\u30fc\u306e\u5224\u5b9a\u3001after_send\u306e\u5224\u5b9a\u3001\u9001\u4fe1\u30c7\u30fc\u30bf\u306eform_id\u306e3\u304b\u6240\u3092\u305d\u308d\u3048\u307e\u3059\u3002\u30e1\u30fc\u30eb\u3092\u30b9\u30ad\u30c3\u30d7\u3059\u308b\u30d5\u30a3\u30eb\u30bf\u30fc\u304c\u3042\u308b\u5834\u5408\u306f\u3001\u305d\u306e\u51e6\u7406\u3092\u5148\u306b\u767b\u9332\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u30b9\u30ad\u30c3\u30d7\u304c\u6709\u52b9\u306a\u9001\u4fe1\u306f\u30b7\u30fc\u30c8\u3078\u30b3\u30d4\u30fc\u3057\u307e\u305b\u3093\u3002\u79d8\u5bc6\u5024\u3084GAS\u306eURL\u3092\u30d5\u30ed\u30f3\u30c8\u5074JavaScript\u3078\u51fa\u529b\u3057\u307e\u305b\u3093\u3002<\/p>\n\n\n\n
\u30a8\u30e9\u30fc\u304c\u6016\u3044\u4eba\u306fCode Snippets\u306e\u30d7\u30e9\u30b0\u30a4\u30f3\u3092\u5165\u308c\u3066\u3001\u305d\u3053\u304b\u3089\u30b3\u30fc\u30c9\u3092\u633f\u5165\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n
wp-config.php\u306e\u7de8\u96c6\u7d42\u4e86\u884c\u3088\u308a\u524d\u306b\u3001\u6b21\u306e\u5b9a\u6570\u3092\u5b9a\u7fa9\u3057\u307e\u3059\u3002URL\u306f\u81ea\u5206\u306e \/exec URL\u3001\u79d8\u5bc6\u5024\u306fGAS\u3068\u540c\u305864\u6841\u306e\u4e71\u6570\u3078\u7f6e\u304d\u63db\u3048\u307e\u3059\u3002\u4f8b\u306e\u30d7\u30ec\u30fc\u30b9\u30db\u30eb\u30c0\u30fc\u306e\u307e\u307e\u3067\u306f\u9001\u4fe1\u3055\u308c\u307e\u305b\u3093\u3002\u516c\u958b\u30ea\u30dd\u30b8\u30c8\u30ea\u306b\u79d8\u5bc6\u5024\u3092\u4fdd\u5b58\u3057\u306a\u3044\u3067\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n
\"WordPress\u306e\u30c6\u30fc\u30de\u30a8\u30c7\u30a3\u30bf\u3084Code<\/figure>\n\n\n
define( 'WAZA_SMF_GAS_URL', 'https:\/\/script.google.com\/macros\/s\/REPLACE_WITH_DEPLOYMENT_ID\/exec' );\ndefine( 'WAZA_SMF_GAS_SECRET', 'REPLACE_WITH_RANDOM_64_HEX_CHARACTERS' );<\/code><\/pre><\/div>
\/\/ \u540c\u3058\u9001\u4fe1\u51e6\u7406\u306e\u30b9\u30ad\u30c3\u30d7\u7d50\u679c\u3092\u4fdd\u6301\u3059\u308b\uff08\u30ea\u30af\u30a8\u30b9\u30c8\u5185\u3060\u3051\uff09\u3002\n$waza_smf_sheet_state = new SplObjectStorage();\nadd_filter( 'snow_monkey_forms\/administrator_mailer\/skip', function ( $skip, $responser, $setting ) use ( $waza_smf_sheet_state ) {\n    if ( 115 === (int) $setting->get( 'form_id' ) ) {\n        $waza_smf_sheet_state[ $responser ] = (bool) $skip;\n    }\n    return $skip;\n}, PHP_INT_MAX, 3 );\n\nadd_action( 'snow_monkey_forms\/administrator_mailer\/after_send', function ( $sent, $responser, $setting, $parser ) use ( $waza_smf_sheet_state ) {\n    if ( ! $sent || 115 !== (int) $setting->get( 'form_id' ) ) return;\n\n    if ( ! $waza_smf_sheet_state->contains( $responser ) ) return;\n    $skipped = $waza_smf_sheet_state[ $responser ];\n    $waza_smf_sheet_state->detach( $responser );\n    if ( $skipped ) return; \/\/ \u30b9\u30ad\u30c3\u30d7\u306e true \u3092\u30e1\u30fc\u30eb\u6210\u529f\u3068\u3057\u3066\u6271\u308f\u306a\u3044\u3002\n    if ( ! defined( 'WAZA_SMF_GAS_URL' ) || ! defined( 'WAZA_SMF_GAS_SECRET' ) || ! preg_match( '\/^[0-9a-f]{64}$\/i', WAZA_SMF_GAS_SECRET ) ) return;\n    if ( ! preg_match( '~^https:\/\/script\\.google\\.com\/macros\/s\/[A-Za-z0-9_-]+\/exec$~', WAZA_SMF_GAS_URL ) ) return;\n    $values = $responser->get_all();\n    $payload = array( 'secret' => WAZA_SMF_GAS_SECRET, 'request_id' => wp_generate_uuid4(), 'form_id' => 115 );\n    foreach ( array( 'name' => 'your-name', 'email' => 'your-email', 'message' => 'your-message' ) as $key => $field ) {\n        $value = $values[ $field ] ?? '';\n        if ( ! is_string( $value ) ) return;\n        $payload[ $key ] = $value;\n    }\n    $response = wp_remote_post( WAZA_SMF_GAS_URL, array(\n        'timeout' => 10,\n        'headers' => array( 'Content-Type' => 'application\/json' ),\n        'body' => wp_json_encode( $payload ),\n    ) );\n    $ok = ! is_wp_error( $response ) && 200 === wp_remote_retrieve_response_code( $response );\n    $body = $ok ? json_decode( wp_remote_retrieve_body( $response ), true ) : null;\n    if ( ! is_array( $body ) || true !== ( $body['ok'] ?? false ) ) {\n        error_log( 'WAZA SMF sheet copy failed. Request: ' . $payload['request_id'] );\n    }\n}, 10, 4 );\n<\/code><\/pre><\/div>\n\n\n
\u30c6\u30b9\u30c8<\/h3>\n\n\n\n
\u4ee5\u4e0a\u306e\u8a2d\u5b9a\u304c\u7d42\u308f\u3063\u305f\u3089\u30c6\u30b9\u30c8\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n
\"\u8a2d\u5b9a\u5b8c\u4e86\u5f8c\u306b\u304a\u554f\u3044\u5408\u308f\u305b\u30d5\u30a9\u30fc\u30e0\u304b\u3089\u30c6\u30b9\u30c8\u9001\u4fe1\u3092\u884c\u3046\u753b\u9762\u3002\"<\/figure>\n\n\n\n
\u67b6\u7a7a\u306e\u540d\u524d\u30fbexample.com\u306e\u30a2\u30c9\u30ec\u30b9\u3067\u9001\u4fe1\u3057\u3001\u30e1\u30fc\u30eb\u6210\u529f\u5f8c\u306b\u30b7\u30fc\u30c8\u30781\u884c\u5165\u308b\u3053\u3068\u3001\u79d8\u5bc6\u5024\u304c\u9055\u3046\u8981\u6c42\u306f\u66f8\u304d\u8fbc\u307e\u308c\u306a\u3044\u3053\u3068\u3001\u540c\u3058\u30ea\u30af\u30a8\u30b9\u30c8ID\u306e\u518d\u9001\u306f\u91cd\u8907\u3057\u306a\u3044\u3053\u3068\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002\u5148\u982d\u304c\u300c=\u300d\u306a\u3069\u306e\u5024\u306f\u6570\u5f0f\u5316\u3092\u907f\u3051\u308b\u305f\u3081\u6587\u5b57\u5217\u3068\u3057\u3066\u4fdd\u5b58\u3057\u307e\u3059\u3002<\/p>\n\n\n\n\n\n
\u307e\u3068\u3081<\/h2>\n\n\n\n
\u307e\u3068\u3081\u308b\u3068\u4eca\u56de\u306e\u30ab\u30b9\u30bf\u30de\u30a4\u30ba\u306f\u4ee5\u4e0b\u306e\u3053\u3068\u3092\u3084\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n