Obtaining auth code grant type OAuth 2.0 tokens for Google APIs with a script
I wanted to programmatically append rows to a Google Spreadsheet recently. For this I needed to use the spreadsheets.values.append method in the Sheets API v4. The API resources are protected, and...
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...
Gmail Contextual Gadgets - talk at Manchester GTUG
I gave a talk at the Manchester Google Technology User Group March meetup on Gmail Contextual Gadgets. Partly so I can keep track of what slides I’ve used where, and partly to share them with a wider...
Google Visualization API: Manchester GTUG Talk
I gave a talk at this month’s Manchester Google Technology User Group meetup on the Google Visualization...