Send bulk emails with personalised images in G Suite using Google Apps Script

Earlier in the year I managed to get a bulk emailing script published in the G Suite Developer Solutions Gallery. In this post I want to show you how you can extend this script so that you can send personalised images using Gmail, Sheets and Slides. Before you get too excited about the potential of […]

Using Google Slide speaker notes to prepare tweet text

Hacking Google Slides as a voice enabled presentation tool using Google Apps Script

I always enjoy presenting at DevFest as usually it is a reason to explore something new. In the case of DevFest London it was an opportunity to think about how voice interfaces could be used as part of a Google Slide presentation. In this post I’ll share some of the ideas I explored and how they did/didn’t work out.

Google Apps Script Video Shoot - photo by Charles Maxson

My personal how/why/what of Google Apps Script

Recently I had the opportunity to be interviewed as part of a marketing video that is being pulled together by Google to promote Google Apps Script. This post has the notes I prepared for the video shoot

Mail Merge

Repost: Sending bulk email (mail merge) using Gmail and Google Sheets

Simplify the process of producing visually rich mail merges using Gmail and combining it with data from Google Sheets. With this solution you can automatically populate an email template created as a Gmail draft with data from Google Sheets. Merged emails are sent from your Gmail account allowing you to respond to recipient replies.

Apps Script Pulse Homepage

Apps Script Pulse – Sharing Google Apps Script community content

Apps Script Pulse is a new space to keep up-to-date with the latest contributions from the Google Apps Script community. Pulse is designed to compliment other community spaces – with the Apps Script Stack Overflow site supporting Q&A, the Apps Script Google Group providing a discussion space and the new G Suite Solutions Gallery providing […]

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 […]

« Previous PageNext Page »
css.php