Google Sheets

Mail Merge

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.

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.

Machina a machina: An introduction to APIs with Google Sheets

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