Google Apps Script, 2nd Edition

Learn how to create dynamic web applications with Google Apps Script and take full advantage of your Google-hosted services. If you have basic coding skills and some JavaScript experience, this practical book shows you how Apps Script works, and provides step-by-step guidance for building applications you can use right away.

Apps Script is handy for automating Google Apps tasks, but it also serves as a complete application platform. With this book, you’ll learn how to build, store, run, and share data-driven web apps right on Google Drive. You’ll have access to complete code and working examples that show you how everything fits together.

• Build an interactive Web App UI that runs on most web and mobile browsers
• Create a sample product catalog that displays custom data from a spreadsheet
• Develop an application to generate web forms from templates
• Use Apps Script to build a simple web-based database application
• Design a document workflow builder that users can quickly customize
• Create a Google form that lets you select and send email responses
• Debug your code and keep track of script problems after deployment

Table of Contents

Part I. Understanding Google Apps Script
Chapter 1. First Steps in Google Apps Script
Chapter 2. Setting Up Your Development Environment
Chapter 3. Building an Interface
Chapter 4. Adding Actions

Part II. Building Enterprise Applications
Chapter 5. Dynamic Details: A Sites App Using HTML, CSS, and jQuery
Chapter 6. Automate Your Forms and Templates: A Web App for Drive
Chapter 7. Collecting Data: A UiApp-Style Web App
Chapter 8. Document Workflows
Chapter 9. Mashup