Custom functions have been in Google Apps Script since it’s public launch in 2009. These let you extend Google Sheets function list allowing you to create and share your own spreadsheet formula. The official Google Developer docs for Custom Functions are very comprehensive and in this post I just want to highlight one pattern for detecting and handling user inputs.
I was unfortunately unable to attend Google Cloud Next ‘19 this year because of other work commitments. Attending last year was a great opportunity to both hear and discover what […]
This post is designed to give an overview of Google Hangouts Chat bot development with Google Apps Script.
In a recent episode of Totally Unscripted I demonstrated how you can use the Dialogflow service as a way to allow you to add conversational interfaces to your Google Apps […]
In this blog post I’m going to show you how you can use Google Dialogflow in your Google Hangouts Chat bots to easily create AI powered conversational interfaces.
In March 2018 Google announced it was closing it’s Google URL Shortener giving developers one year to migrate to their new Firebase Dynamic Links (FDL) service or other providers. The URLShortener is also an […]
At Google Cloud Next ‘18 it was great to see and hear about a number of G Suite and Google Apps Script updates. This post highlights a number of launched and future developments for Google Apps Script
If your G Suite Add-on or Apps Script project needs to add personal data protection this post identifies 12 steps you can take now
This post looks at key definitions to help you identify if you G Suite Add-on or Google Apps Script project needs to consider personal data protection
In this post I’ll show you some patterns you can use for using Google Analytics client side in HTMLService and server side with any Google Apps Script code you are running backend. As part of this I include GATrack, a Google Analytics tracking helper class for Google Apps Script