Book Image

Google Apps Script for Beginners

By : Serge Gabet
Book Image

Google Apps Script for Beginners

By: Serge Gabet

Overview of this book

Related Content you might be interested in

Current Title:

Small book image
Google Apps Script for Beginners
Serge Gabet
Feb, 2014 | 178 pages
No titles found
Table of Contents (16 chapters)
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
1
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
2
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
3
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
4
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
5
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
6
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
7
Using User Interfaces in Spreadsheets and Documents
Using User Interfaces in Spreadsheets and Documents
Pop ups
Sidebars
Summary
8
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
9
Conclusion
Conclusion
Development perspectives
Google's secrets
Personal point of view
Index
Index

Credits

Author

Serge Gabet

Reviewers

Henrique Abreu

David Bingham

Alejandro Leiva

Rohit Mukherjee

Ajith Ranabahu

Acquisition Editor

Kevin Colaco

Content Development Editor

Shaon Basu

Technical Editors

Mrunal Chavan

Sebastian Rodrigues

Copy Editors

Tanvi Gaitonde

Insiya Morbiwala

Stuti Srivastava

Project Coordinator

Harshal Ved

Proofreaders

Simran Bhogal

Stephen Copestake

Indexer

Monica Ajmera Mehta

Production Coordinator

Nitesh Thakur

Cover Work

Nitesh Thakur

Previous Section
Next Chapter