Google Apps Script for Beginners

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.

Serge INSAS has spent a whole part of his life manufacturing sound equipment for professional audio recording. Using 8 bit microcontrollers and analog electronics did not lead him to JavaScript, but his curiosity and the need to simplify some day-to-day tasks ignited his desire to explore the language.

After a few months of trial and error, he began to use his new skills to help others on the Google Apps script forum and quickly became a Google Top Contributor. He has developed enough expertise to use Google Apps Script in many aspects of his life.

Presently, he works for a cinema upper school in Belgium and a great part of this job is to create and maintain all the IT tools they use.