8. Building a Workflow Application | Learning Google Apps Script

Sign In Start Free Trial

Book Overview & Buying
Table Of Contents
Feedback & Rating

Learning Google Apps Script

By : Ganapathy

3 (6)

Learning Google Apps Script

3 (6)

By: Ganapathy

Overview of this book

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

Preface

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Free Chapter

1. Introducing Google Apps Scripts

1. Introducing Google Apps Scripts

Google Applications

Google Apps Script

Google Drive

Gmail

Google Calendar

Google Docs

Google Sheets

Google Apps services

Script projects

Google Forms

Summary

2. Creating Basic Elements

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

3. Parsing and Sending E-mails

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

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

5. Creating Google Calendar and Drive Applications

The CalendarApp class

Enabling advanced Google services

The DriveApp class

Summary

6. Creating Feed Reader and Translator Applications

6. Creating Feed Reader and Translator Applications

The UrlFetchApp class

RSS and Atom feeds

The LanguageApp class

Creating a document reviewing and instant inline commenting application

Summary

7. Creating Interactive Webpages

7. Creating Interactive Webpages

Creating a web app to render Sheet data as HTML

Creating a web app to return JSON

Converting Sheet data as a PDF file

Sending an HTTP/HTTPS request with query string

Creating RSS feed using ContentService

Creating a file upload application

Creating an employee timesheet application

Summary

8. Building a Workflow Application

8. Building a Workflow Application

Order processing workflow – steps explained

Configuring Google Sheets

Creating the Order form

Enhancing the Order form

Creating the dispatch form

Dispatching the articles

Enabling the user to acknowledge the article delivery

Summary

9. More Tips and Tricks and Creating an Add-on

9. More Tips and Tricks and Creating an Add-on

Overcoming the "script exceeded maximum execution time" error

Configuring your script project to use external libraries

Using JSDoc annotations

Using the OAuth open source library

Creating, testing, and publishing add-ons

Other useful links

Summary

Index

Index

Customer Reviews

3 (6)

5 star

33.3%

4 star

16.7%

3 star

0%

2 star

16.7%

1 star

33.3%

Enhancing the Order form

To enhance the Order form, update the doGet function as follows:

function doGet(){
  var template = HtmlService.createTemplateFromFile("Order");
  template.pricelist = getPrice();

  var html = template.evaluate();
  return HtmlService.createHtmlOutput(html);
}

The price list is assigned to the template as a 2-dimensional array and is returned by the function shown here:

function getPrice(){
  var data = SheetStock.getDataRange().getValues();
  
  // remove header row.
  data.shift();

  return data;
}

In the Order.html file, update the select tag markup as shown in this code snippet:

<td>
  <select id="item" name="item">
    <? for(var i in pricelist){ ?>
      <option value="<?= pricelist[i][0] ?>" > <?= pricelist[i][0] ?></option>
    <? } ?>
  </select>
</td>

The drop-down items will reflect whatever is included or updated in the Stock Sheet. The default item will be the top-most or the first item in the list...

Visually different images

CONTINUE READING

83

Tech Concepts

36

Programming languages

73

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

Learning Google Apps Script

Search

Your notes and bookmarks