{"id":2464,"date":"2017-10-07T02:36:25","date_gmt":"2017-10-06T17:36:25","guid":{"rendered":"https:\/\/do-gugan.com\/~furuta\/?p=2464"},"modified":"2017-10-07T02:37:46","modified_gmt":"2017-10-06T17:37:46","slug":"google-home_spreadsheet","status":"publish","type":"post","link":"https:\/\/do-gugan.com\/~furuta\/archives\/2017\/10\/google-home_spreadsheet.html","title":{"rendered":"Google Home\u304b\u3089IFTTT\u7d4c\u7531\u3067Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306b\u66f8\u304d\u8fbc\u3093\u3060\u6642\u3001\u65e5\u4ed8\u304c\u8a18\u5165\u3055\u308c\u306a\u3044"},"content":{"rendered":"<p>\u6bce\u671d\u85ac\u3092\u98f2\u3093\u3060\u304b\u3088\u304f\u5fd8\u308c\u308b\u306e\u3067\u3001Google Home\u306b\u300cOK, Google\u3002\u85ac\u3092\u98f2\u3093\u3060\uff01\u300d\u3063\u3066\u8a00\u3063\u3066\u304a\u3051\u3070\u65e5\u6642\u3092Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306b\u8a18\u9332\u3057\u3066\u304a\u3044\u3066\u304f\u308c\u308b\u30ec\u30b7\u30d4\u3092IFTTT\u306b\u4f5c\u308a\u307e\u3057\u305f\u3002<\/p>\n<p>IFTTT\u306eGoogle Drive\u30a2\u30d7\u30ec\u30c3\u30c8\u3067\u300cAdd row to spreadsheet\u300d\u3092\u9078\u3079\u3070\u6307\u5b9a\u3057\u305f\u30d5\u30a1\u30a4\u30eb\u540d\u306e\u8868\u8a08\u7b97\u30d5\u30a1\u30a4\u30eb\u306e\u4e00\u756a\u4e0b\u306b\u884c\u3092\u8db3\u3057\u3066\u304f\u308c\u307e\u3059\u304c\u3001\u305d\u306e\u5185\u5bb9\u3068\u3057\u3066\u3001\u65e5\u6642\u3092\u66f8\u304d\u8fbc\u3093\u3067\u304f\u308c\u308b\u306f\u305a\u306e[CreatedAt]\u3068\u3044\u3046\u30b3\u30de\u30f3\u30c9\u304c\u52b9\u304d\u307e\u305b\u3093\u3067\u3057\u305f\u3002\u672c\u6765\u306f\u3001\u300cFormatted row\u300d\u6b04\u306b\u300cCreatedAt ||| \u671d\u306e\u670d\u7528\u5b8c\u4e86\u300d\u306a\u3069\u3068\u3057\u3066\u304a\u3051\u3070\u3001|||\u304c\u30bb\u30eb\u306e\u533a\u5207\u308a\u3092\u610f\u5473\u3059\u308b\u306e\u3067\u30011\u5217\u76ee\u306b\u65e5\u6642\u30012\u5217\u76ee\u306b\u300c\u671d\u306e\u670d\u7528\u5b8c\u4e86\u300d\u3068\u3044\u3046\u6587\u5b57\u304c\u5165\u308b\u306f\u305a\u306a\u306e\u3067\u3059\u304c\u30011\u5217\u76ee\u304c\u7a7a\u306e\u307e\u307e\u3067\u3059\u3002<\/p>\n<p>\u30b0\u30b0\u3063\u305f\u3068\u3053\u308d\u82f1\u8a9e\u306e\u63b2\u793a\u677f\u3067\u540c\u69d8\u306e\u7591\u554f\u304c\u5448\u3055\u308c\u3066\u3044\u3066\u3001\u3069\u3046\u3082\u30d0\u30b0\u3068\u3044\u3046\u304b\u73fe\u6642\u70b9\u306e\u4f7f\u7528\u3063\u307d\u3044\u3067\u3059\u3002MESH\u306a\u3069\u4ed6\u306e\u30c8\u30ea\u30ac\u304b\u3089\u547c\u3073\u51fa\u3057\u305f\u6642\u306b\u306f\u3061\u3083\u3093\u3068\u52d5\u3044\u3066\u3044\u305f\u306e\u3067\u3001Google Assistant\u30a2\u30d7\u30ec\u30c3\u30c8\u306e\u30d0\u30b0\u304b\u76f8\u6027\u306a\u3093\u3067\u3057\u3087\u3046\u3002<\/p>\n<p>\u3067\u3001Google Spreadsheet\u5074\u3067\u306e\u30ef\u30fc\u30af\u30a2\u30e9\u30a6\u30f3\u30c9\uff08\u30d0\u30b0\u56de\u907f\u65b9\u6cd5\uff09\u3068\u3057\u3066\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u4f7f\u3063\u3066\u300c\u8868\u304c\u66f4\u65b0\u3055\u308c\u305f\u3089\u4e00\u756a\u4e0b\u306e1\u5217\u76ee\u306b\u65e5\u4ed8\u3092\u5165\u308c\u308b\u300d\u3068\u3044\u3046\u52d5\u4f5c\u3092\u3055\u305b\u308b\u3084\u308a\u65b9\u304c\u7d39\u4ecb\u3055\u308c\u3066\u3044\u307e\u3057\u305f\u3002<\/p>\n<p>\u3061\u3087\u3063\u3068\u52d5\u753b\u3068\u30e1\u30cb\u30e5\u30fc\u306e\u4f4d\u7f6e\u304c\u9055\u3063\u3066\u3044\u305f\u308a\uff08\u30b9\u30af\u30ea\u30d7\u30c8\u30a8\u30c7\u30a3\u30bf\u30fc\u306e\u30c8\u30ea\u30ac\u95a2\u9023\u306e\u9805\u76ee\u304c\u52d5\u753b\u3067\u306f\u300cResources\u300d\u3067\u3059\u304c\u5b9f\u969b\u306b\u306f\u300c\u7de8\u96c6\u300d\u306b\u3042\u3063\u305f\u308a\uff09\u3001\u521d\u56de\u306b\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u5b9f\u884c\u3055\u305b\u308b\u8a31\u53ef\u30c0\u30a4\u30a2\u30ed\u30b0\u304c\u51fa\u305f\u308a\u3068\u52d5\u753b\u306e\u901a\u308a\u306b\u306f\u3044\u304b\u306a\u304b\u3063\u305f\u3067\u3059\u304c\u4e00\u5fdc\u3067\u304d\u307e\u3057\u305f\u306e\u3067\u53c2\u8003\u306b\u3054\u7d39\u4ecb\u3002<\/p>\n<blockquote class=\"embedly-card\" data-card-controls=\"0\" data-card-align=\"center\" data-card-theme=\"light\">\n<h4><a href=\"https:\/\/www.youtube.com\/watch?v=ufujOWXsq40&#038;feature=youtu.be\">Google Home IFTTT Sheets<\/a><\/h4>\n<p>Script: function addDate(e) { var lr = SpreadsheetApp.getActiveSheet().getLastRow(); SpreadsheetApp.getActiveSheet().getRange(lr, 1).setValue(new Date()); }<\/p>\n<\/blockquote>\n<p><script async src=\"\/\/cdn.embedly.com\/widgets\/platform.js\" charset=\"UTF-8\"><\/script><\/p>\n<p>\u3042\u3068\u30b3\u30d4\u30da\u7528\u306b\u30b3\u30fc\u30c9\u3082\u8cbc\u3063\u3066\u304a\u304d\u307e\u3059\u3002<\/p>\n<pre class=\"lang:default decode:true\">function addDate(e) {\r\n    var lr = SpreadsheetApp.getActiveSheet().getLastRow();\r\n    SpreadsheetApp.getActiveSheet().getRange(lr, 1).setValue(new Date());\r\n}<\/pre>\n<p>\u5730\u5473\u306b\u4e0d\u4fbf\u306a\u306e\u3067\u6cbb\u308b\u3068\u3044\u3044\u3067\u3059\u306d\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6bce\u671d\u85ac\u3092\u98f2\u3093\u3060\u304b\u3088\u304f\u5fd8\u308c\u308b\u306e\u3067\u3001Google Home\u306b\u300cOK, Google\u3002\u85ac\u3092\u98f2\u3093\u3060\uff01\u300d\u3063\u3066\u8a00\u3063\u3066\u304a\u3051\u3070\u65e5\u6642\u3092Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306b\u8a18\u9332\u3057\u3066\u304a\u3044\u3066\u304f\u308c\u308b\u30ec\u30b7\u30d4\u3092IFTTT\u306b\u4f5c\u308a\u307e\u3057\u305f\u3002 IFTTT\u306eGoog [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[158],"tags":[],"class_list":["post-2464","post","type-post","status-publish","format-standard","hentry","category-googlehome"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/do-gugan.com\/~furuta\/wp-json\/wp\/v2\/posts\/2464","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/do-gugan.com\/~furuta\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/do-gugan.com\/~furuta\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/do-gugan.com\/~furuta\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/do-gugan.com\/~furuta\/wp-json\/wp\/v2\/comments?post=2464"}],"version-history":[{"count":3,"href":"https:\/\/do-gugan.com\/~furuta\/wp-json\/wp\/v2\/posts\/2464\/revisions"}],"predecessor-version":[{"id":2467,"href":"https:\/\/do-gugan.com\/~furuta\/wp-json\/wp\/v2\/posts\/2464\/revisions\/2467"}],"wp:attachment":[{"href":"https:\/\/do-gugan.com\/~furuta\/wp-json\/wp\/v2\/media?parent=2464"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/do-gugan.com\/~furuta\/wp-json\/wp\/v2\/categories?post=2464"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/do-gugan.com\/~furuta\/wp-json\/wp\/v2\/tags?post=2464"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}