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.
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. […]
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.
Read how you can use your YouTube subtitle file as an easy way to create a video contents/jump list in YouTube video descriptions and G+ posts
I was recently asked me if I knew a way to create custom branching in Google Forms. The scenario was they had a list of employee names in a Google Sheet which they wanted to turn into a Google Form drop-down list which when selected would redirect the respondent to their own section of the form.
I recently had the pleasure of attending and presenting at MozFest 2017. MozFest had been on my bucket list to attend for a while and the event did not disappoint. My contribution to the event was a session as part of the web literacy space designed to introduce people to APIs. This post has more information and links to resources available for reuse
Details of how you can use a custom YouTube Data API library to interact with any YouTube account even if it’s owned by a Google+ page
Many years ago I posted a way you could open a Google Sheet at a specific row for editing. This let you do some url wrangling where you could direct […]
At the Association for Learning Technology (ALT) we use the open source CiviCRM for membership and events management. I’ve previously described how we are able to do Custom regular reporting […]
In this post I’ll show you how to make a searchable Twitter contributor map like the one below in a couple of clicks, however I feel it’s my duty to educate you first…