Let’s Learn Google Apps Script: Customize and Automate Google Applications using Apps Script
- Length: 235 pages
- Edition: 2
- Language: English
- Publication Date: 2021-07-25
- ISBN-10: B09B85LV46
- Sales Rank: #0 (See Top 100 Books)
Google Apps is a collection of applications, namely, Gmail, Calendar, Drive, Docs, Sheets, and Forms. You can customize or automate Google Apps using the scripting language JavaScript with Google’s defined classes. Google implements Google Apps Script (GAS) based on JavaScript.
Almost all Google Apps provide one or more services. GAS services and APIs provide easy access to automate tasks across Google products and third-party services. You can use these service classes in your GAS code to customize or automate Google Apps.
This book introduces basic things first before moving to advanced concepts step by step with practical code and examples. By reading this book, you’ll gather expertise in Google Apps Script. Happy reading!
Chapter 1: Introducing Google Apps Scripts 1 Google Applications 1 Google Apps Script 2 Visual Basic for Applications 2 The advantages of GAS over VBA 3 The limitations of GAS 3 Google Drive 3 Gmail 4 Google Calendar 6 Google Docs 6 Google Sheets 6 Google Apps services 6 Creating Google Sheets in Drive and sharing them with your friends and the public 7 Script projects 9 Creating standalone script projects 9 Creating new projects in Sheets 11 Creating a custom formula in Sheets 12 Google Forms 14 Creating Forms within Google Sheet 14 Some research 15 Chapter 2: Creating Basic Elements 17 Creating a clickable button 17 Showing toast when a button is clicked 22 Creating a custom menu 22 Creating a sidebar 24 Creating an Add-ons menu 25 Creating a modal dialog 27 Creating a modeless dialog 28 Debugging your script 28 Summary 31 Chapter 3: Parsing and Sending E-mails 33 Creating Gmail Contacts by script 33 Accessing Sheet, cell, range, and offset 34 Reading and writing the Sheet data 35 Building a Gmail Contact search application 35 Building the Gmail parser application 40 Properties service 41 Downloading Gmail attachments to Drive 41 Sending e-mails using the MailApp service 44 Sending an e-mail notification on Form submission 44 Creating triggers manually 46 Creating and deleting triggers by script 47 Forwarding e-mails if the specific keyword is found in the message body 48 Sending e-mail with attachments 49 Embedding inline images in an e-mail message 50 Building an e-mail merger application 50 Summary 53 Chapter 4: Creating Interactive Forms 55 Creating Forms using script 55 Publishing the script as a web application 60 HtmlService 62 Creating a Form using HtmlService 63 Submitting form using Google script API method 67 Creating forms using add-ons CSS and jQuery libraries 70 Creating an e-voting application 72 Creating a ticket reservation application 76 Chapter 5: Creating Google Calendar and Drive Applications 81 The CalendarApp class 81 Creating Calendar events from a simple description 81 Creating simple Calendar events 82 Creating events with options 82 Creating events from Sheets data 83 Creating events from an external CSV file's contents 84 Enabling advanced Google services 86 Listing all the Calendars 88 Listing Calendar events in Sheets 89 Syncing events from one Calendar to another Calendar 91 The DriveApp class 95 Creating customized PDF files 95 Creating a Drive file routing application 98 Creating a Drive file search application 100 Summary 104 Chapter 6: Creating Feed Reader and Translator Applications 105 The UrlFetchApp class 105 Creating a Google search application 108 Creating a stock quote ticker application 110 Logging Bitcoin quotes 113 RSS and Atom feeds 115 Skeleton of a RSS feed document 116 Creating an RSS reader application 117 Skeleton of an Atom feed document 118 Creating an Atom feed reader application 119 Using optional parameters with the UrlFetchApp class 121 The LanguageApp class 121 Creating the language translator application 122 Creating a document reviewing and instant inline commenting application 131 Summary 140 Chapter 7: Creating Interactive Webpages 141 Creating a web app to render Sheet data as HTML 142 Creating a web app to return JSON 144 Converting Sheet data as a PDF file 146 Sending an HTTP/HTTPS request with query string 148 Creating RSS feed using ContentService 150 Creating a file upload application 152 Creating an employee timesheet application 155 Summary 165 Chapter 8: Building a Workflow Application 167 Order processing workflow – steps explained 168 Configuring Google Sheets 169 Creating the Order form 171 Enhancing the Order form 174 Creating the dispatch form 183 Dispatching the articles 187 Enabling the user to acknowledge the article delivery 188 Summary 190 Chapter 9: More Tips and Tricks and Creating an Add-on 191 Overcoming the "script exceeded maximum execution time" error 191 Configuring your script project to use external libraries 194 Using JSDoc annotations 196 Using the OAuth open source library 197 Creating, testing, and publishing add-ons 198 Installing add-ons from Chrome Web Store 198 Creating custom add-ons 199 Testing your add-on 200 Creating an add-on that uses an OAuth2 external library 201 Other useful links 209 Index 211
Donate to keep this site alive
1. Disable the AdBlock plugin. Otherwise, you may not get any links.
2. Solve the CAPTCHA.
3. Click download link.
4. Lead to download server to download.