Adding an unsubscribe link to the Google Workspace Solution Gallery ‘Mail merge using Gmail and Google Sheets’

Recently I came across a nice post from Ravgeet Dhillon, which looked at how to Add Unsubscribe link in emails using Google Apps Script. The solution uses a Google Sheet and a Google Apps Script web app to add an unsubscribe link to emails. As I noted when shared via AppsScriptPulse this is a useful addition if your mailing needs comply with PECR or similar electronic communications regulation compliance.

Having recently updated my ‘Create a mail merge using Gmail and Google Sheets’ in the Google Workspace Solution Gallery to handle inline images I thought it would be useful to show how this example can be extended to include a variation on Ravgeet’s post.

Recording a macro to modify a pivot

Working with Pivot Tables in Google Sheets using Google Apps Script

Pivot tables are a quick and powerful way to analyse data. Using Google Apps Script, there is an ability to build and modify pivot tables in Google Sheets. In this post I’ll share some tips and tricks for interacting with pivot tables in Google Sheets.

Recording an AutoFill with the Macro Recorder

Adding some AutoFill magic to your Google Sheets Apps Script projects

Google Sheets users can already use the magic of AutoFill to expand data automatically detecting a series of numbers, letters or dates. This feature is particularly powerful even when your series includes text or repeating dates. In this post I’ll highlight how you can also use AutoFill in your Google Apps Script projects

Google Sheets charts in your inbox

Dashboards in your inbox – Revisting tips on emailing inline Google Sheet chart images with Google Apps Script

Back in 2015 I shared a post on Tips on emailing inline Google Charts from Sheets using Apps Script, which looked at how you can email charts from Google Sheets. This solution is one I use in my work on a daily basis and remains largely unchanged. More recently I was faced with the problem that I couldn’t include a Combo Chart. In this post I revisit this problem and share a solution for including copies of your Google Sheet charts in your email reports.

Mail merge steps

A bulk email/mail merge with Gmail and Google Sheets solution evolution using V8

Last year I had a ‘mail merge using Gmail and Google Sheets’ contribution accepted on the G Suite Developers Solution Gallery. Just over 6 months on there has been lots of useful feedback and requests for solutions to some of the limitations of the original published script. In the meantime Google has also made the new V8 runtime for Google Apps Script generally available. Given this it seemed appropriate to revisit the original solution updating it for V8 as well as covering the most commonly asked for changes. In this post I’ll highlight some of the coding changes as well as some easy modifications.

VLOOKUP in action

Tips for using Google Sheets for event programme planning

At the Association for Learning Technology (ALT) hosting large events is a regular activity and over the years we have developed bespoke workflows largely based in Google Sheets. In this post I’m going to share some of the tips we use for scheduling our events including drafting/publishing an event programme and how to keep in touch with your presenters.

Example JSON output

Google Apps Script Patterns: Writing rows of data to Google Sheets the V8 way

Currently one of the most popular posts on this site is my Google Apps Script Patterns: Writing rows of data to Google Sheets. Given Google’s recent announcement of the general availability of the new V8 runtime I thought it was worth revisiting this particular pattern and using the modern syntax now available to Google Apps Script developers.

Human Data Interaction … and spreadsheets

Human Data Interaction … and spreadsheets: Retaking ownership in the age of surveillance

… if you enjoy this post you might want to register for the online SheetsCon conference 11th – 12th March 2020. Registration is free and there is a great lineup of speakers … and me 😉 On Friday I had the honour of speaking at a @HDINework workshop in Edinburgh for ALT with my boss […]

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.

Next Page »
css.php