Learning Google Apps Script

Key Features

• 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

Book Description

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

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

About the Author

Ramalingam Ganapathy is an independent computer software professional with more than 15 years of working experience of JavaScript and Google Apps Script. In 1985, he started his career as a digital electronic circuit designer and service engineer. Highly interested in reading technical books and building electronic projects, he is a detail-oriented and logical person. Since 2001, he has been freelancing with Elance and Upwork (formerly oDesk). He earned a good reputation on the Upwork portal, and most of his clients are satisfied.

Table of Contents

1. Introducing Google Apps Scripts
2. Creating Basic Elements
3. Parsing and Sending E-mails
4. Creating Interactive Forms
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