Tips, tricks and scripts for automating your Gmail inbox with Google Apps Script
This is a repost of an editorial piece I shared on AppsScriptPulse One the powerful features of Google Apps Script is with a couple of lines of code you can quickly start automating and organising your inbox. For people just getting started with Apps Script Google provide a introductory codelab ‘Accessing Google Sheets, Maps, and Gmail […]
Google Apps Script developer notes on using the new Google Forms REST API
Google recently announced the general availability of the new Google Forms API. For developers familiar with Google Apps Script for some time it has been possible to create, access, and modify Google Forms through the Forms Service. In this post I will highlight why Google Apps Script developers might want to use the new Forms API and some resources I’ve found useful for working with the new API in Apps Script projects. As part of this I’d like to share my experience of using the Forms API within a Google Forms Add-on and some factors to consider if you are particularly interested in watching for Google Form edits.
Fusion Thoughts (March 2021) – It’s been emotional …
There is probably an entire blog post or research paper that could be written around emotional intelligence and engagement in fusion learning. The challenge, how to design learning and environments that support our ability to connect with the moment, but here are some links/resources that have caught my eye
A SyntaxHighlighter Evolved WordPress plugin for Google Apps Script contributors
With my published content I like to include useful code snippets. As I published on a self-hosted WordPress blog I’ve used plugins to help format the code to make it easier to understand and also aesthetically look nice. In this post I share a WordPress plugin I’ve developed for Google Apps Script syntax highlighting.
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.
From Association for Learning Technology to Edinburgh Futures Institute
After 7+ years working for the Association for Learning Technology (ALT) late last year my decision to leave the organisation was announced. My personal reflections and beginnings as Learning Design and Technology Lead at the Edinburgh Futures Institute.
Everything you ever wanted to know about Gmail draft inline images and Google Apps Script but were afraid to ask
A common workflow solution in Google Apps Script is to use a Gmail draft message as a template for sending emails. For the user the benefit is they can draft a message in a familiar environment adding formatting without having to worry about writing HTML. A problem often encountered is the inclusion of inline images. This post looks at solving the issue of missing inline images.
Virtual Teams: Sharing our approach to leading a virtual team and surviving a pandemic – special podcast episode
So this month we are recording a special podcast episode, a reflective conversation about working from home, leading a virtual team… the ups and the downs… our best tips and tricks and also some of the highlights we have written about together over the past three years.
Totally Unscripted Exclusive: Detailed look at the new Google Apps Script IDE/Script Editor and launch
In the episode we broke the exclusive news that the new Script Editor will be rolling out to all users starting on 07 December 2020. I can’t thank Keith enough for taking the time out to share this news to the Totally Unscripted audience first and also to Charles for making possible as well as providing an expert tour of the new Apps Script Editor.