Google Apps Script for Beginners

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.
Preview in Mapt

Google Apps Script for Beginners

Serge Gabet

1 customer reviews
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.
Mapt Subscription
FREE
$29.99/m after trial
eBook
$10.00
RRP $17.99
Save 44%
Print + eBook
$29.99
RRP $29.99
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$10.00
$29.99
$29.99 p/m after trial
RRP $17.99
RRP $29.99
Subscription
eBook
Print + eBook
Start 30 Day Trial

Frequently bought together


Google Apps Script for Beginners Book Cover
Google Apps Script for Beginners
$ 17.99
$ 10.00
Full Stack Angular for Java Developers Book Cover
Full Stack Angular for Java Developers
$ 39.99
$ 10.00
Buy 2 for $20.00
Save $37.98
Add to Cart

Book Details

ISBN 139781783552177
Paperback178 pages

Book Description

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.

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

Authors

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

Book Details

ISBN 139781783552177
Paperback178 pages
Read More
From 1 reviews

Read More Reviews

Recommended for You

Learning Google Apps Script Book Cover
Learning Google Apps Script
$ 31.99
$ 10.00
Google Maps JavaScript API Cookbook Book Cover
Google Maps JavaScript API Cookbook
$ 26.99
$ 10.00
Python for Google App Engine Book Cover
Python for Google App Engine
$ 17.99
$ 10.00
Data Analysis and Business Modeling with Excel 2013 Book Cover
Data Analysis and Business Modeling with Excel 2013
$ 31.99
$ 10.00
Mastering vRealize Operations Manager Book Cover
Mastering vRealize Operations Manager
$ 44.99
$ 10.00
Mastering Grunt Book Cover
Mastering Grunt
$ 13.99
$ 9.80