TU13: Google Sheets Developer Metadata

Full Show

Show Notes

Broadcast Date: 20 October 2017

Presenters: Bruce Mcpherson, Martin Hawksey and Steve Webster

There haven been a number of Google Apps Script and related developments which reviewed in this episode of Totally Unscripted. As part of this Bruce Mcpherson provides a detailed overview of Google Sheets Developer Metadata. This can be used to abstract locations in a sheet (for example a "TOTALS" column), so that even if the target changes position, you can still find it.

Resources (see highlights below for links):

Highlights

Google Sheets Developer Metadata

Bruce Mcpherson provides a detailed overview of Google Sheets Developer Metadata. This can be used to reference locations of sheets, rows, columns and cells even if the sheet name and structure changes, so that even if the target changes position, you can still find it.

Related Resources

News and Community Spotlight - September 2017

The News and Community Spotlight from Totally Unscripted episode 13. As part of this we cover:

  • New Google Slides Service

  • Release Notes, including changes to OAuth Client Verification for Add-ons

  • Script Editor Updates

  • Firebase's new Cloud Firestore

  • Upcoming DevFest session

Resources