{"id":4635,"date":"2024-03-03T16:50:07","date_gmt":"2024-03-03T07:50:07","guid":{"rendered":"https:\/\/taitan916.info\/blog\/?p=4635"},"modified":"2024-02-16T17:21:37","modified_gmt":"2024-02-16T08:21:37","slug":"post-4635","status":"publish","type":"post","link":"https:\/\/taitan916.info\/blog\/archives\/4635","title":{"rendered":"GAS\u3092\u5229\u7528\u3057\u3066Gmail\u306b\u5c4a\u3044\u305f\u30e1\u30fc\u30eb\u5185\u5bb9\u3092Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306b\u8a18\u5165\u3059\u308b\u65b9\u6cd5"},"content":{"rendered":"

WordPress\u306eContact Form7\u304b\u3089\u9001\u4fe1\u3057\u305f\u5185\u5bb9\u3092Gmail\u3067\u53d7\u3051\u53d6\u308a\u300c\u53d7\u4fe1\u65e5\u6642\u300d\u300c\u9001\u4fe1\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u300d\u300c\u4ef6\u540d\u300d\u300c\u672c\u6587\u300d\u3092Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306b\u8a18\u5165\u3057\u305f\u3044\u3002Google Apps Script\u3068\u9023\u643a\u3055\u305b\u308b\u3053\u3068\u3067\u5bb9\u6613\u306b\u5bfe\u5fdc\u3067\u304d\u305d\u3046\u3002\u4ee5\u4e0b\u306b\u5b9f\u88c5\u65b9\u6cd5\u3092\u30e1\u30e2\u3002<\/p>\n

 <\/p>\n

\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u6e96\u5099<\/h2>\n

\u4ee5\u4e0b\u306e\u3088\u3046\u306b1\u884c\u76ee\u306b\u9805\u76ee\u540d\u3092\u8ffd\u8a18\u3057\u3066\u304a\u304f\u3002<\/p>\n

\"\"<\/a><\/p>\n

 <\/p>\n

Contact Form7\u306e\u6e96\u5099<\/h2>\n

\u984c\u540d(\u30e1\u30fc\u30eb\u306e\u4ef6\u540d)\u3092\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u8a2d\u5b9a\u3057\u3066\u304a\u304f\u3002<\/p>\n

\u3010GAS\u30c6\u30b9\u30c8\u3011\u554f\u3044\u5408\u308f\u305b\u901a\u77e5<\/pre>\n
\u5c1a\u3001\u4eca\u56de\u306f\u5b9f\u9a13\u3082\u517c\u306d\u3066\u3044\u308b\u306e\u3067Contact Form7\u3092\u5229\u7528\u3057\u3066\u3044\u308b\u304c\u3001PHP\u3067\u4f5c\u6210\u3057\u305f\u30d5\u30a9\u30fc\u30e0\u306e\u5834\u5408\u306a\u3069\u3082\u984c\u540d\u3092\u5206\u304b\u308a\u3084\u3059\u3044\u3082\u306e\u306b\u8a2d\u5b9a\u3057\u3066\u304a\u304f\u3068\u3088\u3044\u3002<\/p>\n
 <\/p>\n
GAS<\/h2>\n
\u30bd\u30fc\u30b9\u30b3\u30fc\u30c9<\/h3>\n
function getMail(){\r\n\r\n    \/\/\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u8aad\u307f\u8fbc\u307f\r\n    const sheet = SpreadsheetApp.getActiveSheet();\r\n\r\n    \/\/\u8aad\u307f\u8fbc\u3093\u3060\u30b7\u30fc\u30c8\u306e\u6700\u7d42\u884c\u3092\u53d6\u5f97\u3059\u308b\r\n    const last = sheet.getLastRow();\r\n\r\n    \/\/\u30b7\u30fc\u30c8\u304c\u672a\u8a18\u5165\u306e\u5834\u5408\r\n    if( last == 1 ){\r\n\r\n        \/\/\u6628\u65e5\u5206\u306e\u30bf\u30a4\u30e0\u30b9\u30b9\u30bf\u30f3\u30d7\u3092\u53d6\u5f97\r\n        var last_date = parseInt(((new Date()).getTime() - 1 * 60 * 60 * 1000) \/ 1000);\r\n    }else{\r\n\r\n        \/\/\u6700\u65b0\u30c7\u30fc\u30bf\u306b+1\u3057\u305f\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u3092\u53d6\u5f97\r\n        var last_date = new Date(sheet.getRange(`A${last}`).getValue());\r\n        last_date = parseInt(last_date.getTime()) \/ 1000 + 1;\r\n    }\r\n\r\n    \/\/\u4ef6\u540d\u3092\u6307\u5b9a\u3057\u3066\u691c\u7d22\r\n    const query = `after:${last_date} subject: \u3010GAS\u30c6\u30b9\u30c8\u3011\u554f\u3044\u5408\u308f\u305b\u901a\u77e5`;\r\n\r\n    \/\/\u958b\u59cb\u884c\r\n    const start = 0;\r\n\r\n    \/\/\u7d42\u4e86\u884c\r\n    const max = 10;\r\n\r\n    \/\/\u30e1\u30fc\u30eb\u306e\u691c\u7d22\r\n    const threads = GmailApp.search(query, start, max);\r\n\r\n    const mail_data = [];\r\n\r\n    \/\/\u30e1\u30fc\u30eb\u306e\u53d6\u5f97\r\n    const messagesForThreads = GmailApp.getMessagesForThreads(threads);\r\n\r\n    for(const messages of messagesForThreads){\r\n        const message = messages[0];\r\n        const record = [\r\n            message.getDate(),\r\n            message.getFrom(),\r\n            message.getSubject(),\r\n            message.getPlainBody().slice(0,200)\r\n        ];\r\n        mail_data.push(record);\r\n    }\r\n\r\n    if(mail_data.length > 0){\r\n        SpreadsheetApp.getActiveSheet().getRange((last + 1), 1, mail_data.length, mail_data[0].length).setValues(mail_data);\r\n    }\r\n}\r\n\r\n<\/pre>\n
\u89e3\u8aac\u7b49<\/h3>\n
\u691c\u7d22\u6761\u4ef6\u90e8\u5206<\/h4>\n
\u4ef6\u540d\u304c\u300c\u3010GAS\u30c6\u30b9\u30c8\u3011\u554f\u3044\u5408\u308f\u305b\u901a\u77e5\u300d\u4e14\u3064\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u3092\u6307\u5b9a\u3057\u691c\u7d22\u3057\u3066\u3044\u308b\u3002<\/p>\n
\u5c1a\u3001\u30ea\u30d5\u30a1\u30ec\u30f3\u30b9<\/a>\u3067\u306fafter \/ before\u306f\u5e74\u6708\u65e5\u6307\u5b9a\u306e\u307f\u8868\u8a18\u3055\u308c\u3066\u304a\u308a\u65e5\u6642\u6307\u5b9a\u306f\u8868\u8a18\u3055\u308c\u3066\u3044\u306a\u3044\u304c\u3001\u3053\u3061\u3089\u306e\u30b5\u30a4\u30c8<\/a>\u306b\u3088\u308b\u3068UNIX\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u3067\u65e5\u6642\u3082\u6307\u5b9a\u3067\u304d\u308b\u3068\u306e\u3053\u3068\u3002<\/p>\n
\u6ce8\u610f\u70b9<\/h4>\n
\u4ee5\u524d\u306b\u3082\u66f8\u3044\u305f\u304c<\/a>search\u6642\u306e\u4e0a\u9650\u306b\u6c17\u3092\u4ed8\u3051\u308b\u3053\u3068\u3002<\/span><\/p>\n
\u53d6\u5f97\u3057\u305f\u30c7\u30fc\u30bf\u3092\u4e0a\u306e\u884c\u306b\u8ffd\u8a18\u3057\u3066\u3044\u304d\u305f\u3044\u5834\u5408<\/h4>\n
\u4e0a\u8a18\u306e\u30bd\u30fc\u30b9\u30b3\u30fc\u30c9\u3060\u3068\u53d6\u5f97\u3057\u305f\u30c7\u30fc\u30bf\u306f\u30b7\u30fc\u30c8\u306e\u4e0b\u306b\u8ffd\u8a18\u3055\u308c\u3066\u3044\u304f\u3002\u3053\u308c\u3092\u9006\u306b\u3057\u305f\u3044(\u4e0a\u306e\u65b9\u306b\u8ffd\u8a18\u3057\u3066\u3044\u304d\u305f\u3044)\u5834\u5408\u306f\u4ee5\u4e0b\u90e8\u5206\u3092\u5909\u66f4\u3059\u308b\u3053\u3068\u3002<\/p>\n
#\u5909\u66f4\u524d\r\nSpreadsheetApp.getActiveSheet().getRange((last + 1), 1, mail_data.length, mail_data[0].length).setValues(mail_data);\r\n\r\n#\u5909\u66f4\u5f8c\r\nSpreadsheetApp.getActiveSheet().insertRows(2, mail_data.length);\r\nSpreadsheetApp.getActiveSheet().getRange(2, 1, mail_data.length, mail_data[0].length).setValues(mail_data);<\/pre>\n
insertRows\u3067\u66f4\u65b0\u30c7\u30fc\u30bf\u5206\u306e\u884c\u30922\u884c\u76ee\u4ee5\u964d\u306b\u633f\u5165\u3057\u3001\u633f\u5165\u3057\u305f\u884c\u306b\u30c7\u30fc\u30bf\u3092\u66f8\u304d\u8fbc\u3080\u3068\u3044\u3046\u5f62\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
WordPress\u306eContact Form7\u304b\u3089\u9001\u4fe1\u3057\u305f\u5185\u5bb9\u3092Gmail\u3067\u53d7\u3051 ... <\/p>\n","protected":false},"author":1,"featured_media":3294,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[72,70],"tags":[],"class_list":["post-4635","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-apps-script","category-google"],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/posts\/4635","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/comments?post=4635"}],"version-history":[{"count":5,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/posts\/4635\/revisions"}],"predecessor-version":[{"id":4638,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/posts\/4635\/revisions\/4638"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/media\/3294"}],"wp:attachment":[{"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/media?parent=4635"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/categories?post=4635"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/tags?post=4635"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}