更新时间：2021-07-19 18:14:34
coverpage
Google Apps Script for Beginners
Credits
About the Author
About the Reviewers
www.PacktPub.com
Support files eBooks discount offers and more
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
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
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
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
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
Chapter 6. Standalone Web Applications / User Interfaces
UI or not UI that's the question
Limiting user access
Protecting your data (and your script)
Chapter 7. Using User Interfaces in Spreadsheets and Documents
Pop ups
Sidebars
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
Chapter 9. Conclusion
Development perspectives
Google's secrets
Personal point of view
Index
