TU13: Google Sheets Developer Metadata

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):

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

• Sheets Developer Meta Data - Apps Script advanced service

• Demo source code (Github)

• Sheets Meta Data Advanced service library utilities

• Keeping track of columns for onEdit triggers using sheets metadata

• Use Drive properties to find app files

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

• Session Slides