Book description
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 building real-world solutions
Who This Book Is For
Newbies to google apps script but having practical experience in Javascript.
What You Will Learn
- Learn about the Google Apps script platform and work with scripts to develop Google apps
- Create custom menus and dialogs
- Parse and send emails
- Generate Google calendar events
- Build Translator and RSS reader applications
- Develop interactive web pages
- Design interactive web-forms
- Form a workflow application
In Detail
Google Apps Script is a cloud-based scripting language based on JavaScript to customize and automate Google applications.
Apps Script makes it easy to create and publish add-ons in an online store for Google Sheets, Docs, and Forms.
It serves as one single platform to build, code, and ultimately share your App on the Web store.
This book begins by covering the basics of the Google application platform and goes on to empower you to automate most of the Google applications.
You will learn the concepts of creating a menu, sending mails, building interactive web pages, and implementing all these techniques to develop an interactive Web page as a form to submit sheets
You will be guided through all these tasks with plenty of screenshots and code snippets that will ensure your success in customizing and automating various Google applications
This guide is an invaluable tutorial for beginners who intend to develop the skills to automate and customize Google applications
Style and approach
An easy-to-follow yet comprehensive guide, filled with many code examples and screenshots illustrating various Google Apps scripts.
Table of contents
-
Learning Google Apps Script
- Table of Contents
- Learning Google Apps Script
- Credits
- About the Author
- About the Reviewer
- www.PacktPub.com
- Preface
- 1. Introducing Google Apps Scripts
- 2. Creating Basic Elements
-
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
-
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
- 5. Creating Google Calendar and Drive Applications
- 6. Creating Feed Reader and Translator Applications
- 7. Creating Interactive Webpages
- 8. Building a Workflow Application
- 9. More Tips and Tricks and Creating an Add-on
- Index
Product information
- Title: Learning Google Apps Script
- Author(s):
- Release date: March 2016
- Publisher(s): Packt Publishing
- ISBN: 9781785882517
You might also like
book
Google Apps Script, 2nd Edition
Learn how to create dynamic web applications with Google Apps Script and take full advantage of …
video
Google Apps Script Complete Course - Beginner to Advanced
This course will take you on a journey where you'll learn to power up your Google …
book
Google Apps Script for Beginners
Building on your basic JavaScript knowledge, this book takes you into the world of Google Apps …
video
Google Apps Script for Beginners
Google Apps Script is a scripting language used in conjunction with Google web-based applications (Google Docs, …