Appsscript
Google Cloud Functions + Sheets + Apps Script + Actions On Google = WIN
Sometimes, a perfect storm of technology comes along. I'd recently been teaching myself about Google Cloud Functions, and had created a function to service our Untappd beer searches in the #craftbeer...
Fiori App Data into a Spreadsheet? Challenge Accepted!
In October last year, following the original meta SAP Fiori App ;-), SAP announced their own long-awaited SAP Fiori Apps Reference Apps Library. At the time, Brenton and I chatted about it in “SAP...
Quick hack: Calendar Inviter
Working in different organisations sometimes means having different email addresses and calendars. Currently I have two Outlook instances I have to manage (one for Bluefin and one for a client) on top...
SheetAsJSON - Google Spreadsheet Data as JSON
This is a short post to explain how to expose a 'typical' Google spreadsheet (rows of columnar data, with first header row) as JSON, via HTTP. It might sound somewhat esoteric but believe me it’s...
Reading List Mark 2 - Part 5
This is Part 5, the last part in a series about an example app that I put together to demonstrate and describe the use of various Google Apps Script features. See Part 1 for an introduction. This part...
Reading List Mark 2 - Part 4
This is Part 4 in a series about an example app that I put together to demonstrate and describe the use of various Google Apps Script features. See Part 1 for an introduction. This part is...
Reading List Mark 2 - Part 3
This is Part 3 in a series about an example app that I put together to demonstrate and describe the use of various Google Apps Script features. See Part 1 for an introduction. This part is “Using the...
Reading List Mark 2 - Part 2
This is Part 2 in a series about an example app that I put together to demonstrate and describe the use of various Google Apps Script features. See Part 1 for an introduction. This part is “Using the...
Reading List Mark 2 - Part 1
Over on the Google Apps Scripts articles section of the Google Code site there’s a great article “Integrating with Google APIs – Creating a simple reading list” which takes the reader through a nice...
Automated email-to-task mechanism with Google Apps Script
Last night at the Manchester Google Technology User Group (GTUG) meetup we looked in detail at an example script that used various Google Apps Script services. More on that another time. At the end of...
Ad-hoc Data Workflows with Google Apps Script
At tonight’s Manchester Google Technology User Group’s meetup at Madlab, I gave a talk on building ad-hoc data workflows with Google Apps Script. The Google Apps application set, combined with the...