> Am I correct to think of this as a VBA for Google Apps?
It is kind of like that, except that its JavaScript and not Visual Basic, and you can use it for "standalone scripts" and "web apps" in addition to scripted functionality for Google Apps (Docs, Sheets, Forms, and Sites).