관리 메뉴

ClemensKim - kyj909

[구글앱스크립트]google apps script 본문

IT/구글앱스(Google Apps)

[구글앱스크립트]google apps script

kyj909 2014. 4. 21. 06:43

구글앱스스크립트(Google apps script) 를 정리

+ Google Script - Enterprise Application Essentials

  :기본적으로 이거 한번은 봐줘야 한다. 물론 없어진 기능들이 있긴하지만 대충 보면 감잡는데 도움이 많이 된다.

그리고 신규 도서들이 새로 나왔다. 그것도 두권씩이나..ㅠ,.ㅠ 

-----------------------------------------------------------------------------------------------

Google Apps Script for Beginners 

[PACKT]

http://www.packtpub.com/google-apps-script-for-beginners/book

Table of Contents

Preface

Chapter 1: Enhancing Spreadsheets

Chapter 2: Create and Manipulate Forms

Chapter 3: Managing an E-mail Account

Chapter 4: Embedding Scripts in Text Documents

Chapter 5: Embedding Scripts in Google Sites

Chapter 6: Standalone Web Applications / User Interfaces

Chapter 7: Using User Interfaces in Spreadsheets and Documents

Chapter 8: How to Expand Your Knowledge

Chapter 9: Conclusion

Index


Chapter 1: Enhancing Spreadsheets

Spreadsheet functions versus Google Apps Script – how to choose?

An example

The spreadsheet-formula approach

The Google Apps Script approach – a few comments

The Google Apps Script approach – the code

Using the development environment – the script editor

The advantages of autocompletion

Reading the documentation

Custom spreadsheet functions

Formatting your spreadsheets automatically

Menus and custom buttons in spreadsheets

Reading and writing data from spreadsheets – best practices and performances

Example

Catching events

Who is doing what? Script authorizations

Protecting your data

Publishing your data on the Web

Printing and exporting the result

Summary


Chapter 2: Create and Manipulate Forms

What tools do we have?

Forms' limitations

Handling answers

Forms' alternatives

A quick peek at the UiApp and HTML services

Summary


Chapter 3: Managing an E-mail Account

Retrieving Gmail data

Creating labels

Counting, sorting, archiving, and deleting e-mails and threads

Execution time versus time limit

Creating e-mail messages

Automating a complete workflow

Summary


Chapter 4: Embedding Scripts in Text Documents

What can be done

Generating a Google document from spreadsheet data using a script

Analyzing, duplicating, and modifying document elements

Using a script to insert an image into a document

Compiling and presenting data from other services

Summary


Chapter 5: Embedding Scripts in Google Sites

Site gadget's limitations/restrictions/use cases

Creating and maintaining sites with Google Apps Script

Creating pages

Interactivity

Summary


Chapter 6: Standalone Web Applications / User Interfaces

UI or not UI, that's the question

Common concepts to all web apps

Building an efficient UI

Building a good-looking UI

Building an amazing UI

Limiting user access

Protecting your data (and your script)

Summary


Chapter 7: Using User Interfaces in Spreadsheets and Documents

Pop ups

Sidebars

Summary


Chapter 8: How to Expand Your Knowledge

JavaScript versus Google Apps Script

Infinite resources

Being a newbie is, by definition, temporary

Try to find your own best learning method

Summary


Chapter 9: Conclusion

Development perspectives

Google's secrets

Personal point of view

Up

Index 


우선 일단 목차만 봤을때는 초보 입문서이다. 물론 내용은 확인 못해봤다...ㅠ,.ㅠ 살돈 없음.ㅋㅋ

대충 다 아는 내용들이 목차에 나와있어 그닥 도움이 되지는 못할것 같음...고급내용들은 없는듯.

그렇다고 내말만 너무 듣지 마시길, 본인은 그냥 목차만 보고 판단할뿐 내용은 모르오.

-----------------------------------------------------------------------------------------------

그리고 아래 책인데.....

Google Apps Script, 2nd Edition

http://www.hanbit.co.kr/ebook/look.html?isbn=9781491946183#binfo7

Google Apps Script

Preface

Who Should Read This Book

What You Will Need

Conventions Used in This Book

Using Code Examples


How to Contact Us

I. Understanding Google Apps Script

1. First Steps in Google Apps Script

2. Setting Up Your Development Environment

3. Building an Interface

4. Adding Actions

II. Building Enterprise Applications

5. Dynamic Details: A Sites App Using HTML, CSS, and jQuery

6. Automate Your Forms and Templates: A Web App for Drive

7. Collecting Data: A UiApp-Style Web App

8. Document Workflows

9. Mashup

Index


이책이 Google Script - Enterprise Application Essentials 의 연장선상인지는 잘 모르겠어..

그런데 역시나 이것도 못봄...ㅠ,.ㅠ 젠장...어여 돈벌어서 책바야 하는뎅...뭐여튼 여기서 내가 가장 흥미있는 부분은 

목차 5,6,7 이 굉장히 궁금하긴해...물론 다 아는데....그건 내가 스스로 터득하고 알아낸것들이고, 책이 나오기 한참전에 알던 내용이라. 과연 내가 아는 내용과 어떻게 틀린지가 궁금할뿐...

뭐 서점에 비치 되어있으면 홀랑 보고 오고 싶은데....없는거 같아...ㅠ,.ㅠ 완전 도둑놈 심뽀? 그렇다고 내용도 모르고 덥썩 구매할순 없잖아? ㅠ,.ㅠ 

아무튼 이책인 굉장히 끌리긴해...물론 우리나라에 구글앱스스크립트 개발자가 몇명이나 되는지는모르지만. 여태 내주변에서는 한명도 못봄. 그리고 샘플프로그램도 못봄. 그만큼 시장이 작은건가? 일단 더 말은 안함.

----------------------------------------------------------------------------------


기타 참고 자료 : 

기본설명(나름 쉽게 설명)
http://torchtech.law.nyu.edu/wp-content/uploads/2013/05/GoogleAppsScript-_ArunNagarajan.pdf


Scripting Google Apps for Business Process Automation
https://dl.google.com/googleio/2010/enterprise-scripting-google-apps-for-business-process-automation.pdf


일단 정리끝.... 아 참고로 
아래 웹사이트는 기본적으로 봐야 한다는것은 기본 전재야... 그래도 문서가 부실한건 여태 고쳐지지 않았지만서도
없는것보다는 낳잖아? ㅠ,.ㅠ 
https://sites.google.com/site/scriptsexamples/



0 Comments
댓글쓰기 폼