Conclusion | Google Apps Script for Beginners

Sign In Start Free Trial

Book Overview & Buying
Table Of Contents

Google Apps Script for Beginners

By : Serge Gabet

3.5 (15)

Google Apps Script for Beginners

3.5 (15)

By: Serge Gabet

Overview of this book

Google Apps Script for Beginners

Google Apps Script for Beginners

Credits

Credits

About the Author

About the Author

About the Reviewers

About the Reviewers

www.PacktPub.com

www.PacktPub.com

Preface

Preface

Free Chapter

Enhancing Spreadsheets

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

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

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

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

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

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

Using User Interfaces in Spreadsheets and Documents

Pop ups

Sidebars

Summary

How to Expand your Knowledge

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

Conclusion

Development perspectives

Google's secrets

Personal point of view

Index

Index

Chapter 9. Conclusion

If you have reached this part of the book, I would assume you have read eight chapters and have quite a good view of what you can do with Google Apps Script. However, you have to know that all this is just a part of it—a small part actually.

I did present a few examples of data exchange between different Google services (docs and spreadsheets, Gmail and docs, and so on), but there is definitely much more to explore. This book could easily have over 500 pages without too much effort, but as the title states, this book just provides a few samples to help you to get started.

Visually different images

CONTINUE READING

83

Tech Concepts

36

Programming languages

73

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

Google Apps Script for Beginners

Search

Your notes and bookmarks