Mail Merge

Google Apps Script Patterns: Celebrating 10 years by revisiting mail merge/bulk emailing

TL;DR A new solution for creating and distribute visually rich bulk emails with Gmail and Google Sheets. On 19 August 2019 Google Apps Script celebrated 10 years of general access. Apps Script has come a long way in the 10 years as you can see from the announcement blog post and launch video also embedded […]

Google Apps Script Patterns: Writing custom formulas/functions and handling single and range inputs

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.

G Suite, Apps Script and App Maker posts from Google Next ’19

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 was going on in the world of G Suite, Apps Script and App Maker. Fortunately my fellow Experts have been busy sharing their discoveries so […]

An introduction to building Google Hangouts Chat bots with Google Apps Script

This post is designed to give an overview of Google Hangouts Chat bot development with Google Apps Script.

Google Apps Script Patterns: Creating conversational interfaces with Dialogflow

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 Script projects. Dialogflow is now owned by Google and it already integrates with a number of its existing services like Cloud Speech-to-Text. Dialogflow isn’t limited […]

Introduction to building conversational interfaces with Dialogflow in Google Apps Script powered Google Hangouts Chat bots

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.

A Bitly shim for UrlShortener service in Google Apps Script

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 Advanced Service in Google Apps Script and so far I’ve seen no news that a FDL service will be created in its place. In this post find out how you can keep using UrlShortener but with the Bitly service.

Notes on the future of Google Apps Script from Google Cloud Next ‘18 #GoogleNext18

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

GDPR compliance in Google Apps Script and G Suite Add-ons: Your add-on uses personal data – 12 steps to take now

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

GDPR compliance in Google Apps Script and G Suite Add-ons: Should you be concerned?

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

« Previous PageNext Page »
css.php