For some years now I’ve been writing this annual summary around Christmas time, on how my year in Apps Script has been. I’m very late this year, but it’s been a pretty busy one both for me and for Apps Script. In fact its been the busiest year ever for both of us.
Google Developer Experts (GDE) program
I’ll be referring to a few of my fellow GDES in this article. When I first was invited to join this program some years back, there were only a handful of Apps Script GDE members, today there are 19, which demonstrates the importance that Google are attaching to the G Suite platform.
What’s been happening in Apps Script
- The Charts service has a whole range of new charts, as well as server side rendering for embedded charts
- The Sheets service has many new formatting (such as banding) and data aggregation (such as pivot table) methods to try to make available to Apps Script most of the things you can do in the UI.
- Macros are now available in Sheets, which allow you record a set of actions, or import a script and bind it to a shortcut key sequence. The new methods mentioned above would have been required to make Macros possible I imagine. Macros are very popular in Excel (probably why they’ve appeared in Sheet), and were often used a shortcut for learning VBA (badly). Personally I’ve never been a fan, and sensibly, the Apps Script macro code is less visible. Use them with caution.
- Spreadsheet Developer metadata was enabled in the standard Sheets service. I wrote about this capability when it first appeared in the API a couple of years ago, and is a great tool to keep track of data moving around in sheets when implemented in an add-on
In and out of Google Apps Script
- All things Kubernetes on Google cloud platform
- Google Spanner/ CockroachDB
- GraphQL and Apollo
- VueJs and React
- Cloud Vision, BigQuery, Machine learning, and other APIS