How to Send HTML Email from Google App Scripts. Line by line code walk-thru
This is an example, with code, that demonstrates how we send weekly email reports from my client's reporting dashboard. Uses Google App Scripts and an HTML Template.
I attempt to walk through the code fairly carefully. No need for you to watch me code as much as understand the code you are viewing.
Questions? Leave them in the comments. Consider liking, sharing, and all the other fun stuff.
The report is part of a larger application that lets management create the script, add sales people, clients, and other data from Airtable. For more information look at my video on building an Airtable Report Dashboard using Google App Scripts, Sheets, BigQuery, and Google Data Studio.
Additionally, to get the code and a link to a Google Sheet with the report and the code, visit my blog at:
https://thegoogleautomator.substack.com
More info about me, my consulting, my music, etc.
I am a consultant, author, songwriter, etc. I build data analytics and business automation systems for clients. My work for 20+ years was focused on Microsoft VBA, SQL Server, Power BI, etc. Over the past few years I've taken more and more Google App Script, Google BigQuery/Cloud, and Google Data Studio projects. I enjoy them a LOT and intend to focus there.
As a songwriter, my music is roughly classified as Modern Americana - not overly rootsy. Acoustically driven rock and roll, some country elements, with a focus on lyrical cadence.
My official artist channel on YouTube and my music website can be found here:
/ @matthewmoranmusic
&
https://MatthewMoranOnline.com