Learning Google Apps Script : customize and automate Google applications using Apps Script / Ramalingam Ganapathy.

Format:

Book

Author/Creator:

Ganapathy, Ramalingam, author.

Series:

Community experience distilled.

Community experience distilled

Language:

English

Subjects (All):

Google Apps.

Application software.

Cloud computing.

Physical Description:

1 online resource (232 p.)

Edition:

1st edition

Place of Publication:

Birmingham : Packt Publishing, 2016.

System Details:

text file

Biography/History:

Ganapathy Ramalingam: 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.

Summary:

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.

Contents:

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

Notes:

Includes index.

Description based on online resource; title from PDF title page (ebrary, viewed July 4, 2016).

ISBN:

9781785882456

1785882457

OCLC:

945736580