Learning Google Apps Script customize and automate Google applications using Apps Script
Customize and automate Google Applications using Apps Script About This Book Gain insight into customizing and automating Google applications with JavaScript Create add-ons for Google Sheets, Docs, or Forms; automate your workflow; integrate with external APIs; and more. A step-by-step guide to buil...
| Otros Autores: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Birmingham :
Packt Publishing
2016.
|
| Edición: | 1st edition |
| Colección: | Community experience distilled.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009630153706719 |
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
- Using optional parameters with the UrlFetchApp class
