Google Apps Script: Getting the most out of Google Apps

Download Google Apps Script: Getting the most out of Google Apps

Post on 07-Dec-2014

950 views

Category:

Technology

0 download

Embed Size (px)

DESCRIPTION

"Google Apps Script" session slide deck, as presented by Wesley Chun in the Google Academy at TCEA in Austin, Feb 2014.

TRANSCRIPT

  • *RRJOH$SSV6FULSW*HWWLQJWKHPRVWRXWRI*RRJOH$SSV

    :HVOH\&KXQ#ZHVFS\'HYHORSHU$GYRFDWH

    *RRJOH

    7&($

    &RQWULEXWHTXHVWLRQVDW

    BJJBGMGH

    $ERXWWKH6SHDNHU&RGH

  • $ERXWWKH6SHDNHU7HDFK

    $ERXWWKH6SHDNHU:ULWH

  • -XVW-DYD6FULSW EXWQRWLQWKHEURZVHU WUXQVLQ*RRJOHVFORXGVHUYHUVLGH

    &RGHHGLWRUULJKWLQ\RXUEURZVHU =HURVHWXS 6WDQGDUG*RRJOH'ULYHVWRUDJHVKDULQJ 5XQVLQDXWKHQWLFDWHGHQYLURQPHQW

    'HVLJQHGWRH[WHQG*RRJOH$SSV 1RFRGLQJQHHGHGWRXVH$SSV

    $SSV6FULSWLVGLIIHUHQWLWLVFRGLQJ $3VIRUPDQ\*RRJOHVHUYLFHV (YHQWVDQGGHHS8LQWHJUDWLRQSRLQWV %XLOWLQVHFXULW\DQGGHSOR\PHQW

    $SSV6FULSWLV

    $FFHVVPDQ\*RRJOH6HUYLFHVDVZHOODV$SSV6FULSWIXQFWLRQDOLW\:KDWFDQ$SSV6FULSWGR"

    *RRJOH3URGXFWV&DOHQGDU&KDUWV&RQWDFWV'ULYH'RFXPHQWV'RPDLQ)LQDQFH)RUPV*PDLO*URXSV/DQJXDJH0DSV6LWHV6SUHDGVKHHWV

    &RPPXQLFDWLRQDQG8&RQWHQW+WPO-GEF0DLO6RDS8L8UO)HWFK;PO

    8WLOLWLHV%DVH&DFKH/RFN3URSHUWLHV6FULSW6FULSW'E8WLOLWLHV

  • ([DPSOH7KHVSUHDGVKHHW*RRJOH6KHHWV

    ([DPSOH7KH$SSV6FULSWFRGH

    API>ODJIN@I?

  • ([DPSOH$FFHVVWKHVSUHDGVKHHWDQGGDWD

    API>ODJIN@I?

  • ([DPSOH$VN*PDLOWRVHQGDPHVVDJH

    API>ODJIN@I?

  • 5HFHQWPSURYHPHQWV

    *RRJOH)RUPV$3

    &TGCVGHQTOCPFGOCKNNKPMXCTHQTO )QTO$RRETGCVG'KPPGT3NCPPKPI)QTOHQTOUGV7KVNG'KPPGT$XCKNCDKNKV[HQTOUGV&QNNGEV(OCKNUVTWG

    XCTKVGO HQTOCFF&JGEMDQZ,VGOKVGOUGV7KVNG:JCVFC[UCTG[QWCXCKNCDNG"KVGOUGV&JQKEG9CNWGU>0QPFC[7WGUFC[:GFPGUFC[@

    0CKN$RRUGPF(OCKN6GUUKQPIGV$EVKXG8UGTIGV(OCKN3NGCUGHKNNQWVVJKUHQTOHQTOIGV3WDNKUJGF8TN

    -6

    XCTHKNGU 'TKXG$RRIGV)KNGUYJKNGHKNGUJCU1GZV]XCTHKNG HKNGUPGZV/QIIGTNQIHKNGIGV1COG_

    -6SWK\7GORNCVGUGV6JCTKPI'TKXG$RR$EEGUU$1

  • 5HFHQWPSURYHPHQWVPSURYHG2$XWKSDQHOV

    %HIRUH $IWHU

    5HFHQWPSURYHPHQWV$3WRDFFHVV$SSV6FULSWFRGH

  • 5HFHQWPSURYHPHQWV$SSV6FULSWVXSSRUWLQ*RRJOH3OXJLQIRU(FOLSVH

    5HFHQWPSURYHPHQWV$GPLQ6'.*ODVVDQGRWKHU$3VH[SRVHG

  • $SSV6FULSWXVHFDVHV

    (QWHUSULVH:RUNIORZV 'RFXPHQW$SSURYDO3XUFKDVH2UGHUV

    5HVRXUFH0DQDJHPHQW 7LPH%RRNLQJ+HOSGHVN3URMHFW7UDFNLQJ0DLO5RRP0DQDJHPHQW%LOOLQJ

    $XWRPDWLRQ $XWRFUHDWHFDOHQGDUHYHQWPDLOPHUJHPRYHFHOOVLQVSUHDGVKHHW

    5HSRUWLQJ 'DVKERDUGV1LJKWO\UHSRUWV

    QWHJUDWLRQ*OXH 6DOHV)RUFHFRP7ZLWWHU

    'RPDLQ$GPLQLVWUDWLRQ $GGXVHUVUHVHWXVHUDFFRXQWVDXWRFUHDWHVLWHVIROGHUVIRUXVHUV

    *UDGLQJPDGHHDV\ZLWK)OXEDURR

    &UHDWHTXL]XVLQJ*RRJOH)RUPV'(02 $XWRPDWLFDOO\JUDGHVDJDLQVWDQVZHUNH\ &DQHPDLOUHVXOWVDQGDQVZHUVWRHDFKVWXGHQW 3URYLGHVFKDUWVWRDQDO\]HWKHUHVXOWV

  • 0DQ\W\SHVRIPDLOPHUJH

    'HILQHDVLPSOHWHPSODWHXVLQJDGUDIWHPDLOGRFXPHQWVLWHVSDJHRUVSUHDGVKHHWFHOO

    $GGSODFHKROGHUYDOXHVWKDWVKRXOGEHG\QDPLFDOO\UHSODFHG (DFKVSUHDGVKHHWURZPHUJHGZLWKWHPSODWHDQGVHQWRXW

    9DFDWLRQFDOHQGDUIRU%URZQ8QLYHUVLW\

    $JJUHJDWHVWRJHWKHUDOOWKHVWDIIWKDWDUHRQYDFDWLRQWKDWGD\ &UHDWHVDVLQJOHFDOHQGDUHYHQWHDFKGD\ZKLFKOLVWVHYHU\RQH

    WKDWLVRXW 0DNHVLWHDVLHUWRUHDG\RXUFDOHQGDU

  • -XVWRSHQWKHVFULSWHGLWRU7\SHVRI$SSV6FULSWVDQGKRZWRJHWVWDUWHG

    6WDQGDORQHVFULSW VFULSWJRRJOHFRP *RRJOH'ULYH!&UHDWH!6FULSW

    6SUHDGVKHHWRU'RFXPHQWERXQGVFULSW 7RROV!6FULSW(GLWRU

    6LWHVERXQGVFULSW 0RUH!0DQDJH6LWH!$SSV6FULSWV!$GGQHZVFULSW

    +RZWRJHWKHOS

    'RFXPHQWDWLRQ KWWSGHYHORSHUVJRRJOHFRPDSSVVFULSW 8VHUJXLGHFRYHULQJEDVLFIXQFWLRQDOLW\ WXWRULDOVZLWKFRGH

    9LGHRV

  • *RRJOH$SS(QJLQH*RRJOH&ORXG3ODWIRUP

    1HHGPRUHSRZHU"

    *RRJOH$SS(QJLQHPD\EHWKHDQVZHU &RGHLQ3\WKRQ-DYD*RRU3+3DQGRWKHUV 1RQHHGWRZRUU\DERXWKDUGZDUHLQVWDQFHV90V 1RQHHGWRZRUU\DERXWZHERUGDWDEDVHVHUYHUV

  • 7KDQN\RX4$

    :HVOH\&KXQZHVFDSL#JRRJOHFRP

    'HYHORSHU$GYRFDWH*RRJOH#ZHVFS\

    JRRJOHFRP:HVOH\&KXQFRUHS\WKRQFRP

    'HYHORSHUV