Unlock the Power of Google Apps Script for Automation and Integration.
Key Features
? Learn to streamline and automate tasks across Gmail, Sheets, Docs, Drive, Forms, and Calendar.
? Build custom and dynamic User Interfaces (UIs) with HTML Service and Card Service.
? Master triggers and APIs for seamless Google Workspace integration.
Book Description
Google Apps Script is the powerful engine behind Google Workspace automation - driving efficiency, reducing manual work, and enabling customized workflows across Gmail, Sheets, Docs, Drive, Forms, and Calendar.
Kickstart Google Apps Script takes you on a structured journey from the ground up. You’ll start with a modern JavaScript refresher tailored for the Apps Script environment, and then dive into script types such as container-bound vs. standalone scripts to understand their use cases. With these basics in place, you'll move into core Google services: SpreadsheetApp, GmailApp, DriveApp, FormsApp, CalendarApp, SlidesApp, and DocsApp, learning how to read, write, and automate across them with real-world examples.
Next, you'll unlock more advanced capabilities: building custom user interfaces using the HTML and Card Services, deploying web apps, and setting up time-based and event-driven triggers. The final chapters focus on integrating external services using APIs and webhooks, and consolidating your learning with hands-on exercises and solutions.
By the end, you'll not only understand how to automate and enhance your Google Workspace tools but you'll be empowered to build full-scale, production-ready solutions. Start coding smarter, streamline your workflows, and transform your daily operations—one script at a time.
What you will learn
? Automate Gmail workflows and manage email inboxes with custom scripts.
? Create, read, write, and format Google Sheets data programmatically.
? Create and update Google Docs content with dynamic scripting.
? Organize and manipulate Google Drive files using Apps Script.
? Build, customize, manage and analyze responses from Google Forms.
? Schedule and automate Google Calendar events and reminders with ease.
Table of Contents
1. Introduction to Modern JavaScript in the Online Editor
2. Container-Bound versus Stand-Alone Scripts
3. SpreadsheetApp
4. GmailApp
5. DriveApp
6. FormApp
7. CalendarApp
8. SlidesApp
9. DocumentApp
10. Triggers
11. User Interfaces
12. Web Apps
13. APIs and Web Hooks
14. Exercises and Solutions
Index
About the Authors
Dmitry Kostyuk is a recognized Google Developer Expert for both Google Workspace and Cloud technologies. He is the founder of Wurkspaces.dev OÜ, a consultancy specializing in transforming disorganized spreadsheets and scattered documents into efficient, code-driven workflows that teams depend upon.
Writing and instruction are central to Dmitry's expertise. His articles, such as notable pieces such as "Steer Clear of These onEdit Traps in Google Apps Script: Top 3 Tips!", "Google Sheets Meets Game of Life: My Google Apps Script Adventure", and "Service Accounts & OAuth2 in Google Apps Script: Your A-Z Guide ??", are widely read. These publications complement his popular FOSS project, Apps Script Engine — a comprehensive GitHub starter kit encompassing frameworks, developer tools, and CI/CD scaffolding, among other contributions.
