PacktLib: Google Apps Script for Beginners

Google Apps Script for Beginners

Credits

About the Author

About the Reviewers

www.PacktPub.com

Preface

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

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

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

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

Embedding Scripts in Google Sites

Site gadget's limitations/restrictions/use cases

Creating and maintaining sites with Google Apps Script

Creating pages

Interactivity

Summary

Standalone Web Applications / User Interfaces

UI or not UI, that's the question

Limiting user access

Protecting your data (and your script)

Summary

Using User Interfaces in Spreadsheets and Documents

Pop ups

Sidebars

Summary

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

Conclusion

Development perspectives

Google's secrets

Personal point of view

Index