Free Sample
+ Collection

Google Apps Script for Beginners

Beginner's Guide
Serge Gabet

Building on your basic JavaScript knowledge, this book takes you into the world of Google Apps Script and shows you how to develop and customize your own apps. The step-by-step approach provides all the necessary skills.
$17.99
$29.99
RRP $17.99
RRP $29.99
eBook
Print + eBook

Want this title & more?

$12.99 p/month

Subscribe to PacktLib

Enjoy full and instant access to over 2000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.

Book Details

ISBN 139781783552177
Paperback178 pages

About This Book

  • Quickly develop exciting Google scripts using JavaScript
  • Effortlessly manage your web applications and user interfaces
  • Build your own applications progressively with the help of real world examples and scenarios

Who This Book Is For

If you are an application developer with no knowledge of App Script, and would like to learn to build apps using Google Apps script from scratch, then this book is for you. Basic JavaScript knowledge is required.

Table of Contents

Chapter 1: Enhancing Spreadsheets
Spreadsheet functions versus Google Apps Script – how to choose?
Using the development environment – the script editor
Custom spreadsheet functions
Formatting your spreadsheets automatically
Reading and writing data from spreadsheets – best practices and performances
Catching events
Who is doing what? Script authorizations
Protecting your data
Publishing your data on the Web
Printing and exporting the result
Summary
Chapter 2: Create and Manipulate Forms
What tools do we have?
Forms' limitations
Handling answers
Forms' alternatives
A quick peek at the UiApp and HTML services
Summary
Chapter 3: Managing an E-mail Account
Retrieving Gmail data
Creating labels
Counting, sorting, archiving, and deleting e-mails and threads
Creating e-mail messages
Automating a complete workflow
Summary
Chapter 4: Embedding Scripts in Text Documents
What can be done
Generating a Google document from spreadsheet data using a script
Analyzing, duplicating, and modifying document elements
Using a script to insert an image into a document
Compiling and presenting data from other services
Summary
Chapter 5: Embedding Scripts in Google Sites
Site gadget's limitations/restrictions/use cases
Creating and maintaining sites with Google Apps Script
Creating pages
Interactivity
Summary
Chapter 6: Standalone Web Applications / User Interfaces
UI or not UI, that's the question
Limiting user access
Protecting your data (and your script)
Summary
Chapter 7: Using User Interfaces in Spreadsheets and Documents
Pop ups
Sidebars
Summary
Chapter 8: How to Expand your Knowledge
JavaScript versus Google Apps Script
Infinite resources
Being a newbie is, by definition, temporary
Try to find your own best learning method
Summary
Chapter 9: Conclusion
Development perspectives
Google's secrets
Personal point of view

What You Will Learn

  • Get acquainted with the tools you have at hand
  • Exchange and communicate information between Google services
  • Build a private website using your private files
  • Construct a web app that really helps you at work
  • Solve common issues when using shared documents
  • Embed scripts and text documents in Google sites
  • Know where to find the information you will need to go further

In Detail

Google Apps Script is a JavaScript-based programming language that works on the cloud and is 100% free to use. It provides all the tools necessary for Google services to work. Users can easily transfer any data from one service to another, save their important e-mails as files, save and share files with anybody, and even build their own website. It’s a great way of allowing people with minimal technical knowledge to create great solutions for their company.

This book is a practical hands-on guide which is presented and explained with working examples to help you get started with Google Apps Script. You will create custom functions in your spreadsheets, design your own forms, filter your emails, and publish web applications that you can use every day.

You are going to be part of a great journey from basic spreadsheet functionality and customization to fully automated workflows; all of this almost seamlessly and without complications.

On your way, you will filter your e-mails, create your forms, calculate all sorts of parameters, and be able to share just about anything that can be shared; all of this with the power of Google Apps Script at your fingertips. You will learn to embed scripts and text documents in Google sites, and will also be taken through standalone applications and user interfaces. The book ends with some tips and tricks to expand your knowledge.

Authors

Read More