Embedding Scripts in Text Documents | 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 4. Embedding Scripts in Text Documents

In the previous chapter, through the example of compiling the boss' e-mails, we learned that Google documents can have embedded scripts just like spreadsheets or forms do.

This example use case could well have been implemented in a spreadsheet and in some aspects, it probably would have been easier, but the reason was more an aesthetic choice; in spreadsheets there is an absence of grid and cell limitations and the ability to customize the appearance with styles and colors.

That is only a small example of what can be done in Google documents.

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