Learning Google Apps Script

Summary

Other useful links

Creating testing and publishing add-ons

Using the OAuth open source library

Using JSDoc annotations

Configuring your script project to use external libraries

Overcoming the "script exceeded maximum execution time" error

Chapter 9. More Tips and Tricks and Creating an Add-on

Summary

Enabling the user to acknowledge the article delivery

Dispatching the articles

Creating the dispatch form

Enhancing the Order form

Creating the Order form

Configuring Google Sheets

Order processing workflow – steps explained

Chapter 8. Building a Workflow Application

Summary

Creating an employee timesheet application

Creating a file upload application

Creating RSS feed using ContentService

Sending an HTTP/HTTPS request with query string

Converting Sheet data as a PDF file

Creating a web app to return JSON

Creating a web app to render Sheet data as HTML

Chapter 7. Creating Interactive Webpages

Summary

Creating a document reviewing and instant inline commenting application

The LanguageApp class

RSS and Atom feeds

The UrlFetchApp class

Chapter 6. Creating Feed Reader and Translator Applications

Summary

The DriveApp class

Enabling advanced Google services

The CalendarApp class

Chapter 5. Creating Google Calendar and Drive Applications

Summary

Creating a ticket reservation application

Creating an e-voting application

Creating forms using add-ons CSS and jQuery libraries

Submitting form using Google script API method

Creating a Form using HtmlService

HtmlService

Publishing the script as a web application

Creating Forms using script

Chapter 4. Creating Interactive Forms

Summary

Building an e-mail merger application

Embedding inline images in an e-mail message

Sending e-mail with attachments

Forwarding e-mails if the specific keyword is found in the message body

Creating and deleting triggers by script

Creating triggers manually

Sending an e-mail notification on Form submission

Sending e-mails using the MailApp service

Downloading Gmail attachments to Drive

Properties service

Building the Gmail parser application

Building a Gmail Contact search application

Reading and writing the Sheet data

Accessing Sheet cell range and offset

Creating Gmail Contacts by script

Chapter 3. Parsing and Sending E-mails

Summary

Debugging your script

Creating a modeless dialog

Creating a modal dialog

Creating an Add-ons menu

Creating a sidebar

Creating a custom menu

Showing toast when a button is clicked

Creating a clickable button

Chapter 2. Creating Basic Elements

Summary

Google Forms

Script projects

Google Apps services

Google Sheets

Google Docs

Google Calendar

Gmail

Google Drive

Google Apps Script

Google Applications

Chapter 1. Introducing Google Apps Scripts

Preface

www.PacktPub.com

About the Reviewer

About the Author

Credits

版权信息

封面

封面

版权信息

Credits

About the Author

About the Reviewer

www.PacktPub.com

Preface

Chapter 1. Introducing Google Apps Scripts

Google Applications

Google Apps Script

Google Drive

Gmail

Google Calendar

Google Docs

Google Sheets

Google Apps services

Script projects

Google Forms

Summary

Chapter 2. Creating Basic Elements

Creating a clickable button

Showing toast when a button is clicked

Creating a custom menu

Creating a sidebar

Creating an Add-ons menu

Creating a modal dialog

Creating a modeless dialog

Debugging your script

Summary

Chapter 3. Parsing and Sending E-mails

Creating Gmail Contacts by script

Accessing Sheet cell range and offset

Reading and writing the Sheet data

Building a Gmail Contact search application

Building the Gmail parser application

Properties service

Downloading Gmail attachments to Drive

Sending e-mails using the MailApp service

Sending an e-mail notification on Form submission

Creating triggers manually

Creating and deleting triggers by script

Forwarding e-mails if the specific keyword is found in the message body

Sending e-mail with attachments

Embedding inline images in an e-mail message

Building an e-mail merger application

Summary

Chapter 4. Creating Interactive Forms

Creating Forms using script

Publishing the script as a web application

HtmlService

Creating a Form using HtmlService

Submitting form using Google script API method

Creating forms using add-ons CSS and jQuery libraries

Creating an e-voting application

Creating a ticket reservation application

Summary

Chapter 5. Creating Google Calendar and Drive Applications

The CalendarApp class

Enabling advanced Google services

The DriveApp class

Summary

Chapter 6. Creating Feed Reader and Translator Applications

The UrlFetchApp class

RSS and Atom feeds

The LanguageApp class

Creating a document reviewing and instant inline commenting application

Summary

Chapter 7. Creating Interactive Webpages

Creating a web app to render Sheet data as HTML

Creating a web app to return JSON

Converting Sheet data as a PDF file

Sending an HTTP/HTTPS request with query string

Creating RSS feed using ContentService

Creating a file upload application

Creating an employee timesheet application

Summary

Chapter 8. Building a Workflow Application

Order processing workflow – steps explained

Configuring Google Sheets

Creating the Order form

Enhancing the Order form

Creating the dispatch form

Dispatching the articles

Enabling the user to acknowledge the article delivery

Summary

Chapter 9. More Tips and Tricks and Creating an Add-on

Overcoming the "script exceeded maximum execution time" error

Configuring your script project to use external libraries

Using JSDoc annotations

Using the OAuth open source library

Creating testing and publishing add-ons

Other useful links

Summary