Kickstart Google Apps Script

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.

Who is this book for?

This book is tailored for developers, tech-savvy professionals, and Google Workspace users looking to automate tasks and build custom workflows with Google Apps Script. While accessible to beginners, a basic understanding of programming concepts will help readers get the most out of it.

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

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.

Dmitry frequently speaks at various events—from major conferences such as Google Cloud Next to community-focused gatherings such as Google DevFests and Google Workspace Developer Summits—where he shares valuable, experience- based patterns that significantly reduce development time.

ABOUT TECHNICAL REVIEWER

Shivaji Bodkhe is a cloud transformation expert and automation specialist with over 9 years of experience across Google Workspace, Apps Script, AppSheet, and Microsoft 365. His expertise lies in modernizing enterprise IT environments through no-code/low-code solutions, secure SaaS adoption, and scalable automation practices.

Shivaji has delivered impactful technology solutions at organizations such as Okta, Airbus, GlobalFoundries, Genpact, and Searce (including projects for Flipkart, and Titan), where he led initiatives to decommission legacy systems,

migrate to cloud platforms, and build intelligent bots and support tools. His work spans sectors including aerospace, pharma, semiconductors, and retail—empowering teams through secure collaboration and AI integration. With over 750 no-code/low-code solutions delivered, more than 1000+ legacy apps replaced, and 100+ security audits under his belt, Shivaji brings deep technical insight and practical problem-solving to every project.