Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Advanced Search Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Learning Google Apps Script
  • Table Of Contents Toc
  • Feedback & Rating feedback
Learning Google Apps Script

Learning Google Apps Script

By : Ganapathy
3 (6)
Buy this Book
close
close
Learning Google Apps Script

Learning Google Apps Script

3 (6)
By: Ganapathy
Buy this Book

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
Table of Contents (11 chapters)
close
close
close
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
1. Introducing Google Apps Scripts
chevron up
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
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
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
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
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
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
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
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
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
10
Index
Index

Google Drive

Google Drive is a file storage application, which from now on we will just refer to as "Drive", where you can store and synchronize your files on Google's server. Let's look at some of the advantages of using Drive:

  • You can edit and share Google Docs, Sheets, and Forms with your friends or collaborators in real time.
  • You can even stop editing a document on one of your desktops and continue with your smartphone or tablet, and vice versa, no matter where you are and what device you are using. This is possible because your files are stored on Google's Cloud server.
  • Files created with Google Apps are stored in Drive with Google's native formats and extensions. For example, Google Docs (documents) files are .gdoc, Google Sheets (spreadsheets) are .gsheet, and so on.
  • In addition to Google's native files, you can also store or upload any other type of file from your desktop to Google Drive.

    Note

    If you would like to synchronize files on your computer or devices with Drive, then you can install special software called Google Drive Client Application. While this application is running on your computer or device, it synchronizes files stored locally with the same files in Drive.

You may be wondering, what is the purpose of synchronizing files? Sometimes you may need to, or someone may ask you to, parse a CSV file stored on a desktop using GAS to process the data and organize it into a Sheet. In this case, GAS won't execute on the desktop, but it can on the Google server. This way you can access your Drive files and parse data within your synchronized CSV file. You don't have to upload the CSV file manually every time to Drive.

The following screenshot shows the Drive folder view:

Google Drive
End of Section 4
Next Section
bookmark search playlist font-size

Change the font size

margin-width

Change margin width

day-mode

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Delete Bookmark

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY