I'd definitely have to agree with the caveats having used App Script a fair bit w/ various Google Spreadsheets. The documentation is thin and you'll find lots

I'd definitely have to agree with the caveats having used App Script a fair bit w/ various Google Spreadsheets. The documentation is thin and you'll find lots of long-standing issues only through digging through various support/group threads, the debugging is obtuse and unsuitable for triggered actions - there's no logging. The killer though is that the performance/rate limiting is crap - as your document gets bigger, your functions will fail and time-out semi-randomly, even if you're not making a significant # of API calls. Presumably this is because of the way that GDocs are XML streams internally - but even doing single getsheets in calls (no cell iterating) seems to cause problems. I couldn't find good caching/global storage mechanisms in the past - but hadn't seen ScriptDB before, so maybe that can help (storing in scratch sheets doesn't help since you need to use the API calls to get that stuff) Anyway just some of my experiences for those who are interested in working w/ App Script for Google Spreadsheets. It's been years since I touched any Excel Macros, but they worked a lot better than my experience w/ App Script.