I’m sure anyone that reads this is familiar with Google, and has at least heard of Google Sheets and Google Docs. Both being very handy personal or business tools for document and spreadsheet collaboration.
I discovered Apps Script while working on some reports in Google Sheets for my current employer. I needed some functionality that was fairly hard to reproduce as a single celled formula and eventually found my way into the script editor, a cloud based IDE provided by Google for developing, debugging, and running Apps Script. At the time, I had never before used JS or any dynamic prototype based language, but after some fiddling (and learning how to not declare static types) I managed to get a custom function working.
It’s amazingly versatile, here is an already in use scenario:
- Automatically parse CSV data from zipped email attachments
- Filter and validate the data
- Warehouse the data in Cloud SQL, Fusion Tables, or a spreadsheet
- Provide on-demand reports and charts on both a spreadsheet and a web app
- Do all of this automatically without human intervention
What you can do:
This is just an introduction to my thoughts on Google Apps Script. I’ve been diving into Apps Script for almost a year and will be sharing my experiences and tools over the coming weeks, including full sources and working apps with obfuscated production data.