Free study Google Apps Script

Transcript

1. Նͷࣗ༝ݚڀ Google Apps Script @ms76 Tokyo Otaku Modeࣾ಺ษڧձ (2017/08/25)
2. Google Apps Script 1. Ͳ͏͍͏ݴޠʁ 2. ͲΜͳ͜ͱ͕Ͱ͖Δʁʢؾʹͳͬͨػೳʣ 3. Tips
3. 1. Ͳ͏͍͏ݴޠʁ
4. Ͳ͏͍͏ݴޠʁ ”Google Apps Script is a scripting language for light-weight application development in the Google Apps platform. It is based on JavaScript 1.6 with some portions of 1.7 and 1.8 and provides subset of ECMAScript 5 API “ https://en.wikipedia.org/wiki/Google_Apps_Script
5. 2. Կ͕Ͱ͖Δʁ (ؾʹͳͬͨػೳ)
6. Կ͕Ͱ͖Δʁ • Google AppsͷΧελϚΠζ • Google AppsͱଞαʔϏεͱͷ࿈ܞ
7. Կ͕Ͱ͖Δʁ άϩʔόϧείʔϓʹͲΜͳΫϥε͕͋Δ͔ʁ
8. άϩʔόϧείʔϓ • CalendarApp • ContactsApp • DocumentApp • DriveApp • FormApp • GmailApp • GroupsApp • LanguageApp • MailApp • ScriptApp • SitesApp • SpreadsheetApp • UiApp • UrlFetchApp • CacheService • ContentService • ErrorService • HomeroomService • HtmlService • LinearOptimization
 
 Service • LockService • PropertiesService • SoapService • XmlService • Browser • Charts • Jdbc • Logger • Maps • MimeType • ScriptProperties • Session • UserProperties • Utilities • Xml • console ஥ؒ͸ͣΕͬΆ͍ Appܥ Serviceܥ ͦͷଞ
9. UIApp ৮ΕͪΌ͍͚ͳ͍ࢠͩͬͨ
10. UrlFetchApp https://developers.google.com/apps-script/reference/url-fetch/url-fetch-app
11. UrlFetchApp https://developers.google.com/apps-script/reference/url-fetch/url-fetch-app httpͰ֎෦Ϧιʔεͱ௨৴͕Ͱ͖ΔΫϥεɻ ֎෦αʔϏε࿈ܞʹ͸͔ܽͤͳ͍ɻ fetchͱ͍͏໊લ͚ͩͲ POST΋Ͱ͖Δɻ
12. άϩʔόϧείʔϓ • CalendarApp • ContactsApp • DocumentApp • DriveApp • FormApp • GmailApp • GroupsApp • LanguageApp • MailApp • ScriptApp • SitesApp • SpreadsheetApp • UiApp • UrlFetchApp • CacheService • ContentService • ErrorService • HomeroomService • HtmlService • LinearOptimization
 
 Service • LockService • PropertiesService • SoapService • XmlService • Browser • Charts • Jdbc • Logger • Maps • MimeType • ScriptProperties • Session • UserProperties • Utilities • Xml • console Appܥ Serviceܥ ͦͷଞ ͜Μͳͷ͋ΔΜͩܥ
13. CacheService https://developers.google.com/apps-script/reference/cache/cache
14. CacheService https://developers.google.com/apps-script/reference/cache/cache Cacheʹখ͞ͳσʔλΛอଘ͢Δ͜ͱ͕Ͱ͖ Δɻ TTLΛઃఆ͢Ε͹ࣗಈͰexpire΋ͯ͘͠ΕΔɻ ScopeΛ͖ͪΜͱཧղ͢Ε͹ෳࡶͳΞϓϦέʔ γϣϯ΋ͭ͘Εͦ͏ɻ
15. ContentService https://developers.google.com/apps-script/guides/content
16. ContentService https://developers.google.com/apps-script/guides/content ScriptΛWebΞϓϦέʔγϣϯͱͯ͠ެ։ͨ͠ ࣌ʹར༻ɻ HTMLҎ֎ͷ΋ͷ΋MIME TYPEΛࢦఆͯ͠ฦ͢ ͜ͱ͕Ͱ͖Δɻ
17. LockService https://developers.google.com/apps-script/reference/lock/lock-service
18. LockService https://developers.google.com/apps-script/reference/lock/lock-service 3ͭͷείʔϓʢdocument͝ͱ / user͝ͱ / script͝ͱ ʣʹରͯ͠1ͭͷϩοΫΛ͔͚Δ͜ͱ ͕Ͱ͖Δɻ ಉ࣌ʹ৮ΒΕΔͱࠔΔέʔεͰར༻Ͱ͖Δɻ
19. Jdbc https://developers.google.com/apps-script/guides/jdbc
20. Jdbc https://developers.google.com/apps-script/guides/jdbc JDBCΛαϙʔτͨ͠֎෦ͷσʔλϕʔεʹΞΫ ηεͰ͖Δɻ Πϯλʔωοτӽ͠ʹͳΔͷͰެ։͞Ε͍ͯΔ ΞΫηεݩͷIPͷΈڐՄ͢ΔΑ͏ʹઃఆ͢Δ͜ ͱ͕ඞཁɻ
21. άϩʔόϧείʔϓ • CalendarApp • ContactsApp • DocumentApp • DriveApp • FormApp • GmailApp • GroupsApp • LanguageApp • MailApp • ScriptApp • SitesApp • SpreadsheetApp • UiApp • UrlFetchApp • CacheService • ContentService • ErrorService • HomeroomService • HtmlService • LinearOptimization
 
 Service • LockService • PropertiesService • SoapService • XmlService • Browser • Charts • Jdbc • Logger • Maps • MimeType • ScriptProperties • Session • UserProperties • Utilities • Xml • console Appܥ Serviceܥ ͦͷଞ ศརܥ
22. Utilities https://developers.google.com/apps-script/reference/utilities/utilities
23. Utilities https://developers.google.com/apps-script/reference/utilities/utilities ศརܥϝιου͕·ͱ·͍ͬͯΔɻ base64Τϯίʔυ/σίʔυɺHashͷܭࢉɺ UUIDͷੜ੒ɺCSVͷύʔεɺzip/unzipͳͲɻ
24. PropertiesService https://developers.google.com/apps-script/guides/properties
25. PropertiesService https://developers.google.com/apps-script/guides/properties ؀ڥม਺ͷΑ͏ʹϓϩδΣΫτʹ஋Λอଘ͢Δ͜ͱ͕Ͱ͖Δɻ
26. 3. Tips
27. Tips ᶃ खܰͳdebug͸Logger.log()Ͱɻ
28. Tips ᶄ ࣮͸clonsole͕࢖͑Δɻʢlog, time, error ͳͲʣ ϩά͸GCPͷStackdriver logingͱ͍͏ίϯιʔϧʹͰ·͢ɻ
29. Tips ᶅ functionͷ࠷ޙʹΞϯμʔείΞΛ෇͚Δͱprivate functionʹͳΔɻ
30. Tips ᶆ Google AppsͷυΩϡϝϯτʹඥ෇͍ͨScriptͱͦ͏͡Όͳ͍Script͕͋Δʢ࠷ ॳށ࿭͏ʣɻτϦΨʔʹҧ͍͋Γɻ
31. Tips extra • ϥΠϒϥϦػೳΛ࢖͑͹ϥΠϒϥϦԽͨ͠ moment΍lodash΋࢖͑Δɻ • browserify + babelify + gasify Λ࢖͑͹exportΛ ࢖ͬͨΓ΍ES2015ͷߏจͰॻ͚Δʢग़དྷ্͕ͬͨ ιʔε͸…ʣ • ͦͯ͠ node-google-apps-script Λ࢖͑͹։ൃ؀ ڥͱGoogle Driveͷಉظ΋ࣗಈͰͰ͖Δɻ
32. Ҏ্Ͱ͢