{"id":1035,"date":"2025-07-24T19:15:50","date_gmt":"2025-07-24T10:15:50","guid":{"rendered":"https:\/\/roroing.net\/?p=1035"},"modified":"2025-07-24T19:15:50","modified_gmt":"2025-07-24T10:15:50","slug":"%e3%83%a1%e3%83%ab%e3%82%ab%e3%83%aa%e3%81%a7%e5%a3%b2%e3%82%8a%e4%b8%8a%e3%81%92%e5%90%88%e8%a8%88%e3%82%92%e3%81%a0%e3%81%97%e3%81%9f","status":"publish","type":"post","link":"https:\/\/roroing.net\/?p=1035","title":{"rendered":"\u30e1\u30eb\u30ab\u30ea\u3067\u58f2\u308a\u4e0a\u3052\u5408\u8a08\u3092\u3060\u3057\u305f"},"content":{"rendered":"\n

\u6700\u8fd1\u30e1\u30eb\u30ab\u30ea\u3067\u4e0d\u7528\u7269\u3092\u6574\u7406\u3057\u3066\u3044\u307e\u3059
\u521d\u3081\u3066\u6570\u30f6\u6708\u3082\u7d4c\u3061\u3001\u305d\u308d\u305d\u308d\u58f2\u308a\u4e0a\u3052\u3092\u78ba\u8a8d\u3057\u305f\u304b\u3063\u305f\u306e\u3067\u3059\u304c\u3001
\u30e1\u30eb\u30ab\u30ea\u3063\u3066\u58f2\u308a\u4e0a\u3052\u306e\u5408\u8a08\u304c\u3042\u308a\u307e\u305b\u3093\u3002
\u306a\u306e\u3067\u3001\u81ea\u5206\u3067\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u7df4\u7fd2\u304c\u3066\u3089\u306b\u30bd\u30d5\u30c8\u4f5c\u6210\u3057\u305f\u304b\u3063\u305f\u306e\u3067\u3059\u304c\u3001
API\u304c\u306a\u3044\u305f\u3081\u3069\u3046\u3057\u3088\u3046\u304b\u3068\u601d\u3063\u3066\u3044\u305f\u3068\u3053\u308d\u3059\u3067\u306b\u4fbf\u5229\u306a\u30b5\u30a4\u30c8\u304c\u3042\u308a\u307e\u3057\u305f\u3002

\u25fe\ufe0f\u30e1\u30eb\u30ab\u30ea\u306e\u58f2\u4e0a\u7ba1\u7406\u8868\u3092\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3092\u4f7f\u3063\u3066\u81ea\u52d5\u3067\u4f5c\u308d\u3046\u3002
https:\/\/intellectual-productivity.com\/how-to-mercari-summary-automate<\/a>

\u305f\u3060\u3001\u5408\u8a08\u5024\u304c\u308f\u304b\u3089\u306a\u3044\u306e\u3067\u3001chatgpt\u306b\u76f8\u8ac7\u3057\u3064\u3064\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u30b3\u30fc\u30c9\u306b\u3057\u3066
\u5408\u8a08\u5024\u3068\u624b\u6570\u6599-10%\u3092\u5f15\u3044\u305f\u984d\u304c\u51fa\u529b\u3055\u308c\u308b\u3088\u3046\u306b\u3057\u307e\u3057\u305f<\/p>\n\n\n\n

function mercari_summary() {\n  var threads = GmailApp.search('subject:\u767a\u9001\u3092\u304a\u9858\u3044\u3057\u307e\u3059 -label:\u51e6\u7406\u6e08\u307f');\n\n  threads.forEach(function(thread) {\n    var messages = thread.getMessages();\n\n    messages.forEach(function(message) {\n      var plainBody = message.getPlainBody();\n      var date = message.getDate();\n\n      var product_ID = plainBody.match(\/\u5546\u54c1ID : (.*)\/);\n      var product_name = plainBody.match(\/\u5546\u54c1\u540d : (.*)\/);\n      var product_price = plainBody.match(\/\u5546\u54c1\u4fa1\u683c : (.*)\/);\n\n      var sheet = SpreadsheetApp.getActive().getSheetByName('\u58f2\u4e0a\u30ea\u30b9\u30c8');\n      var lastRow = sheet.getLastRow() + 1;\n\n      sheet.getRange(lastRow, 1).setValue(product_ID[1]);\n      sheet.getRange(lastRow, 2).setValue(product_name[1]);\n      sheet.getRange(lastRow, 3).setValue(product_price[1]);\n      sheet.getRange(lastRow, 4).setValue(date);\n    });\n  });\n\n  \/\/ \u25bc\u25bc \u5408\u8a08\u306890%\u306e\u8a08\u7b97 \u25bc\u25bc\n  var sheet = SpreadsheetApp.getActive().getSheetByName('\u58f2\u4e0a\u30ea\u30b9\u30c8');\n  var data = sheet.getRange(2, 3, sheet.getLastRow() - 1).getValues();  \/\/ C\u5217\u306e\u30c7\u30fc\u30bf\uff082\u884c\u76ee\u301c\uff09\n\n  var sum = 0;\n  data.forEach(function(row) {\n    var val = row[0];\n    if (typeof val === 'string') {\n      val = val.replace(\/[\u5186,]\/g, ''); \/\/ \u5186\u3068\u30ab\u30f3\u30de\u3092\u9664\u53bb\n    }\n    var num = parseFloat(val);\n    if (!isNaN(num)) {\n      sum += num;\n    }\n  });\n\n\/\/ \u5408\u8a08\u306890%\u306e\u8868\u793a\uff08F1, G1, F2, G2\uff09\nsheet.getRange(1, 6).setValue('\u5408\u8a08');\nsheet.getRange(1, 7).setValue(sum);\nsheet.getRange(2, 6).setValue('90%');\nsheet.getRange(2, 7).setValue(sum * 0.9);\n\n\/\/ \u30b9\u30bf\u30a4\u30eb\u8a2d\u5b9a\uff08F1:G2\uff09\nvar range = sheet.getRange('F1:G2');\nrange.setFontWeight('bold');             \/\/ \u592a\u5b57\nrange.setBackground('#d9ead3');          \/\/ \u8584\u7dd1\u8272\u306e\u80cc\u666f\nrange.setFontColor('#000000');           \/\/ \u6587\u5b57\u8272\u3092\u9ed2\u306b\nrange.setHorizontalAlignment('right');   \/\/ \u53f3\u5bc4\u305b\n}\n<\/code><\/pre>\n\n\n\n
\u7d50\u679c\u3068\u3057\u3066\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u306a\u308a\u307e\u3059
<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
90%\u306e\u90e8\u5206\u3092\u624b\u6570\u6599\u8fbc\u307f\u3068\u5909\u63db\u3057\u3066\u3082\u3044\u3044\u304b\u3082\u3067\u3059\u306d\u3002\u5c0f\u6570\u70b9\u3082\u5207\u308a\u6368\u3066\u3066\u3044\u3044\u304b\u3082<\/p>\n","protected":false},"excerpt":{"rendered":"
\u6700\u8fd1\u30e1\u30eb\u30ab\u30ea\u3067\u4e0d\u7528\u7269\u3092\u6574\u7406\u3057\u3066\u3044\u307e\u3059\u521d\u3081\u3066\u6570\u30f6\u6708\u3082\u7d4c\u3061\u3001\u305d\u308d\u305d\u308d\u58f2\u308a\u4e0a\u3052\u3092\u78ba\u8a8d\u3057\u305f\u304b\u3063\u305f\u306e\u3067\u3059\u304c\u3001\u30e1\u30eb\u30ab\u30ea\u3063\u3066\u58f2\u308a\u4e0a\u3052\u306e\u5408\u8a08\u304c\u3042\u308a\u307e\u305b\u3093\u3002\u306a\u306e\u3067\u3001\u81ea\u5206\u3067\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u7df4\u7fd2\u304c\u3066\u3089\u306b\u30bd\u30d5\u30c8\u4f5c\u6210\u3057\u305f\u304b\u3063\u305f\u306e\u3067\u3059\u304c\u3001API\u304c\u306a\u3044 ... \"\u30e1\u30eb\u30ab\u30ea\u3067\u58f2\u308a\u4e0a\u3052\u5408\u8a08\u3092\u3060\u3057\u305f\"<\/span> \u3092\u7d9a\u3051\u3066\u8aad\u3080<\/a><\/p>\n","protected":false},"author":1,"featured_media":1037,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[2,14],"tags":[],"class_list":{"0":"post-1035","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-it","8":"category-14","9":"h-entry","10":"hentry","11":"h-as-article"},"jetpack_featured_media_url":"https:\/\/roroing.net\/wp-content\/uploads\/2025\/07\/image.png","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/roroing.net\/index.php?rest_route=\/wp\/v2\/posts\/1035","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/roroing.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/roroing.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/roroing.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/roroing.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1035"}],"version-history":[{"count":1,"href":"https:\/\/roroing.net\/index.php?rest_route=\/wp\/v2\/posts\/1035\/revisions"}],"predecessor-version":[{"id":1038,"href":"https:\/\/roroing.net\/index.php?rest_route=\/wp\/v2\/posts\/1035\/revisions\/1038"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/roroing.net\/index.php?rest_route=\/wp\/v2\/media\/1037"}],"wp:attachment":[{"href":"https:\/\/roroing.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1035"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/roroing.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1035"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/roroing.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1035"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}