Going GAS
From VBA to Google Apps Script
Publisher: O'Reilly Media
Final Release Date: February 2016
Pages: 456

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
Table of Contents
Product Details
About the Author
Recommended for You
Customer Reviews

REVIEW SNAPSHOT®

by PowerReviews
oreillyGoing GAS
 
4.5

(based on 2 reviews)

Ratings Distribution

  • 5 Stars

     

    (1)

  • 4 Stars

     

    (1)

  • 3 Stars

     

    (0)

  • 2 Stars

     

    (0)

  • 1 Stars

     

    (0)

Reviewed by 2 customers

Displaying reviews 1-2

Back to top

(2 of 2 customers found this review helpful)

 
5.0

Must Read!

By Anoubis

from Saint Petersburg, Russia

About Me Developer, Sys Admin

Verified Reviewer

Pros

  • Accurate
  • Concise
  • Helpful examples
  • Well-written

Cons

    Best Uses

    • Expert
    • Intermediate

    Comments about oreilly Going GAS:

    It has changed my vision about the Google Scripts.

    (4 of 4 customers found this review helpful)

     
    4.0

    Easy to understand, very practical

    By Holger Keller

    from Bretten

    About Me Developer

    Verified Reviewer

    Pros

    • Accurate
    • Concise
    • Easy to understand
    • Helpful examples
    • Well-written

    Cons

      Best Uses

      • Expert
      • Intermediate
      • Novice
      • Student

      Comments about oreilly Going GAS:

      You can not imagine the value of this book if you have not been through the pain of learning Google Apps Script the hard way. Even if you know Google Apps Script, you will have plenty of well structured lessons, to speed up becoming a professional GAS developer.

      Bruce has a deep understanding of architecture, design and implementation of complex apps. You may have a different style, but his approach is proven to be successful. Even if the book would not be well structured, it would be easy to benefit because of the examples. Every aspect that is critical for stability of the scripts is covered. In many cases I have found inspiration to improve something, e.g. how exponential backoff should be used, how to organize the namespace, write classes etc.

      Google Apps Script is not a regular tool, it is best applied in collaborative use cases. If you do not keep this in mind, you will probably miss the point and the strategic advantage of Google Apps for Work.

      We are greatful to Bruce Mcpherson and will use this book to educate new team members.

      Displaying reviews 1-2

      Back to top

       
      Buy 2 Get 1 Free Free Shipping Guarantee
      Buying Options
      Immediate Access - Go Digital what's this?
      Ebook:  $29.99
      Formats:  DAISY, ePub, Mobi, PDF
      Print & Ebook:  $38.49
      Print:  $34.99