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
Icon
Preface
Icon
What this book covers
Icon
What you need for this book
Icon
Who this book is for
Icon
Conventions
Icon
Reader feedback
Icon
Customer support
Lock Free Chapter
1
1. Introducing Google Apps Scripts
Icon
1. Introducing Google Apps Scripts
Icon
Google Applications
Icon
Google Apps Script
Icon
Google Drive
Icon
Gmail
Icon
Google Calendar
Icon
Google Docs
Icon
Google Sheets
Icon
Google Apps services
Icon
Script projects
Icon
Google Forms
Icon
Summary
2
2. Creating Basic Elements
chevron up
Icon
2. Creating Basic Elements
Icon
Creating a clickable button
Icon
Showing toast when a button is clicked
Icon
Creating a custom menu
Icon
Creating a sidebar
Icon
Creating an Add-ons menu
Icon
Creating a modal dialog
Icon
Creating a modeless dialog
Icon
Debugging your script
Icon
Summary
3
3. Parsing and Sending E-mails
Icon
3. Parsing and Sending E-mails
Icon
Creating Gmail Contacts by script
Icon
Accessing Sheet, cell, range, and offset
Icon
Reading and writing the Sheet data
Icon
Building a Gmail Contact search application
Icon
Building the Gmail parser application
Icon
Properties service
Icon
Downloading Gmail attachments to Drive
Icon
Sending e-mails using the MailApp service
Icon
Sending an e-mail notification on Form submission
Icon
Creating triggers manually
Icon
Creating and deleting triggers by script
Icon
Forwarding e-mails if the specific keyword is found in the message body
Icon
Sending e-mail with attachments
Icon
Embedding inline images in an e-mail message
Icon
Building an e-mail merger application
Icon
Summary
4
4. Creating Interactive Forms
Icon
4. Creating Interactive Forms
Icon
Creating Forms using script
Icon
Publishing the script as a web application
Icon
HtmlService
Icon
Creating a Form using HtmlService
Icon
Submitting form using Google script API method
Icon
Creating forms using add-ons CSS and jQuery libraries
Icon
Creating an e-voting application
Icon
Creating a ticket reservation application
Icon
Summary
5
5. Creating Google Calendar and Drive Applications
Icon
5. Creating Google Calendar and Drive Applications
Icon
The CalendarApp class
Icon
Enabling advanced Google services
Icon
The DriveApp class
Icon
Summary
6
6. Creating Feed Reader and Translator Applications
Icon
6. Creating Feed Reader and Translator Applications
Icon
The UrlFetchApp class
Icon
RSS and Atom feeds
Icon
The LanguageApp class
Icon
Creating a document reviewing and instant inline commenting application
Icon
Summary
7
7. Creating Interactive Webpages
Icon
7. Creating Interactive Webpages
Icon
Creating a web app to render Sheet data as HTML
Icon
Creating a web app to return JSON
Icon
Converting Sheet data as a PDF file
Icon
Sending an HTTP/HTTPS request with query string
Icon
Creating RSS feed using ContentService
Icon
Creating a file upload application
Icon
Creating an employee timesheet application
Icon
Summary
8
8. Building a Workflow Application
Icon
8. Building a Workflow Application
Icon
Order processing workflow – steps explained
Icon
Configuring Google Sheets
Icon
Creating the Order form
Icon
Enhancing the Order form
Icon
Creating the dispatch form
Icon
Dispatching the articles
Icon
Enabling the user to acknowledge the article delivery
Icon
Summary
9
9. More Tips and Tricks and Creating an Add-on
Icon
9. More Tips and Tricks and Creating an Add-on
Icon
Overcoming the "script exceeded maximum execution time" error
Icon
Configuring your script project to use external libraries
Icon
Using JSDoc annotations
Icon
Using the OAuth open source library
Icon
Creating, testing, and publishing add-ons
Icon
Other useful links
Icon
Summary
10
Index
Icon
Index

Creating a clickable button

In the previous chapter, you learned how to open the script editor in Google Sheets. For this task, open the script editor in a newly created or any existing Google Sheet and follow these steps:

  1. Select cell B3 or any other cell. Click on Insert and select Drawing..., as shown in the following screenshot:

  2. A drawing editor window will open. Click on the Text box icon and then click anywhere within the canvas area. Type Click Me. Resize the object to enclose the text only, as shown in the following screenshot:

  3. Click on Save & Close to exit the drawing editor. Now, the Click Me image will be inserted into the active cell (B3), as shown in the following screenshot:

    You can drag this image anywhere around the spreadsheet except in the menu bar.

    Tip

    In Google Sheets, images are not anchored to a particular cell, and they can be dragged or moved around.

    If you click on the image, a drop-down arrow on the top-right corner will be visible:

  4. Click on the Assign script… menu item...

Visually different images
CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Learning Google Apps Script
End of Section 2
Next Section
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

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

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon