Monday Nov 18
11:30 –
12:20
A1

Work Less and Do More: Google Sheets for Developers

Slides:


This video is also available in the GOTO Play video app! Download it to enjoy offline access to our conference videos while on the move.

Available in Google Play Store or Available in Apple App Store




Say goodbye to the days of TPS reports, and come learn how to automate the tedious tasks in your work day. Thanks to the extensibility of Google Sheets (and a special JavaScript client library for Sheets), as well as Cloud Functions, that’s easy. You can have all kinds of data, for example GitHub, Jira, uptime health, and even sales data combined and imported into a Sheet, analyzed, and output as an email report or slide deck-without ever opening the Sheet.

What will the audience learn from this talk?
How to use the Sheets/Docs/Drive/Gmail API. We all deal with spreadsheets at least every once in a while. Use those tasks as an excuse for mini coding projects that actually make your life easier. Something new to do with JavaScript.

Does it feature code examples and/or live coding?
Code examples, probably no live coding

Prerequisite attendee experience level:
Level 200

UX/UI
programming
DevOps
productivity
observability
agile