Going GAS: From VBA to Google Apps Script

If you’re making or investigating the transition from Microsoft Office to Google Docs, or simply trying to get started with Google automation and APIs, this practical book covers each of the major services accessible from Google Apps Script, including add-ons and integration with external services.

With a particular emphasis on how to transition from Microsoft’s Visual Basic for Applications (VBA) to Apps Script, all the common VBA functions are rewritten in JavaScript with equivalence tables for how to do it in Apps Script.

This book provides a unique transitional library of VBA built-in functions, written in Apps Script but with the same names and arguments as VBA—that means you need to make only minimal changes to VBA code when “going GAS.”

• Learn how to go from VBA to Apps Script
• Get a side-by-side comparison of Apps Script services vs Microsoft add-ins
• Access and integrate with external data from Apps Script

Table of Contents

Chapter 1. Introduction
Chapter 2. Language Basics
Chapter 3. Translating VBA Functions
Chapter 4. Living with the Quotas
Chapter 5. The Properties Service
Chapter 6. The Spreadsheet Service
Chapter 7. The Document App
Chapter 8. Gmail, Calendar, and Contacts Apps
Chapter 9. Drive and DriveApp
Chapter 10. HTML Service
Chapter 11. Content Service
Chapter 12. Charts
Chapter 13. Sites
Chapter 14. Advanced Google Services
Chapter 15. Authentication and Security
Chapter 16. External APIs and Integration
Chapter 17. Execution API
Chapter 18. Office Add-Ins and Google Add-Ons
Appendix A. Further Resources