Google Apps Script for Beginners

Google Apps Script for Beginners
eBook: $17.99
Formats: PDF, PacktLib, ePub and Mobi formats
save 15%!
Print + free eBook + free PacktLib access to the book: $47.98    Print cover: $29.99
save 37%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Table of Contents
Sample Chapters
  • 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

Book Details

Language : English
Paperback : 178 pages [ 235mm x 191mm ]
Release Date : February 2014
ISBN : 1783552174
ISBN 13 : 9781783552177
Author(s) : Serge Gabet
Topics and Technologies : All Books, Other, Web Development

Table of Contents

Chapter 1: Enhancing Spreadsheets
Chapter 2: Create and Manipulate Forms
Chapter 3: Managing an E-mail Account
Chapter 4: Embedding Scripts in Text Documents
Chapter 5: Embedding Scripts in Google Sites
Chapter 6: Standalone Web Applications / User Interfaces
Chapter 7: Using User Interfaces in Spreadsheets and Documents
Chapter 8: How to Expand Your Knowledge
Chapter 9: Conclusion
  • Chapter 1: Enhancing Spreadsheets
    • Spreadsheet functions versus Google Apps Script – how to choose?
      • An example
        • The spreadsheet-formula approach
        • The Google Apps Script approach – a few comments
        • The Google Apps Script approach – the code
    • Using the development environment – the script editor
      • The advantages of autocompletion
      • Reading the documentation
    • Custom spreadsheet functions
    • Formatting your spreadsheets automatically
      • Menus and custom buttons in spreadsheets
    • Reading and writing data from spreadsheets – best practices and performances
      • Example
    • Catching events
    • Who is doing what? Script authorizations
    • Protecting your data
    • Publishing your data on the Web
    • Printing and exporting the result
    • Summary
  • Chapter 3: Managing an E-mail Account
    • Retrieving Gmail data
    • Creating labels
    • Counting, sorting, archiving, and deleting e-mails and threads
      • Execution time versus time limit
    • 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

Serge Gabet

Serge Gabet has been a professional audio equipment manufacturer for 20 years and is now working for an artistic upper school in Brussels, Belgium as a teacher and Technical Manager. He is also in charge of the Google Apps administration of this school. He develops custom applications using Google Apps Script mainly for his school, though he also works in other areas. He has been designated a Top Contributor by Google since June 2011. He was active on the Google Group Help forum till 2012, then on the Stack Overflow forum (the Google Help Group forum was closed in June 2012), and became a first ranker and an all-time contributor on the Stack Overflow forum a few months back.

Code Downloads

Download the code and support files for this book.

Submit Errata

Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.

Sample chapters

You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.

Frequently bought together

Google Apps Script for Beginners +    Mastering Object-oriented Python =
50% Off
the second eBook
Price for both: $31.95

Buy both these recommended eBooks together and get 50% off the cheapest eBook.

What you will learn from this book

  • 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.


This book is a simple step-by-step, example-oriented guide with a focus on providing the practical skills necessary to develop and customize apps with Apps Script.

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.

Code Download and Errata
Packt Anytime, Anywhere
Register Books
Print Upgrades
eBook Downloads
Video Support
Contact Us
Awards Voting Nominations Previous Winners
Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software