Tweet
Tweet

Slide 1

Slide 1 text

Նͷࣗ༝ݚڀ Google Apps Script @ms76 Tokyo Otaku Modeࣾ಺ษڧձ (2017/08/25)

Slide 2

Slide 2 text

Google Apps Script 1. Ͳ͏͍͏ݴޠʁ 2. ͲΜͳ͜ͱ͕Ͱ͖Δʁʢؾʹͳͬͨػೳʣ 3. Tips

Slide 3

Slide 3 text

1. Ͳ͏͍͏ݴޠʁ

Slide 4

Slide 4 text

Ͳ͏͍͏ݴޠʁ ”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

Slide 5

Slide 5 text

2. Կ͕Ͱ͖Δʁ (ؾʹͳͬͨػೳ)

Slide 6

Slide 6 text

Կ͕Ͱ͖Δʁ • Google AppsͷΧελϚΠζ • Google AppsͱଞαʔϏεͱͷ࿈ܞ

Slide 7

Slide 7 text

Կ͕Ͱ͖Δʁ άϩʔόϧείʔϓʹͲΜͳΫϥε͕͋Δ͔ʁ

Slide 8

Slide 8 text

άϩʔόϧείʔϓ • 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ܥ ͦͷଞ

Slide 9

Slide 9 text

UIApp ৮ΕͪΌ͍͚ͳ͍ࢠͩͬͨ

Slide 10

Slide 10 text

UrlFetchApp https://developers.google.com/apps-script/reference/url-fetch/url-fetch-app

Slide 11

Slide 11 text

UrlFetchApp https://developers.google.com/apps-script/reference/url-fetch/url-fetch-app httpͰ֎෦Ϧιʔεͱ௨৴͕Ͱ͖ΔΫϥεɻ ֎෦αʔϏε࿈ܞʹ͸͔ܽͤͳ͍ɻ fetchͱ͍͏໊લ͚ͩͲ POST΋Ͱ͖Δɻ

Slide 12

Slide 12 text

άϩʔόϧείʔϓ • 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ܥ ͦͷଞ ͜Μͳͷ͋ΔΜͩܥ

Slide 13

Slide 13 text

CacheService https://developers.google.com/apps-script/reference/cache/cache

Slide 14

Slide 14 text

CacheService https://developers.google.com/apps-script/reference/cache/cache Cacheʹখ͞ͳσʔλΛอଘ͢Δ͜ͱ͕Ͱ͖ Δɻ TTLΛઃఆ͢Ε͹ࣗಈͰexpire΋ͯ͘͠ΕΔɻ ScopeΛ͖ͪΜͱཧղ͢Ε͹ෳࡶͳΞϓϦέʔ γϣϯ΋ͭ͘Εͦ͏ɻ

Slide 15

Slide 15 text

ContentService https://developers.google.com/apps-script/guides/content

Slide 16

Slide 16 text

ContentService https://developers.google.com/apps-script/guides/content ScriptΛWebΞϓϦέʔγϣϯͱͯ͠ެ։ͨ͠ ࣌ʹར༻ɻ HTMLҎ֎ͷ΋ͷ΋MIME TYPEΛࢦఆͯ͠ฦ͢ ͜ͱ͕Ͱ͖Δɻ

Slide 17

Slide 17 text

LockService https://developers.google.com/apps-script/reference/lock/lock-service

Slide 18

Slide 18 text

LockService https://developers.google.com/apps-script/reference/lock/lock-service 3ͭͷείʔϓʢdocument͝ͱ / user͝ͱ / script͝ͱ ʣʹରͯ͠1ͭͷϩοΫΛ͔͚Δ͜ͱ ͕Ͱ͖Δɻ ಉ࣌ʹ৮ΒΕΔͱࠔΔέʔεͰར༻Ͱ͖Δɻ

Slide 19

Slide 19 text

Jdbc https://developers.google.com/apps-script/guides/jdbc

Slide 20

Slide 20 text

Jdbc https://developers.google.com/apps-script/guides/jdbc JDBCΛαϙʔτͨ͠֎෦ͷσʔλϕʔεʹΞΫ ηεͰ͖Δɻ Πϯλʔωοτӽ͠ʹͳΔͷͰެ։͞Ε͍ͯΔ ΞΫηεݩͷIPͷΈڐՄ͢ΔΑ͏ʹઃఆ͢Δ͜ ͱ͕ඞཁɻ

Slide 21

Slide 21 text

άϩʔόϧείʔϓ • 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ܥ ͦͷଞ ศརܥ

Slide 22

Slide 22 text

Utilities https://developers.google.com/apps-script/reference/utilities/utilities

Slide 23

Slide 23 text

Utilities https://developers.google.com/apps-script/reference/utilities/utilities ศརܥϝιου͕·ͱ·͍ͬͯΔɻ base64Τϯίʔυ/σίʔυɺHashͷܭࢉɺ UUIDͷੜ੒ɺCSVͷύʔεɺzip/unzipͳͲɻ

Slide 24

Slide 24 text

PropertiesService https://developers.google.com/apps-script/guides/properties

Slide 25

Slide 25 text

PropertiesService https://developers.google.com/apps-script/guides/properties ؀ڥม਺ͷΑ͏ʹϓϩδΣΫτʹ஋Λอଘ͢Δ͜ͱ͕Ͱ͖Δɻ

Slide 26

Slide 26 text

3. Tips

Slide 27

Slide 27 text

Tips ᶃ खܰͳdebug͸Logger.log()Ͱɻ

Slide 28

Slide 28 text

Tips ᶄ ࣮͸clonsole͕࢖͑Δɻʢlog, time, error ͳͲʣ ϩά͸GCPͷStackdriver logingͱ͍͏ίϯιʔϧʹͰ·͢ɻ

Slide 29

Slide 29 text

Tips ᶅ functionͷ࠷ޙʹΞϯμʔείΞΛ෇͚Δͱprivate functionʹͳΔɻ

Slide 30

Slide 30 text

Tips ᶆ Google AppsͷυΩϡϝϯτʹඥ෇͍ͨScriptͱͦ͏͡Όͳ͍Script͕͋Δʢ࠷ ॳށ࿭͏ʣɻτϦΨʔʹҧ͍͋Γɻ

Slide 31

Slide 31 text

Tips extra • ϥΠϒϥϦػೳΛ࢖͑͹ϥΠϒϥϦԽͨ͠ moment΍lodash΋࢖͑Δɻ • browserify + babelify + gasify Λ࢖͑͹exportΛ ࢖ͬͨΓ΍ES2015ͷߏจͰॻ͚Δʢग़དྷ্͕ͬͨ ιʔε͸…ʣ • ͦͯ͠ node-google-apps-script Λ࢖͑͹։ൃ؀ ڥͱGoogle Driveͷಉظ΋ࣗಈͰͰ͖Δɻ

Slide 32

Slide 32 text

Ҏ্Ͱ͢