Send Digest Per Owner
One big “open items” email to the whole team gets ignored. One short email per person, listing only their rows, gets read…
7 posts tagged with “email”
Fill Html Template
Building approval emails and HtmlService notices by concatenating strings is how < in a client name becomes a broken page — or worse…
HTML Table From Objects
Digest emails beat screenshots of a sheet. htmlTableFromObjects(rows, columns) turns an array of objects into a simple escaped <table> you…
Normalize an Email Address
Upserts and sheet lookups miss rows when one person typed Ada@Example.com and another stored ada@example.com. normalizeEmail trims…
Send an HTML Email with GmailApp
GmailApp.sendEmail can send HTML — you just need htmlBody (and a plain-text fallback for picky clients). This helper wraps the options bag…
Sending Emails Using Apps Script
The built-in libraries in Google Apps Script makes sending emails extremely easy. By default, you have two libraries to choose from: MailApp…
How to Automate Emails Through your Google Sheet
Ever wish you could automatically notify your colleagues of important changes you've made to a Google Sheet? Or maybe notify a client when…