Going GAS: From VBA to Google Apps Script

Front Cover
"O'Reilly Media, Inc.", Feb 15, 2016 - Computers - 456 pages

Whether you’re moving from Microsoft Office to Google Docs or simply want to learn how to automate Docs with Google Apps Script, this practical guide shows you by example how to work with each of the major Apps Script services.

Office still supports VBA, but it’s not likely to do so for much longer. If you’re a VBA or .NET developer, you’ll learn how to port existing VBA code and structure to their JavaScript-based Apps Script equivalents with minimal effort. Author Bruce Mcpherson introduces JavaScript basics for experienced developers unfamiliar with the language, and demonstrates ways to build real-world apps using all of the Apps Script services previously covered.

  • Use App Script’s equivalent of Excel’s object model
  • Target the most commonly used parts of Microsoft Word
  • Automate processes in Gmail, Calendar, and Contacts
  • Access the local client filesystem with Google Drive
  • Build and run applications in a browser
  • Store persistent data conveniently
  • Render HTML content in response to HTTP requests
  • Automate the maintenance and creation of pages and content
  • Interact with a REST service or NoSQL database
  • Access Apps Script capabilities from other platforms
 

What people are saying - Write a review

We haven't found any reviews in the usual places.

Selected pages

Contents

Section 1
Section 2
Section 3
Section 4
Section 5
Section 6
Section 7
Section 8
Section 19
Section 20
Section 21
Section 22
Section 23
Section 24
Section 25
Section 26

Section 9
Section 10
Section 11
Section 12
Section 13
Section 14
Section 15
Section 16
Section 17
Section 18
Section 27
Section 28
Section 29
Section 30
Section 31
Section 32
Section 33
Section 34
Section 35
Section 36

Other editions - View all

Common terms and phrases

About the author (2016)

Bruce is a veteran IT practitioner with 30+ years as CIO, Chief Architect, and many other roles—mainly in large global enterprises such as Motorola and Lucent. With expertise in each of Google, Microsoft and Oracle technologies, his main interest is in integration.

For a number of years he has been running a range of popular sites and blogs providing advice and assistance on transition connectivity.

Bruce is a GDE (Google developer expert) specializing in Apps Script.

Bibliographic information