Learning Google Apps Script : customize and automate Google Applications using Apps Script /
Annotation
Clasificación: | Libro Electrónico |
---|---|
Autor principal: | |
Formato: | Electrónico eBook |
Idioma: | Inglés |
Publicado: |
Birmingham, UK :
Packt Publishing,
2016.
|
Colección: | Community experience distilled.
|
Temas: | |
Acceso en línea: | Texto completo Texto completo |
Tabla de Contenidos:
- Cover; Copyright; Credits; About the Author; About the Reviewer; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Introducing Google Apps Scripts; Google Applications; Google Apps Script; Visual Basic for Applications; The advantages of GAS over VBA; The limitations of GAS; Google Drive; Gmail; Google Calendar; Google Docs; Google Sheets; Google Apps services; Creating Google Sheets in Drive and sharing them with your friends and the public; Script projects; Creating standalone script projects; Creating new projects in Sheets; Creating a custom formula in Sheets; Google Forms
- Creating Forms within Google SheetSome research; 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 DriveSending 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 methodCreating 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; Creating Calendar events from a simple description; Creating simple Calendar events; Creating events with options; Creating events from Sheets data; Creating events from an external CSV file's contents; Enabling advanced Google services; Listing all the Calendars; Listing Calendar events in Sheets
- Syncing events from one Calendar to another CalendarThe DriveApp class; Creating customized PDF files; Creating a Drive file routing application; Creating a Drive file search application; Summary; Chapter 6: Creating Feed Reader and Translator Applications; The UrlFetchApp class; Creating a Google search application; Creating a stock quote ticker application; Logging Bitcoin quotes; RSS and Atom feeds; Skeleton of a RSS feed document; Creating an RSS reader application; Skeleton of an Atom feed document; Creating an Atom feed reader application