{"id":2714,"date":"2021-10-24T20:15:08","date_gmt":"2021-10-24T11:15:08","guid":{"rendered":"https:\/\/www.choco.org.uk\/chocodb\/?p=2714"},"modified":"2021-10-26T22:00:57","modified_gmt":"2021-10-26T13:00:57","slug":"gas%e3%82%92%e4%bd%bf%e3%81%a3%e3%81%a6%e3%80%81gmail%e3%81%ae%e5%86%85%e5%ae%b9%e3%82%92%e3%82%b9%e3%83%97%e3%83%ac%e3%83%83%e3%83%89%e3%82%b7%e3%83%bc%e3%83%88%e3%81%ab%e8%bb%a2%e8%a8%98%e3%81%99","status":"publish","type":"post","link":"https:\/\/www.choco.org.uk\/chocodb\/?p=2714","title":{"rendered":"GAS\u3092\u4f7f\u3063\u3066\u3001GMAIL\u306e\u5185\u5bb9\u3092\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306b\u8ee2\u8a18\u3059\u308b\u3002"},"content":{"rendered":"

Gooogle\u3092\u4f7f\u3063\u3066\u3044\u3066\u601d\u3046\u306e\u3067\u3059\u304c\u3001\u4fbf\u5229\u306a\u4e8b\u304c\u3067\u304d\u308b\u306e\u306a\u3089\u3070\u5177\u4f53\u7684\u306a\u65e5\u672c\u8a9e<\/span>\u306e\u30b5\u30f3\u30d7\u30eb\u304c\u6b32\u3057\u3044\u3067\u3059\u3088\u306d\uff1f
\n\u4f55\u6545\u304b\u7121\u3044\u3093\u3067\u3059\u3088\u306d\u3002\u3002\u3002\uff08\u82f1\u8a9e\u306e\u30b5\u30f3\u30d7\u30eb\u306f\u3044\u3063\u3071\u3044\u3042\u308b\u306e\u306b\u3002\uff09
\n\u3067\u3001\u3061\u3087\u3063\u3068\u30b5\u30f3\u30d7\u30eb\u3092\u516c\u958b\u3057\u3066\u307f\u3088\u3046\u304b\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n

\u7b2c\u4e00\u56de\u306f\u3001\u81ea\u5206\u306eGmail\u306b\u6765\u3066\u3044\u308b\u30e1\u30fc\u30eb\u3092\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306b\u8ee2\u8a18\u3059\u308b\u3068\u3044\u3046\u30b9\u30af\u30ea\u30d7\u30c8\u3067\u3059\u3002<\/p>\n

\n

function MailFunction() {
\n\/\/\u7d50\u679c\u8a18\u8f09\u7528\u306e\u914d\u5217\u3092\u5ba3\u8a00\u3057\u307e\u3059\u3002
\nvar values = [];
\n\/\/ \u691c\u7d22\u6761\u4ef6\u306b\u8a72\u5f53\u3059\u308b\u30b9\u30ec\u30c3\u30c9\u4e00\u89a7\u3092\u53d6\u5f97\uff08GmailApp.search\uff09
\n\/\/\u3053\u3053\u3067\u306f\u3001\u300cchoco@yahoo.co.jp<\/span>\u300d\u304b\u3089\u6765\u305f\u30e1\u30fc\u30eb\u3092\u53ce\u96c6\u3057\u3066\u3044\u307e\u3059\u3002
\nvar threads = GmailApp.search(‘from:choco@yahoo.co.jp<\/span> -label:\u51e6\u7406\u6e08\u307f’);
\nLogger.log(threads);<\/p>\n

\/\/ \u30b9\u30ec\u30c3\u30c9\u3092\u4e00\u3064\u305a\u3064\u53d6\u308a\u51fa\u3059
\nthreads.forEach(function(thread) {<\/p>\n

\/\/ \u30b9\u30ec\u30c3\u30c9\u5185\u306e\u30e1\u30fc\u30eb\u4e00\u89a7\u3092\u53d6\u5f97
\nvar messages = thread.getMessages();<\/p>\n

\/\/ \u30e1\u30fc\u30eb\u3092\u4e00\u3064\u305a\u3064\u53d6\u308a\u51fa\u3059
\nmessages.forEach(function(message) {
\n\/\/ \u30e1\u30fc\u30eb\u672c\u6587\u3092\u53d6\u5f97
\nvar plainBody = message.getPlainBody();<\/p>\n

\/\/ \u53d7\u4fe1\u65e5\u3092\u53d6\u308a\u51fa\u3059
\nvar getTime = message.getDate();<\/p>\n

\/\/ \u8868\u984c\u3092\u53d6\u308a\u51fa\u3059\u3002
\nvar subject = message.getSubject();<\/p>\n

\/\/ From\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u3092\u53d6\u308a\u51fa\u3059
\nvar from = message.getFrom();<\/p>\n

\/\/ To\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u3092\u53d6\u308a\u51fa\u3059\uff08\u4eca\u56de\u306f\u30b3\u30e1\u30f3\u30c8\uff09
\n\/\/ var to = message.getTo();<\/p>\n

\/\/ CC\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u3092\u53d6\u308a\u51fa\u3059\uff08\u4eca\u56de\u306f\u30b3\u30e1\u30f3\u30c8\uff09
\n\/\/ var cc = message.getCc();<\/p>\n

\/\/ BCC\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u3092\u53d6\u308a\u51fa\u3059\uff08\u4eca\u56de\u306f\u30b3\u30e1\u30f3\u30c8\uff09
\n\/\/ var bcc = message.getBcc();<\/p>\n

\/\/ \u30e1\u30fc\u30eb\u672c\u6587\u3092\u53d6\u308a\u51fa\u3059\u3002\uff08\u4eca\u56de\u306f\u30b3\u30e1\u30f3\u30c8\uff09
\n\/\/ var plainBody = message.getPlainBody();<\/p>\n

\n
\/\/ \u30c6\u30f3\u30dd\u30e9\u30ea\u30b7\u30fc\u30c8\u3092\u8a2d\u5b9a\uff08\u5c02\u7528\u30b7\u30fc\u30c8\uff1amailcount\u3092\u5225\u9014\u4f5c\u6210\u3057\u307e\u3057\u305f\u3002\uff09<\/div>\n
var sheet = SpreadsheetApp.getActive().getSheetByName(‘mailcount’);<\/div>\n<\/div>\n

\/\/ \u6700\u7d42\u884c\u3092\u53d6\u5f97
\nvar lastRow = sheet.getLastRow() + 1;<\/p>\n

\/\/ \u66f8\u304d\u8fbc\u3080\u9805\u76ee\u3092\u8a2d\u5b9a\uff08\u53d7\u4fe1\u65e5\u3001FROM\u3001\u8868\u984c\uff09
\nvalues.push([getTime,from,subject]);<\/p>\n

});<\/p>\n

\/\/\u4eca\u30a2\u30af\u30c6\u30a3\u30d6\u306a\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306b\u7d50\u679c\u3092\u8a18\u8f09
\nvar ss = SpreadsheetApp.getActiveSpreadsheet();
\nvar sheet = ss.getActiveSheet();<\/p>\n

\/\/\u5ea7\u6a19\u306f\uff11\uff0c\uff11\u306b\u3057\u307e\u3057\u305f\u3002
\nsheet.getRange(1,1,values.length,values[0].length).setValues(values);<\/p>\n

});
\n}<\/p>\n

\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Gooogle\u3092\u4f7f\u3063\u3066\u3044\u3066\u601d\u3046\u306e\u3067\u3059\u304c\u3001\u4fbf\u5229\u306a\u4e8b\u304c\u3067\u304d\u308b\u306e\u306a\u3089\u3070\u5177\u4f53\u7684\u306a\u65e5\u672c\u8a9e\u306e\u30b5\u30f3\u30d7\u30eb\u304c\u6b32\u3057\u3044\u3067\u3059\u3088\u306d\uff1f \u4f55\u6545\u304b\u7121\u3044\u3093\u3067\u3059\u3088\u306d\u3002\u3002\u3002\uff08\u82f1\u8a9e\u306e\u30b5\u30f3\u30d7\u30eb\u306f\u3044\u3063\u3071\u3044\u3042\u308b\u306e\u306b\u3002\uff09 \u3067\u3001\u3061\u3087\u3063\u3068\u30b5\u30f3\u30d7\u30eb\u3092\u516c\u958b\u3057\u3066\u307f\u3088\u3046\u304b\u3068\u601d\u3044\u307e […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[97],"tags":[144,102,180,179],"class_list":["post-2714","post","type-post","status-publish","format-standard","hentry","category-google","tag-gas","tag-gmail","tag-google-apps-script","tag-179"],"_links":{"self":[{"href":"https:\/\/www.choco.org.uk\/chocodb\/index.php?rest_route=\/wp\/v2\/posts\/2714","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.choco.org.uk\/chocodb\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.choco.org.uk\/chocodb\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.choco.org.uk\/chocodb\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.choco.org.uk\/chocodb\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2714"}],"version-history":[{"count":4,"href":"https:\/\/www.choco.org.uk\/chocodb\/index.php?rest_route=\/wp\/v2\/posts\/2714\/revisions"}],"predecessor-version":[{"id":2718,"href":"https:\/\/www.choco.org.uk\/chocodb\/index.php?rest_route=\/wp\/v2\/posts\/2714\/revisions\/2718"}],"wp:attachment":[{"href":"https:\/\/www.choco.org.uk\/chocodb\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2714"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.choco.org.uk\/chocodb\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2714"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.choco.org.uk\/chocodb\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2714"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}